Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 include/stop_slave.inc
5 set @old_enabled= @@global.rpl_semi_sync_slave_enabled;
6 set @old_dbug= @@global.debug_dbug;
7 set global rpl_semi_sync_slave_enabled= 1;
8 connection master;
9 set @old_enabled= @@global.rpl_semi_sync_master_enabled;
10 set @old_timeout= @@global.rpl_semi_sync_master_timeout;
11 set @old_wait_point= @@global.rpl_semi_sync_master_wait_point;
12 set global rpl_semi_sync_master_enabled= 1;
13 set global rpl_semi_sync_master_timeout= 2000;
14 set global rpl_semi_sync_master_wait_point= AFTER_SYNC;
15 connection slave;
16 include/start_slave.inc
17 # Ensure slave connection is semi-simulate_delay_semisync_slave_reply
18 connection master;
19 connection slave;
20 #
21 # Initialize test data
22 connection master;
23 create table t1 (a int) engine=innodb;
24 include/save_master_gtid.inc
25 connection slave;
26 include/sync_with_master_gtid.inc
27 include/stop_slave.inc
28 set @@global.debug_dbug="+d,simulate_delay_semisync_slave_reply";
29 include/start_slave.inc
30 # Ensure connection is semi-sync
31 connection master;
32 connection slave;
33 connection master;
34 set @old_bgc_count= @@global.binlog_commit_wait_count;
35 set @old_bgc_usec= @@global.binlog_commit_wait_usec;
36 set @@global.binlog_commit_wait_count=1;
37 set @@global.binlog_commit_wait_usec=100000;
38 connection server_1;
39 set debug_sync= "commit_after_release_LOCK_log SIGNAL ddl_binlogged WAIT_FOR ddl_cont";
40 # T1 (DDL)
41 create table t2 (a int);
42 connect server_1_sync, localhost, root,,;
43 connection server_1_sync;
44 set debug_sync= "now WAIT_FOR ddl_binlogged";
45 include/save_master_gtid.inc
46 connection server_2;
47 set debug_sync= "now WAIT_FOR io_thd_at_slave_reply";
48 connection master;
49 set debug_sync= "commit_before_get_LOCK_after_binlog_sync SIGNAL mdl_binlogged WAIT_FOR mdl_cont";
50 # T2 (DML)
51 insert into t1 values (100);;
52 connection server_1_sync;
53 set debug_sync= "now WAIT_FOR mdl_binlogged";
54 # Both transactions binlogged and released LOCK_log, and are just before
55 # wait_after_sync()
56 set debug_sync= "now SIGNAL ddl_cont";
57 set debug_sync= "now SIGNAL mdl_cont";
58 connection server_2;
59 # slave_reply for DDL
60 set debug_sync= "now SIGNAL io_thd_do_reply";
61 # slave_reply for MDL
62 set debug_sync= "now WAIT_FOR io_thd_at_slave_reply";
63 set debug_sync= "now SIGNAL io_thd_do_reply";
64 # Reaping MDL..
65 connection master;
66 # ..done
67 # Reaping DDL..
68 connection server_1;
69 # ..done
70 #
71 # Cleanup
72 connection slave;
73 include/stop_slave.inc
74 set @@global.rpl_semi_sync_slave_enabled= @old_enabled;
75 set @@global.debug_dbug= @old_dbug;
76 include/start_slave.inc
77 connection master;
78 set @@global.binlog_commit_wait_count= @old_bgc_count;
79 set @@global.binlog_commit_wait_usec= @old_bgc_usec;
80 set @@global.rpl_semi_sync_master_enabled= @old_enabled;
81 set @@global.rpl_semi_sync_master_timeout= @old_timeout;
82 set @@global.rpl_semi_sync_master_wait_point= @old_wait_point;
83 drop table t1, t2;
84 include/save_master_gtid.inc
85 connection slave;
86 include/sync_with_master_gtid.inc
87 include/rpl_end.inc
88 # End of rpl_semi_sync_after_sync_coord_consistency.test