Re: mysqli auto rollback on script termination
| From: | Hodicska Gergely | Date: | Tue, 10 Oct 2006 21:22:00 +0000 |
| Subject: | Re: mysqli auto rollback on script termination | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-42524@lists.php.net to get a copy of this message | ||
Reason I'm asking is, I've seen some deadlock issues in a script (using FOR UPDATE and LOCK IN SHARE MODE), that looks like they are caused by transactions not being rolled back (releasing locks) correctly. Do you use pconnect? If I right remember there was a bug in some versionof mysql that in the case of using pconnect in some cases the automatic rollback didn't happen. The solution was: after pconnect one had to start with a rollback command. Regards, Felhő