Debian Codegraph @

mysql-test/suite/rpl/r/rpl_sql_thd_start_errno_cleared.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 create table t1 (a int primary key, b int) engine=innodb;
5 insert t1 values (1,1);
6 include/save_master_gtid.inc
7 connection slave;
8 include/sync_with_master_gtid.inc
9 include/stop_slave.inc
10 set @save_innodb_lock_wait_timeout= @@global.innodb_lock_wait_timeout;
11 set @save_slave_trans_retries= @@global.slave_transaction_retries;
12 set @@global.innodb_lock_wait_timeout= 1;
13 set @@global.slave_transaction_retries= 0;
14 connection master;
15 update t1 set b=b+10 where a=1;
16 include/save_master_gtid.inc
17 connection slave1;
18 BEGIN;
19 SELECT * FROM t1 WHERE a=1 FOR UPDATE;
20 a b
21 1 1
22 connection slave;
23 include/start_slave.inc
24 include/wait_for_slave_sql_error.inc [errno=1205]
25 connection slave1;
26 ROLLBACK;
27 connection slave;
28 set @save_dbug = @@global.debug_dbug;
29 set @@global.debug_dbug= "+d,delay_sql_thread_after_release_run_lock";
30 include/start_slave.inc
31 set debug_sync= "now wait_for sql_thread_run_lock_released";
32 # Validating that the SQL thread is running..
33 # ..success
34 # Validating that Last_SQL_Errno is cleared..
35 # ..success
36 set debug_sync= "now signal sql_thread_continue";
37 # Wait for debug_sync signal to have been received before issuing RESET
38 set @@global.debug_dbug= @saved_dbug;
39 set debug_sync= "RESET";
40 # Cleanup
41 connection master;
42 drop table t1;
43 connection slave;
44 include/stop_slave.inc
45 set @@global.innodb_lock_wait_timeout= @save_innodb_lock_wait_timeout;
46 set @@global.slave_transaction_retries= @save_slave_trans_retries;
47 include/start_slave.inc
48 include/rpl_end.inc
49 # End of rpl_sql_thd_start_errno_cleared.test