Bug #43848 MySQL looses connection when ROLLBACK TO SAVEPOINT is issued
Submitted: 25 Mar 2009 0:36 Modified: 2 Apr 2009 13:09
Reporter: Hendri Kurniawan Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.67, 4.1.22-max-log OS:Linux (Red Hat)
Assigned to: CPU Architecture:Any
Tags: loose connection, rollback, transaction

[25 Mar 2009 0:36] Hendri Kurniawan 
Description:
When the following command was issued, MySQL client will loose its connection.

How to repeat:
START TRANSACTION;
SAVEPOINT save001;
ROLLBACK TO SAVEPOINT save001;
COMMIT;

Suggested fix:
-
[25 Mar 2009 1:01] MySQL Verification Team 
Thank you for the bug report. Could you please try the latest released version I couldn't repeat with current source server. Thanks in advance.
[2 Apr 2009 1:09] Hendri Kurniawan 
I wasn't able to replicate this on my own server either. I have encountered this issue probably more than a dozen times already. Some 5.0.67 were not affected.

Another version that had the same problem is 4.1.22-max-log, but again when I tried to replicate this on my own server, I wasn't able to. Unfortunately I do not have full server access, so I am not able to give you further information.

So I was thinking this is probably a configuration issue.

You can probably close this bug as "Not Reproducible"
[2 Apr 2009 13:09] MySQL Verification Team 
Thank you for the feedback.