Re: mysqli auto rollback on script termination
| From: | Martin Koch Andersen | Date: | Mon, 09 Oct 2006 11:20:38 +0000 |
| Subject: | Re: mysqli auto rollback on script termination | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-42517@lists.php.net to get a copy of this message | ||
Chris skrev:
It should be rolled back when a connection is lost or a transaction isn't explicitly committed.Can you find documentation on this specific issue anywhere? I think the same as you, but I find it odd, it is not documented. 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. -- Martin - http://925.dk "Shoot for the moon, even if you miss, you'll land among the stars."