Bug #330 If STOP SLAVE while slave is executing a transaction, position lost
Submitted: 26 Apr 2003 6:41 Modified: 26 Apr 2003 6:42
Reporter: Guilhem Bichot Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:4.0 OS:Any (all)
Assigned to: CPU Architecture:Any

[26 Apr 2003 6:41] Guilhem Bichot
If the SQL thread stops while executing a transaction (before executing the
COMMIT), then the position stored in relay-log.info is the position of the
query which was being executed, not the position of the BEGIN. Whereas
rollback has occured on the slave. So replication will later restart too far.

How to repeat:
[26 Apr 2003 6:42] Guilhem Bichot
Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 

fixed in 4.0.6