travisf

travisf

Can't start application locally - failed to start child: Oban

I have an application which has always worked fine locally, and works well in production but today I’ve been trying to start it iex -S mix phx.server and I get this error message:

GenServer {Oban.Registry, {Oban, {:plugin, Oban.Plugins.Cron}}} terminating
** (DBConnection.ConnectionError) connection not available and request was dropped from queue after 2964ms. This means requests are coming in and your connection pool cannot serve them fast enough. You can address this by:

  1. Ensuring your database is available and that you can connect to it
  2. Tracking down slow queries and making sure they are running fast enough
  3. Increasing the pool_size (although this increases resource consumption)
  4. Allowing requests to wait longer by increasing :queue_target and :queue_interval

See DBConnection.start_link/2 for more information
...

Application scrivener exited: :stopped
** (Mix) Could not start application myapp_data: MyApp.Application.start(:normal, []) returned an error: shutdown: failed to start child: Oban
    ** (EXIT) shutdown: failed to start child: "accounting"
        ** (EXIT) shutdown: failed to start child: Oban.Queue.Producer
            ** (EXIT) exited in: GenServer.call(#PID<0.1122.0>, {:listen, [:insert, :signal]}, 5000)
                ** (EXIT) time out

I’m on the main branch, no changes. I don’t have any other beam instances running and just to be sure I ran killall -9 beam.smp. I’ve removed _build no luck.

I’ve had similar issues in the past but never this persistent and generally one of the above solves the issue.

Most Liked

sodapopcan

sodapopcan

lol, ya I’m having a bit of a day today and spending a lot of time on this forum.

I’m not sure as I don’t really have experience with Oban. Just reading the error, though, is/was there something shovelling a crapton of jobs onto the queue and it can’t handle it? Maybe try truncating the queue table? Otherwise, sorry for the noise, I’m not really sure :frowning:

sorentwo

sorentwo

Oban Core Team

Something is monopolizing all of your db connections and Oban isn’t able to make the necessary requests on startup. Cron only runs at the top of every minute, so it’s odd that it would affect booting.

You could try increasing the pool size, or don’t start Oban on application boot temporarily and see if the system can normalize.

That’s doubtful. Inserting jobs happens from application processes, not Oban’s, and an exception while fetching jobs would be from a Producer rather than Cron.

travisf

travisf

Apologies everyone it appears my dev.secrets.exs file had the wrong DB creds and was trying to connect to the production DB rather than my local instance! Thanks @sodapopcan and @sorentwo for your quick responses.

Where Next?

Popular in Questions Top

lastday4you
I wanted to check elixir version in phoenix because i found that my elixir is 1.5 but when i use Enum.chunk_by it said the function is un...
New
electic
Hi, I am new to Elixir. I am trying to use the DateTime component to insert a date into MySQL however the there seems to be no way to fo...
New
JeremM34
Hello, how can I check the Phoenix version ? Thanks !
New
mgjohns61585
Could someone help me? I’m making my first elixir program, number guessing game. I can’t figure out how to convert the user’s guess from ...
New
johnnyicon
Hi all, I’ve just started learning Elixir and Phoenix Framework, so please pardon my n00bness at this stage. I’m trying to use Postgres...
New
Fl4m3Ph03n1x
About me? ( if you have nothing better to do than reading about some random guy in the internet :stuck_out_tongue: ) Hello all, this is ...
New
itssasanka
Hi all, Trying to get some more clarity over utc_datetime and naive_datetime for Ecto: The documentation above suggests that while ...
New
dblack
I’ve got an issue with an app and I’ve no idea of how to troubleshoot it. I’m hoping someone here might have seen something similar. I p...
New
komlanvi
Hi everyone, I was playing with phoenix liveView but I run into an issue. I have a form and want to validate each input text when the te...
New
jononomo
For some reason my phoenix channels are working for me in my local dev environment, but as soon as I deploy via Docker, I get a 403 error...
New

Other popular topics Top

axelson
This post is a wiki (feel free to hit the edit button near the bottom right of this post to add your own changes!) This post collects co...
239 48342 226
New
skosch
To my knowledge, put_in, Map.update etc. all have the one limitation of not automatically creating intermediate keys when needed (for exa...
New
electic
Hi, I am new to Elixir. I am trying to use the DateTime component to insert a date into MySQL however the there seems to be no way to fo...
New
chrismccord
Phoenix 1.4.0 released Phoenix 1.4 is out! This release ships with exciting new features, most notably with HTTP2 support, improved deve...
688 31013 112
New
josevalim
Hi everyone, One of the features added to Elixir early on to help integration with Erlang code was the idea of overridable function defi...
New
freewebwithme
Using vs code and installed ElixirLS: support and debugger. And I got an error popped up on start up says Failed to run ‘elixir’ comma...
New
aalberti333
As the title describes, I’m trying to run Enum.map() over a list of key/value pairs, where the value is a map. My data looks like this: ...
New
ashish173
I am using Ecto timestamps with postgres, I can see the timestamps() use the :naive_dateime but for my use case I wanted to store the ti...
New
JakeBecker
TL;DR: I’ve just released an implementation of Microsoft’s IDE-independent Language Server Protocol for Elixir. It adds language support ...
1144 54120 245
New
vegabook
I’m brand new to Phoenix and I have stripped one of the demo applications to the bone. I just want to get an svg up on the screen. Here i...
New

We're in Beta

About us Mission Statement