I've tried connection_validator plugin, but as jami said, if Heroku restarts db, all connections are invalid and "Sequel::DatabaseDisconnectError: PG::ConnectionBad: PQconsumeInput() SSL connection has been closed unexpectedly" raises...
Dne čtvrtek 4. března 2021 v 18:53:28 UTC+1 uživatel [email protected] napsal: > Is there an extension which upon receiving a disconnect error (and only > that), will just retry with a different connection and/or just check every > single connection in the pool and toss them out if they are also > disconnected? > > Context is after a db restart, the pool's connections all don't work, so > we have to go through each one and get an error for each one. Whereas if on > the first disconnectError, we clear the pool after checking each connection > is bad, then fresh connections quickly come in and we stop erroring > immediately. > > On Thursday, February 18, 2021 at 11:58:56 PM UTC-8 Jeremy Evans wrote: > >> On Thu, Feb 18, 2021 at 11:39 PM '[email protected]' via sequel-talk < >> [email protected]> wrote: >> >>> Hello, >>> sometimes i am getting on Heroku "Sequel::DatabaseDisconnectError: >>> PG::ConnectionBad: PQconsumeInput() SSL connection has been closed >>> unexpectedly". Is there any way how to prevent this errors? Some connection >>> doctor plugin etc? >>> >> >> You can try the connection_validator extension: >> http://sequel.jeremyevans.net/rdoc-plugins/files/lib/sequel/extensions/connection_validator_rb.html >> >> Thanks, >> Jeremy >> > -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sequel-talk/e74f1b96-58af-4184-b26c-15028ef44936n%40googlegroups.com.
