On 10/25/06, Jeroen Houben <[EMAIL PROTECTED]> wrote: > Wilson Bilkovich wrote: > > On 10/25/06, Jeroen Houben <[EMAIL PROTECTED]> wrote: > >> Hi, > >> > >> Disclaimer: I'm pretty sure this isn't a mongrel issue, as I'm pretty > >> sure I had the same problem back in the lighty-fastcgi days.. > >> > >> After a postgres restart, my rails apps crash with this error: > >> > >> ActiveRecord::StatementInvalid (PGError: FATAL: terminating connection > >> due to a > >> dministrator command > >> server closed the connection unexpectedly > >> This probably means the server terminated abnormally > >> before or while processing the request. > >> : SELECT count(*) AS count_all FROM matches ): > >> > >> Strange thing is, after a do a page refresh everything works again. It's > >> like the connections are re-established and all is well. But I have to > >> do it for each application that is running, really annoying.. Does > >> anybody know what is going on here? > >> > > > > Yep. The Postgres connection adapter in Rails doesn't have the 'smart > > reconnect' code that was added to the Oracle adapter. > > The Oracle one contains a list of all the possible 'safe to reconnect' > > OCI error codes, and just goes ahead and does it if it encounters one > > of those. > > > > It would probably be fairly straightforward to add that feature to the > > postgres adapter. > > Right. Thanks for the update. I'd have a go at adding it myself but I > guess it's written in C, that rules me out :( >
Nope. It's all Ruby. Check out a copy of Rails, and look in: /activerecord/lib/active_record/connection_adapters/ To see how the Oracle adapter does it, open the oracle_adapter file, and look for LOST_CONNECTION_ERROR_CODES. _______________________________________________ Mongrel-users mailing list [email protected] http://rubyforge.org/mailman/listinfo/mongrel-users
