Debian Codegraph @

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

raw
1 set global rpl_semi_sync_master_wait_point=AFTER_SYNC;
2 include/master-slave.inc
3 [connection master]
4 connection master;
5 call mtr.add_suppression("Timeout waiting for reply of binlog");
6 call mtr.add_suppression("Semi-sync master .* waiting for slave reply");
7 call mtr.add_suppression("Read semi-sync reply");
8 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.");
9 call mtr.add_suppression("mysqld: Got an error reading communication packets");
10 connection slave;
11 call mtr.add_suppression("Semi-sync slave .* reply");
12 call mtr.add_suppression("Slave SQL.*Request to stop slave SQL Thread received while applying a group that has non-transactional changes; waiting for completion of the group");
13 connection master;
14 set global rpl_semi_sync_master_enabled = 1;
15 connection slave;
16 include/stop_slave.inc
17 set global rpl_semi_sync_slave_enabled = 1;
18 include/start_slave.inc
19 connection master;
20 SET GLOBAL event_scheduler = ON;
21 CREATE TABLE t1 (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, f varchar(8)) ENGINE=ENGINE_TYPE;
22 INSERT INTO t1 (f) VALUES ('a'),('a'),('a'),('a'),('a');
23 INSERT INTO t1 SELECT i+5, f FROM t1;
24 INSERT INTO t1 SELECT i+10, f FROM t1;
25 CREATE EVENT ev1 ON SCHEDULE EVERY 1 SECOND
26 DO INSERT INTO t1 VALUES (SLEEP(5),CONCAT('ev1_',CONNECTION_ID()));
27 CREATE EVENT ev2 ON SCHEDULE EVERY 1 SECOND
28 DO INSERT INTO t1 VALUES (SLEEP(5),CONCAT('ev2_',CONNECTION_ID()));
29 connection slave;
30 STOP SLAVE IO_THREAD;
31 connection master;
32 connect m$run,localhost,root,,;
33 connection m20;
34 UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 20;
35 connection master;
36 connect m$run,localhost,root,,;
37 connection m19;
38 UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 19;
39 connection master;
40 connect m$run,localhost,root,,;
41 connection m18;
42 UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 18;
43 connection master;
44 connect m$run,localhost,root,,;
45 connection m17;
46 UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 17;
47 connection master;
48 connect m$run,localhost,root,,;
49 connection m16;
50 UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 16;
51 connection master;
52 connect m$run,localhost,root,,;
53 connection m15;
54 UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 15;
55 connection master;
56 connect m$run,localhost,root,,;
57 connection m14;
58 UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 14;
59 connection master;
60 connect m$run,localhost,root,,;
61 connection m13;
62 UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 13;
63 connection master;
64 connect m$run,localhost,root,,;
65 connection m12;
66 UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 12;
67 connection master;
68 connect m$run,localhost,root,,;
69 connection m11;
70 UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 11;
71 connection master;
72 connect m$run,localhost,root,,;
73 connection m10;
74 UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 10;
75 connection master;
76 connect m$run,localhost,root,,;
77 connection m9;
78 UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 9;
79 connection master;
80 connect m$run,localhost,root,,;
81 connection m8;
82 UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 8;
83 connection master;
84 connect m$run,localhost,root,,;
85 connection m7;
86 UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 7;
87 connection master;
88 connect m$run,localhost,root,,;
89 connection m6;
90 UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 6;
91 connection master;
92 connect m$run,localhost,root,,;
93 connection m5;
94 UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 5;
95 connection master;
96 connect m$run,localhost,root,,;
97 connection m4;
98 UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 4;
99 connection master;
100 connect m$run,localhost,root,,;
101 connection m3;
102 UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 3;
103 connection master;
104 connect m$run,localhost,root,,;
105 connection m2;
106 UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 2;
107 connection master;
108 connect m$run,localhost,root,,;
109 connection m1;
110 UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 1;
111 connection master;
112 connection master;
113 SET GLOBAL event_scheduler = OFF;
114 connection m20;
115 disconnect m20;
116 connection m19;
117 disconnect m19;
118 connection m18;
119 disconnect m18;
120 connection m17;
121 disconnect m17;
122 connection m16;
123 disconnect m16;
124 connection m15;
125 disconnect m15;
126 connection m14;
127 disconnect m14;
128 connection m13;
129 disconnect m13;
130 connection m12;
131 disconnect m12;
132 connection m11;
133 disconnect m11;
134 connection m10;
135 disconnect m10;
136 connection m9;
137 disconnect m9;
138 connection m8;
139 disconnect m8;
140 connection m7;
141 disconnect m7;
142 connection m6;
143 disconnect m6;
144 connection m5;
145 disconnect m5;
146 connection m4;
147 disconnect m4;
148 connection m3;
149 disconnect m3;
150 connection m2;
151 disconnect m2;
152 connection m1;
153 disconnect m1;
154 connection slave;
155 include/stop_slave.inc
156 set global rpl_semi_sync_slave_enabled = 0;
157 connection master;
158 set global rpl_semi_sync_master_enabled = 0;
159 connection slave;
160 include/start_slave.inc
161 connection master;
162 DROP EVENT ev1;
163 DROP EVENT ev2;
164 DROP TABLE t1;
165 connection slave;
166 include/rpl_end.inc
167 set global rpl_semi_sync_master_wait_point=default;