Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

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

by mpeters (Chaplain)
on Nov 16, 2007 at 16:02 UTC ( #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


Comment on Re^2: DBD driver has not implemented the AutoCommit attribute
Download Code
Replies are listed 'Best First'.
Re^3: DBD driver has not implemented the AutoCommit attribute
by Danny (Initiate) 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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://651251]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (3)
As of 2016-02-06 11:35 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How many photographs, souvenirs, artworks, trophies or other decorative objects are displayed in your home?





    Results (226 votes), past polls