MySQL Bugs: #330: If STOP SLAVE while slave is executing a transaction, position lost

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log

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:

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