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