On Nov 28, 2006, at 6:18 AM, Perrin Harkins wrote:

/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/DBI.pm line 1668.

That's what it says when you're trying to do something to a $dbh that is not connected. Why are you killing the connection during a transaction? What are you trying to do?

we're trying to simulate a database outage for an application which needs to be able to fail gracefully, and come back up when the DB does. These errors can also be seen when the mysql server is restarted (connections get killed then too).

In the case that this happens, is there any way other than restarting the apache process to correct this issue (simply setting AutoCommit to 1 doesn't work as it's a tie'd variable).

You need to connect to a database before it will work again.

How do we explicitly do this with Apache::DBI maintaining the persistent connection from the beginning?

thanks!
-lev

Reply via email to