Amazon AWS RDS error

I want to use Amazon Aws RDS for my DB connection (PGSQL) and when I launch heroku run mix ecto.migrate I got an error :

Running mix ecto.migrate on ⬢ test... up, run.8200 (Free)
** (exit) exited in:<0.208.0>, {:checkout, #Reference<>, true, :infinity}, 5000)
    ** (EXIT) time out
    (db_connection) lib/db_connection/poolboy.ex:112: DBConnection.Poolboy.checkout/3
    (db_connection) lib/db_connection.ex:920: DBConnection.checkout/2
    (db_connection) lib/db_connection.ex:742:
    (db_connection) lib/db_connection.ex:1133: DBConnection.run_meter/3
    (db_connection) lib/db_connection.ex:584: DBConnection.prepare_execute/4
    (ecto) lib/ecto/adapters/postgres/connection.ex:93: Ecto.Adapters.Postgres.Connection.execute/4
    (ecto) lib/ecto/adapters/sql.ex:243: Ecto.Adapters.SQL.sql_call/6
    (ecto) lib/ecto/adapters/sql.ex:193: Ecto.Adapters.SQL.query!/5

Someone of you already had this error ? Thanks and sorry for my English


Looks like that your application, which is hosted on heroku, is unable to access the RDS database due to a connection time out. Have you correctly setup the database access in your RDS security group(s)?

You need to allow ip connections from your heroku environment.

1 Like