Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re^2: DBD driver has not implemented the AutoCommit attribute

by mpeters (Chaplain)
on Nov 16, 2007 at 16:02 UTC ( [id://651251] : note . print w/replies, xml ) Need Help??


in reply to Re: DBD driver has not implemented the AutoCommit attribute
in thread DBD driver has not implemented the AutoCommit attribute

Actually, I'm facing the same problem here. It looks like a problem in DBD::mysql.

Are you using local $dbh->{AutoCommit} = 0 anywhere?

Update:
I've tracked this down to a problem with DBD::mysql (most recent versions) and DBI > 1.53. DBI 1.54 had some pretty big changes in it's internals and it looks like in some cases this causes problems when the AutoCommit flag is changed in DBD::mysql. I'm still not sure why, but it sporadically causes the above error you're seeing.


-- More people are killed every year by pigs than by sharks, which shows you how good we are at evaluating risk. -- Bruce Schneier

Replies are listed 'Best First'.
Re^3: DBD driver has not implemented the AutoCommit attribute
by Danny (Beadle) on Dec 05, 2015 at 19:46 UTC
    I just saw this for the first time after many thousands of connects. DBI version 1.616 ($Revision: 14568 $), DBD::mysql version 4.019. Rerunning the the same script with the same options did not reproduce the message.