Oban crashing with RDS Proxy about oban HOT 5 CLOSED

You're correct, the Postgres notifier (and any Postgres Pub/Sub functionality) don't work with a database proxy.

Do other queries work with Oban.Repo? It's a light wrapper around your app's Repo that merely standardizes some options; I wouldn't expect Oban queries to differ.

Try the following query to check functionality:

import Ecto.Query

Oban.Repo.one(Oban.config(), last(Oban.Job))

Your stacktrace implies that connections are working, but the pool is overloaded. Has your average query time gone up from the proxy? Is your database pool large enough?

from oban.

@alvarezloaiciga Any update? If this isn't related to Oban, I'd love to close this issue out.

from oban.

@sorentwo sorry I got pulled into other things. Will run this tomorrow. One issue is that the app was crashing on start, after we added RDS Proxy.

from oban.

In lieu of more information, I'm closing this issue. We can reopen it in the future if there are more details!

from oban.

Hi @sorentwo we were able to fix this by adding ssl config in our DB connection. Found out that the error was:

[error] Postgrex.Protocol (#PID<0.1350.0>) failed to connect: ** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification) This RDS Proxy requires TLS connections

To fix we just added this to the repo config:

  ssl: true,
  ssl_opts: [
    versions: [:"tlsv1.2"]
  ],

from oban.