New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
disconnected: ** (DBConnection.ConnectionError) client #PID<0.368.0> timed out because it checked out the connection for longer than 15000ms #1658
Comments
Yes, increase the timeout value. It can be done in your repo configuration |
Is it also possible when executing raw SQL through the |
@madshargreave yes, in the fourth argument. :) |
Hey, I'm having problem with Elix syntax, is that right? Ecto.Migrator.run( (...) , :up, all: true, log: :debug, timeout: 60000) I'm having timout in that migration. =/ |
I don't think the timeout option is supported in the migrator, we default everything to infinity in there. Can you please show which error message are you getting alongside the stacktrace? |
@josevalim I see That's the error message:
Before the error, the log shows it running a bunch of queries normally. |
and the system is based on Ecto 2.0.5 (and phoenix_ecto ~> 3.0), its was set to infinity in wich version? 2.1? |
Oh, so this is another error. You have two options:
|
I've tryed alter the repository configuration in the following files whith the ownership_timeout, but i get the same error (timed out because it checked out the connection for longer than 15000ms). I've done it right? I'm new at the Elixir syntaxe: dev.exs
test.exs
prod.exs
and finally config.exs
|
guess, I solve this. Adding the 'timeout' and 'pool_timeout' in those files get it done .
There was a commit [] that was taking 18ms, rather than 15ms. I'm testing everything now. |
|
While increasing the timeout will work, I think this is an extremely important thread to read if you're encountering this issue. |
Environment
Elixir: 1.2.1
PostgreSQL 9.4
Ecto: 2.0.0-rc.6
OS: OSX
I have some long running queries that aggregate data into a separate table for certain specific analytics
However I am getting hit by
disconnected: ** (DBConnection.ConnectionError) client #PID<0.368.0> timed out because it checked out the connection for longer than 15000ms
Is there a way to lift this restriction?
The text was updated successfully, but these errors were encountered: