CODEWITHSUNDEEP
mysqlperlmodule
blunders
blunders

Reputation: 3669

Suggestions for troubleshooting this Perl DBD::mysql error message?

"Issuing rollback() due to DESTROY without explicit disconnect() of DBD::mysql::db"

Unable to find any documentation related to the error, any suggestions?

Upvotes: 3

Views: 2525

Answers (2)

Miguel Prz
Miguel Prz

Reputation: 13792

It's important to do commit/rollback (i.e $dbh->commit;)after the insert/update/delete sentences in your SQL code, because you pass {Autocommit=>0} parameter in the database connection code. And, of course, you must do $dbh->disconnect before you finish your program

Upvotes: 5

Ashley
Ashley

Reputation: 4335

Your db connection, usually the $dbh in plain DBI code, needs to be disconnected before it goes out of scope. See DBI#disconnect and try putting "dbi disconnect" into google/etc to see related issues discussions.

Upvotes: 7

Related Questions