Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re: DBD driver has not implemented the AutoCommit attribute

by perrin (Chancellor)
on Sep 19, 2007 at 17:51 UTC ( [id://639948]=note: print w/replies, xml ) Need Help??


in reply to DBD driver has not implemented the AutoCommit attribute

That means you dropped your database connection at some point. Something is set up differently from your old host. I can't tell you what from the information you've provided.
  • Comment on Re: DBD driver has not implemented the AutoCommit attribute

Replies are listed 'Best First'.
Re^2: DBD driver has not implemented the AutoCommit attribute
by mpeters (Chaplain) on Nov 16, 2007 at 16:02 UTC

    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
      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.
Re^2: DBD driver has not implemented the AutoCommit attribute
by jerrygarciuh (Curate) on Sep 19, 2007 at 19:42 UTC
    Hi perrin,

    Thanks for taking a look. Could you tell me what information would be diagnostically helpful?


    TIA
    jg
    _____________________________________________________
    "Transport of the mails, transport of the human voice, transport of flickering pictures - in this century, as in others, our highest accomplishments still have the single aim of bringing people together."   Wind, Sand, and Stars
      Antoine-Marie-Roger de Saint-Exupery
      Well, if it works on the other system but not this one, I'd suggest you try to figure out what's different. One thing to check is the version of Ima::DBI you're using.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others exploiting the Monastery: (1)
As of 2024-04-16 14:53 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found