perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lev Lvovsky <...@sonous.com>
Subject Re: DBI AutoCommit goes away when db connection is killed
Date Tue, 28 Nov 2006 07:23:35 GMT
I forgot to mention also that we're not using a startup.pl file, but  
instead connecting to the DB several times using several different  
accounts as a specific virtual host requires.  At the risk of  
pointing out the answer for myself, does this adversely affect anything?

thanks,
-lev

On Nov 27, 2006, at 10:45 PM, 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!
>
> 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.
>
> 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).
>
> thank you for any help you might shine on this!
> -lev


Mime
View raw message