Edit File: rpl_temp_error.test
# An auxiliary file for causing temporary error on slave SQL thread. --echo # [ on slave ] connection slave; BEGIN; --echo # It will lock table t1 on the row in which c1 is 1 until COMMIT or ROLLBACK UPDATE t1 SET c2= "slave" WHERE c1= 1; connection master; --echo # [ on master ] BEGIN; INSERT INTO t3 VALUES(1); eval $statement; eval UPDATE t1 SET c2='$statement' WHERE c1= 1; COMMIT; save_master_pos; connection slave; --echo # [ on slave ] let $slave_sql_errno= 1205; source include/wait_for_slave_sql_error.inc; ROLLBACK; START SLAVE SQL_THREAD; source include/wait_for_slave_sql_to_start.inc; sync_with_master;