I've got a case where my DBI connections appear to be timing out and not reconnecting. Google just points to the old timeout problem that should be solved.
I've set Apache::DBI::DEBUG to 2, and I'm not seeing _any_ messages (from it) in the error log. Apache::Status lists Apache DBI, but lists no database connections.
Advice most welcome
Perl version v5.6.1 for Apache/1.3.27 (Unix) AuthPG/1.2 mod_perl/1.27
Database is Postgres (I can dig up version, but it's recent but not most recent)
A long time ago, one problem used to be that if your connect to Postgres was idle for too long ( 8 hours ) the connection would timeout and give you these kinds of errors. One solution was to make sure that you hit a web page that has such a connection periodically, so that you keep the connection to the database active, just run in your cron an lwp-request ping to the web page in question and you should be fine.
This may not be related to your current problem, so YMMV.
Regards,
Josh ________________________________________________________________ Josh Chamas, Founder phone:925-552-0128 Chamas Enterprises Inc. http://www.chamas.com NodeWorks Link Checker http://www.nodeworks.com
-- Reporting bugs: http://perl.apache.org/bugs/ Mail list info: http://perl.apache.org/maillist/modperl.html
