> I recently noticed some strange error messages in my error_log. This is
> from animelyrics.com, which uses Apache::ASP and MySQL.
>
> Issuing rollback() for database handle being DESTROY'd without explicit
> disconnect() at (eval 9) line 22.
>
> The above line keeps repeating over and over in the error log. There are
> two things that confuse me...
>
> (1) I never use rollback() anywhere in my code... so I'm wondering if
> something else could cause a rollback.
>
I get the same problem if I don't explicitly disconnect from the database.
You can ignore this problem if you're just making SELECT queries. Also if
the MySQL version you're using doesn't use transactions then it
autocommits data by default. DBI is also autocommit by default. If
you're annoyed by the error. put a 'dbh->disconnect' at the end of your
scripts.
> (2) The "(eval 9) line 22" message doesn't tell me what file the error is
> in. The modperl guide suggested adding the following lines to my perl
> startup file so that the messages would show the correct file:
>
> use Carp ();
> local $SIG{__WARN__} = \&Carp::cluck;
>
> ...but they don't seem to have any effect after I added them and did an
> "apachectl restart".
>
> -Philip Mak ([EMAIL PROTECTED])
>
> .
> Mak ([EMAIL PROTECTED])
>
> .
>
--
Mike
