kansas-city-pm-list  

DBI error

Ben Kittrell
Wed, 21 Feb 2001 14:19:12 -0800

Hello, I have a quick question I was wondering if anyone could help me with.  I'm running a program using mod_perl(which I don't think is significant) that accesses a mysql database through DBI.  Every once in a while, without any apparent cause I get the following error.
 
Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at /usr/local/lib/perl5/site_perl/
I think it has something to do with subroutines, because it seems to stop when I comment them out.  The only I have been able to find about it on the web is that I need to use $sth->finish, which seems right, however, the weird thing is that all I have to do to stop the error is restart apache.  So I would think if it was a problem with my code it would happen all of the time.
 
If anyone has any thoughts on this I would appriciate it.
 
Thanks,
Ben Kittrell
Programmer
Bensoft Inc.