On Friday, March 13, 2020 at 11:55:26 AM UTC-7, BeeRich33 wrote: > > Hi there. > > On my dev box, upon opening a site, there's a report that a connection > dropped early and an ISE or other error came up. > > I just published and this error came up in the nginx log: > > 2020-03-13 14:53:18 - Sequel::DatabaseDisconnectError - PG::UnableToSend: > server closed the connection unexpectedly > App 17860 output: This probably means the server terminated abnormally > App 17860 output: before or while processing the request. > App 17860 output: : > > > Upon refresh/new query, it functions fine. > > Is there anything I can do about this? First connections need to be > established for following connections to happen? > > Cheers >
The issue is your connection to the database dropped. The easiest fix is to make sure that doesn't happen. If it is unavoidable in your environment, you can try using the connection_validator extension, which can check whether the connection is usable on checkout (by default, after 1 hour of idle time, but it can check every time). Sequel's behavior when a disconnect error is raised is to remove the connection from the pool and reraise the error. That is the only safe behavior. The next attempt to checkout a connection from the pool will result in making a new connection (assuming another connection isn't already available). 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/ceab206f-b16e-4bd4-a40e-0790fb1ef6a2%40googlegroups.com.
