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
• Status: Closed
• Category: MySQL Server: Replication
• Severity: S3 (Non-critical)
• Version: 4.0
• OS: Any (all)
• CPU Architecture: Any

[26 Apr 2003 6:41] Guilhem Bichot

Description:
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 
http://www.mysql.com/downloads/

fixed in 4.0.6