Description:
stop slave io_thread, causes io_thread to stop in the middle of a transaction which spins sql_thread indefinitely.
stop slave io_thread should complete the current transaction, and then abort io_thread.
Relay log status
# at 374263493
#100525 1:01:02 server id 1653179955 end_log_pos 374263413 Query
thread_id=151497650 exec_time=0
error_code=0
SET TIMESTAMP=1274749262/*!*/;
BEGIN
/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
Master binlog extract (dbmaster1_live_media_sp2.000390)
-------------
# at 374263333
#100525 1:01:02 server id 1653179955 end_log_pos 374263413 Query
thread_id=151497650 exec_time=0
error_code=0
SET TIMESTAMP=1274749262/*!*/;
BEGIN
/*!*/;
# at 374263413
#100525 1:01:02 server id 1653179955 end_log_pos 374263843 Query
thread_id=151497650 exec_time=0
error_code=0
SET TIMESTAMP=1274749262/*!*/;
REPLACE INTO `sched_cache` SET `group`='resolvedScheduleSet-full', `key`='full',
`from_time`='2010-05-25 00:00:00',
`to_time`='2010-05-26 01:00:00', `data`='<?xml version=\"1.0\
" encoding=\"utf-8\"?>\n<ResolvedScheduleSet dbSnapShotTime=\"2010-05-25T01:01:02Z\"
fromTime=\"2010-05-25T00:00:00Z\"
toTime=\"2010-05-26T01:00:00Z\">\n</ResolvedScheduleSet>\n
'
/*!*/;
# at 374263843
#100525 1:01:02 server id 1653179955 end_log_pos 374263870 Xid = 846003619
COMMIT/*!*/;
How to repeat:
occurs randomly