Debian Codegraph @

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

raw
1 *** Set up circular replication on four servers ***
2 include/rpl_init.inc [topology=1->2->3->4->1]
3
4 connection server_4;
5 SET auto_increment_increment= 4;
6 SET auto_increment_offset= 4;
7 connection server_3;
8 SET auto_increment_increment= 4;
9 SET auto_increment_offset= 3;
10 connection server_2;
11 SET auto_increment_increment= 4;
12 SET auto_increment_offset= 2;
13 connection server_1;
14 SET auto_increment_increment= 4;
15 SET auto_increment_offset= 1;
16 *** Preparing data ***
17 connection server_1;
18 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT, b VARCHAR(100), c INT NOT NULL, PRIMARY KEY(a)) ENGINE=MyISAM;
19 CREATE TABLE t2 (a INT NOT NULL AUTO_INCREMENT, b VARCHAR(100), c INT NOT NULL, PRIMARY KEY(a)) ENGINE=InnoDB;
20 INSERT INTO t2 (b,c) VALUES('MDEV-515', 100);
21 include/rpl_sync.inc
22 connection server_4;
23 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");
24
25 *** Testing schema A->B->C->D->A ***
26
27 connection server_1;
28 INSERT INTO t1(b,c) VALUES('A',1);
29 connection server_2;
30 INSERT INTO t1(b,c) VALUES('B',1);
31 connection server_3;
32 INSERT INTO t1(b,c) VALUES('C',1);
33 connection server_4;
34 INSERT INTO t1(b,c) VALUES('D',1);
35 include/rpl_sync.inc
36 connection server_1;
37 SELECT 'Master A',a,b FROM t1 WHERE c = 1 ORDER BY a,b;
38 Master A a b
39 Master A 1 A
40 Master A 2 B
41 Master A 3 C
42 Master A 4 D
43 connection server_2;
44 SELECT 'Master B',a,b FROM t1 WHERE c = 1 ORDER BY a,b;
45 Master B a b
46 Master B 1 A
47 Master B 2 B
48 Master B 3 C
49 Master B 4 D
50 connection server_3;
51 SELECT 'Master C',a,b FROM t1 WHERE c = 1 ORDER BY a,b;
52 Master C a b
53 Master C 1 A
54 Master C 2 B
55 Master C 3 C
56 Master C 4 D
57 connection server_4;
58 SELECT 'Master D',a,b FROM t1 WHERE c = 1 ORDER BY a,b;
59 Master D a b
60 Master D 1 A
61 Master D 2 B
62 Master D 3 C
63 Master D 4 D
64
65 *** Testing schema A->B->D->A if C has failure ***
66
67 * Do failure for C and then make new connection B->D *
68 connection server_4;
69 STOP SLAVE;
70 SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
71 include/start_slave.inc
72 connection server_3;
73 INSERT INTO t1 VALUES(6,'C',2);
74 connection server_4;
75 connection server_2;
76 INSERT INTO t1(b,c) VALUES('B',2);
77 connection server_3;
78 call mtr.add_suppression("Slave SQL.*Duplicate entry .6. for key .PRIMARY.* error.* 1062");
79 include/wait_for_slave_sql_error.inc [errno=1062]
80 connection server_1;
81 INSERT INTO t1(b,c) VALUES('A',2);
82 connection server_4;
83 INSERT INTO t1(b,c) VALUES('D',2);
84 connection server_2;
85
86 * Data on servers (C failed) *
87 connection server_1;
88 SELECT 'Master A',a,b FROM t1 WHERE c = 2 ORDER BY a,b;
89 Master A a b
90 Master A 5 A
91 Master A 8 D
92 connection server_2;
93 SELECT 'Master B',a,b FROM t1 WHERE c = 2 ORDER BY a,b;
94 Master B a b
95 Master B 5 A
96 Master B 6 B
97 Master B 8 D
98 connection server_3;
99 SELECT 'Master C',a,b FROM t1 WHERE c = 2 ORDER BY a,b;
100 Master C a b
101 Master C 6 C
102 connection server_4;
103 SELECT 'Master D',a,b FROM t1 WHERE c = 2 ORDER BY a,b;
104 Master D a b
105 Master D 8 D
106
107 * Reconfigure replication to schema A->B->D->A *
108 connection server_3;
109 include/stop_slave_io.inc
110 connection server_4;
111 include/stop_slave.inc
112 include/rpl_change_topology.inc [new topology=1->2->4->1,2->3]
113 include/start_slave.inc
114 connection server_2;
115 connection server_4;
116 connection server_1;
117
118 * Check data inserted before failure *
119 connection server_1;
120 SELECT 'Master A',a,b FROM t1 WHERE c = 2 ORDER BY a,b;
121 Master A a b
122 Master A 5 A
123 Master A 6 B
124 Master A 8 D
125 connection server_2;
126 SELECT 'Master B',a,b FROM t1 WHERE c = 2 ORDER BY a,b;
127 Master B a b
128 Master B 5 A
129 Master B 6 B
130 Master B 8 D
131 connection server_3;
132 SELECT 'Master C',a,b FROM t1 WHERE c = 2 ORDER BY a,b;
133 Master C a b
134 Master C 6 C
135 connection server_4;
136 SELECT 'Master D',a,b FROM t1 WHERE c = 2 ORDER BY a,b;
137 Master D a b
138 Master D 5 A
139 Master D 6 B
140 Master D 8 D
141
142 * Check data inserted after failure *
143 connection server_1;
144 INSERT INTO t1(b,c) VALUES('A',3);
145 connection server_2;
146 INSERT INTO t1(b,c) VALUES('B',3);
147 connection server_4;
148 INSERT INTO t1(b,c) VALUES('D',3);
149 connection server_1;
150 include/rpl_sync.inc
151 connection server_1;
152 SELECT 'Master A',a,b FROM t1 WHERE c = 3 ORDER BY a,b;
153 Master A a b
154 Master A 9 A
155 Master A 10 B
156 Master A 12 D
157 connection server_2;
158 SELECT 'Master B',a,b FROM t1 WHERE c = 3 ORDER BY a,b;
159 Master B a b
160 Master B 9 A
161 Master B 10 B
162 Master B 12 D
163 connection server_3;
164 SELECT 'Master C',a,b FROM t1 WHERE c = 3 ORDER BY a,b;
165 Master C a b
166 connection server_4;
167 SELECT 'Master D',a,b FROM t1 WHERE c = 3 ORDER BY a,b;
168 Master D a b
169 Master D 9 A
170 Master D 10 B
171 Master D 12 D
172 connection server_1;
173
174 *** Testing restoring scheme A->B->C->D->A after failure ***
175
176 * Remove wrong event from C and restore B->C->D *
177 connection server_4;
178 include/stop_slave.inc
179 connection server_3;
180 DELETE FROM t1 WHERE a = 6;
181 include/start_slave.inc
182 connection server_2;
183 connection server_3;
184 RESET MASTER;
185 connection server_4;
186 RESET SLAVE;
187 Warnings:
188 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
189 include/rpl_change_topology.inc [new topology=1->2->3->4->1]
190 include/start_slave.inc
191 connection server_3;
192 connection server_4;
193 include/rpl_sync.inc
194
195 * Check data inserted before restoring schema A->B->C->D->A *
196 connection server_1;
197 SELECT 'Master A',a,b FROM t1 WHERE c IN (2,3) ORDER BY a,b;
198 Master A a b
199 Master A 5 A
200 Master A 6 B
201 Master A 8 D
202 Master A 9 A
203 Master A 10 B
204 Master A 12 D
205 connection server_2;
206 SELECT 'Master B',a,b FROM t1 WHERE c IN (2,3) ORDER BY a,b;
207 Master B a b
208 Master B 5 A
209 Master B 6 B
210 Master B 8 D
211 Master B 9 A
212 Master B 10 B
213 Master B 12 D
214 connection server_3;
215 SELECT 'Master C',a,b FROM t1 WHERE c IN (2,3) ORDER BY a,b;
216 Master C a b
217 Master C 5 A
218 Master C 6 B
219 Master C 8 D
220 Master C 9 A
221 Master C 10 B
222 Master C 12 D
223 connection server_4;
224 SELECT 'Master D',a,b FROM t1 WHERE c IN (2,3) ORDER BY a,b;
225 Master D a b
226 Master D 5 A
227 Master D 6 B
228 Master D 8 D
229 Master D 9 A
230 Master D 10 B
231 Master D 12 D
232 connection server_1;
233
234 * Check data inserted after restoring schema A->B->C->D->A *
235 connection server_1;
236 INSERT INTO t1(b,c) VALUES('A',4);
237 connection server_2;
238 INSERT INTO t1(b,c) VALUES('B',4);
239 connection server_3;
240 INSERT INTO t1(b,c) VALUES('C',4);
241 connection server_4;
242 INSERT INTO t1(b,c) VALUES('D',4);
243 connection server_1;
244 include/rpl_sync.inc
245 connection server_1;
246 SELECT 'Master A',a,b FROM t1 WHERE c = 4 ORDER BY a,b;
247 Master A a b
248 Master A 13 A
249 Master A 14 B
250 Master A 15 C
251 Master A 16 D
252 connection server_2;
253 SELECT 'Master B',a,b FROM t1 WHERE c = 4 ORDER BY a,b;
254 Master B a b
255 Master B 13 A
256 Master B 14 B
257 Master B 15 C
258 Master B 16 D
259 connection server_3;
260 SELECT 'Master C',a,b FROM t1 WHERE c = 4 ORDER BY a,b;
261 Master C a b
262 Master C 13 A
263 Master C 14 B
264 Master C 15 C
265 Master C 16 D
266 connection server_4;
267 SELECT 'Master D',a,b FROM t1 WHERE c = 4 ORDER BY a,b;
268 Master D a b
269 Master D 13 A
270 Master D 14 B
271 Master D 15 C
272 Master D 16 D
273 connection server_1;
274
275 * Transactions with commits *
276 connection server_1;
277 BEGIN;
278 connection server_3;
279 BEGIN;
280 connection server_1;
281 include/rpl_sync.inc
282 connection server_1;
283 SELECT 'Master A',b,COUNT(*) FROM t2 WHERE c = 1 GROUP BY b ORDER BY b;
284 Master A b COUNT(*)
285 Master A A 100
286 Master A B 100
287 Master A C 100
288 Master A D 100
289 connection server_2;
290 SELECT 'Master B',b,COUNT(*) FROM t2 WHERE c = 1 GROUP BY b ORDER BY b;
291 Master B b COUNT(*)
292 Master B A 100
293 Master B B 100
294 Master B C 100
295 Master B D 100
296 connection server_3;
297 SELECT 'Master C',b,COUNT(*) FROM t2 WHERE c = 1 GROUP BY b ORDER BY b;
298 Master C b COUNT(*)
299 Master C A 100
300 Master C B 100
301 Master C C 100
302 Master C D 100
303 connection server_4;
304 SELECT 'Master D',b,COUNT(*) FROM t2 WHERE c = 1 GROUP BY b ORDER BY b;
305 Master D b COUNT(*)
306 Master D A 100
307 Master D B 100
308 Master D C 100
309 Master D D 100
310 connection server_1;
311
312 * Transactions with rollbacks *
313 connection server_1;
314 BEGIN;
315 connection server_3;
316 BEGIN;
317 connection server_1;
318 include/rpl_sync.inc
319 connection server_1;
320 SELECT 'Master A',b,COUNT(*) FROM t2 WHERE c = 2 GROUP BY b ORDER BY b;
321 Master A b COUNT(*)
322 Master A B 100
323 Master A D 100
324 connection server_2;
325 SELECT 'Master B',b,COUNT(*) FROM t2 WHERE c = 2 GROUP BY b ORDER BY b;
326 Master B b COUNT(*)
327 Master B B 100
328 Master B D 100
329 connection server_3;
330 SELECT 'Master C',b,COUNT(*) FROM t2 WHERE c = 2 GROUP BY b ORDER BY b;
331 Master C b COUNT(*)
332 Master C B 100
333 Master C D 100
334 connection server_4;
335 SELECT 'Master D',b,COUNT(*) FROM t2 WHERE c = 2 GROUP BY b ORDER BY b;
336 Master D b COUNT(*)
337 Master D B 100
338 Master D D 100
339 connection server_1;
340
341 *** Clean up ***
342 connection server_1;
343 DROP TABLE t1,t2;
344 include/rpl_end.inc