Debian Codegraph @

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

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