You can use DBIx::Class with DBIx::RetryOverDisconnects as DBI handle and you will never got db server away message (it will reconnect as long as required until database is up and no queries and transactions will be lost).
2008/6/18 Mitchell K. Jackson <[EMAIL PROTECTED]>: > Good afternoon, > > Is there a graceful way for a catalyst app to handle when the database > server goes away? If this happens while a process is holding open a > database connection it's already been using, there's not even a > database error to the log. The only error is "read data timeout in 40 > seconds", and an error 500 to the web browser. > > I would like my app to be able to deliver a more useful error to the > end user, such as "Lost database connection." If I can retain control > of the app in this event, I'll have it send me an sms for good > measure. Any ideas how I could go about this? > > Regards, > > /Mitchell K. Jackson > > _______________________________________________ > List: [email protected] > Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst > Searchable archive: > http://www.mail-archive.com/[email protected]/ > Dev site: http://dev.catalyst.perl.org/ >
_______________________________________________ List: [email protected] Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
