Intermittent DB Timeout Errors from Postgrex on AWS RDS

Should probably turn on the query logger as well as EXPLAINing the query to start with.

Do you mean, like, enable debug: true?

Heh, I mean on the PostgreSQL Server itself, I’m pretty sure this will be standard SQL server debugging rather than anything Elixir specific (though it’s possible, I find it highly unlikely).

I have same problem. Not slow query takes too much time more than timeout setting.

I haven’t solved this problem and not found out a hint to solve.

What hint did you find out?

No no. I meant I didn’t find any hint. Sorry.

In your config xxxx.exs do something like the following.

use Mix.Config

config :db_name, App.Repo,
  adapter: Ecto.Adapters.MySQL,
  username: "",
  password: "",
  database: "",
  hostname: "",
  port: "",
  pool_timeout: :infinity,
  timeout: :infinity

Try the :infinity

I’m sure that would do the trick, but it would just address the symptom. I’m trying to uncover the source of the problem. If I figure it out I’ll post it up here.

That problem also happened to one my project, but the conn is to external network, so my guess is something about slow TCP handshake.

But yours maybe something about conn pool maxed out.

That’s what I’m thinking.