Lev Lvovsky wrote:
Hello - this may be a question unrelated to mod_perl so much as it is
related to DBI and mysql, but any suggestions would be appreciated greatly!
What versions of Apache-DBI, DBI, mysql ?
In testing out persistent connections while using transactions, we've
noticed that while in a loop which continuously begins and ends a
transaction, killing the persistent connection which Apache::DBI is
maintaining causes the still-running handler to report things like:
error: DBD driver has not implemented the AutoCommit attribute at
/usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/DBI.pm line 1668.
In dumping the status of the handle after this has been done, the
AutoCommit flag is no longer there either.
$Apache::DBI::Debug = 2;
$dbh->trace('file', 4);
In the case that this happens, is there any way other than restarting
the apache process to correct this issue (simply setting AutoCommit to 1
doesn't work as it's a tie'd variable).
Seems like your Apache::DBI::ping() method is busted which I know was
been tweaked -1-2 times recently.
1.00_01 05/29/2006
- Fix a () bug in the connect() determining whether we must ping
the database. PingTimeOut = 0 now works as documented.
Submited by: [Joe Thomas <[EMAIL PROTECTED]>]
Contributed by: [Patrick Mulvany <[EMAIL PROTECTED]>]
Also, relating to AutoCommit being 'reset'
0.100 08/10/2005
- Move $Idx from a file-scoped variable to a connect() scoped
variable, which gets passed to other subroutines as needed.
This will ensure that the cleanup/rollback feature will work
properly when a script uses more than one database handle to the
same database.
[Joe Thomas <[EMAIL PROTECTED]>]
--
------------------------------------------------------------------------
Philip M. Gollucci ([EMAIL PROTECTED]) 323.219.4708
Consultant / http://p6m7g8.net/Resume/resume.shtml
Senior Software Engineer - TicketMaster - http://ticketmaster.com
1024D/A79997FA F357 0FDD 2301 6296 690F 6A47 D55A 7172 A799 97F
I never had a dream come true
'Til the day that I found you.
Even though I pretend that I've moved on
You'll always be my baby.
I never found the words to say
You're the one I think about each day
And I know no matter where life takes me to
A part of me will always be...
A part of me will always be with you.
