Hello - this may be a question unrelated to mod_perl so much as it is
related to DBI and mysql, but any suggestions would be appreciated
greatly!
In testing out persistent connections while using transactions, we've
noticed that while in a loop which continuously begins and ends a
transaction, killing the persistent connection which Apache::DBI is
maintaining causes the still-running handler to report things like:
error: DBD driver has not implemented the AutoCommit attribute at /
usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/DBI.pm line
1668.
In dumping the status of the handle after this has been done, the
AutoCommit flag is no longer there either.
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).
thank you for any help you might shine on this!
-lev