29 lines
623 B
Plaintext
29 lines
623 B
Plaintext
# 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;
|