Debian Codegraph @

mysql-test/suite/galera/r/galera_ist_MDEV-28583.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 connection node_2;
5 Performing State Transfer on a server that has been temporarily disconnected
6 connection node_1;
7 CREATE TABLE t1 (id int not null primary key,f1 CHAR(255)) ENGINE=InnoDB;
8 SET AUTOCOMMIT=OFF;
9 START TRANSACTION;
10 INSERT INTO t1 VALUES (1,'node1_committed_before');
11 INSERT INTO t1 VALUES (2,'node1_committed_before');
12 INSERT INTO t1 VALUES (3,'node1_committed_before');
13 INSERT INTO t1 VALUES (4,'node1_committed_before');
14 INSERT INTO t1 VALUES (5,'node1_committed_before');
15 COMMIT;
16 connection node_2;
17 SET AUTOCOMMIT=OFF;
18 START TRANSACTION;
19 INSERT INTO t1 VALUES (6,'node2_committed_before');
20 INSERT INTO t1 VALUES (7,'node2_committed_before');
21 INSERT INTO t1 VALUES (8,'node2_committed_before');
22 INSERT INTO t1 VALUES (9,'node2_committed_before');
23 INSERT INTO t1 VALUES (10,'node2_committed_before');
24 COMMIT;
25 Unloading wsrep provider ...
26 SET GLOBAL wsrep_cluster_address = '';
27 connection node_1;
28 SET AUTOCOMMIT=OFF;
29 START TRANSACTION;
30 INSERT INTO t1 VALUES (11,'node1_committed_during');
31 INSERT INTO t1 VALUES (12,'node1_committed_during');
32 INSERT INTO t1 VALUES (13,'node1_committed_during');
33 INSERT INTO t1 VALUES (14,'node1_committed_during');
34 INSERT INTO t1 VALUES (15,'node1_committed_during');
35 COMMIT;
36 START TRANSACTION;
37 INSERT INTO t1 VALUES (16,'node1_to_be_committed_after');
38 INSERT INTO t1 VALUES (17,'node1_to_be_committed_after');
39 INSERT INTO t1 VALUES (18,'node1_to_be_committed_after');
40 INSERT INTO t1 VALUES (19,'node1_to_be_committed_after');
41 INSERT INTO t1 VALUES (20,'node1_to_be_committed_after');
42 connect node_1a_galera_st_disconnect_slave, 127.0.0.1, root, , test, $NODE_MYPORT_1;
43 SET AUTOCOMMIT=OFF;
44 START TRANSACTION;
45 INSERT INTO t1 VALUES (21,'node1_to_be_rollbacked_after');
46 INSERT INTO t1 VALUES (22,'node1_to_be_rollbacked_after');
47 INSERT INTO t1 VALUES (23,'node1_to_be_rollbacked_after');
48 INSERT INTO t1 VALUES (24,'node1_to_be_rollbacked_after');
49 INSERT INTO t1 VALUES (25,'node1_to_be_rollbacked_after');
50 connection node_2;
51 Loading wsrep provider ...
52 disconnect node_2;
53 connect node_2, 127.0.0.1, root, , test, $NODE_MYPORT_2;
54 connection node_2;
55 SET AUTOCOMMIT=OFF;
56 START TRANSACTION;
57 INSERT INTO t1 VALUES (26,'node2_committed_after');
58 INSERT INTO t1 VALUES (27,'node2_committed_after');
59 INSERT INTO t1 VALUES (28,'node2_committed_after');
60 INSERT INTO t1 VALUES (29,'node2_committed_after');
61 INSERT INTO t1 VALUES (30,'node2_committed_after');
62 COMMIT;
63 connection node_1;
64 INSERT INTO t1 VALUES (31,'node1_to_be_committed_after');
65 INSERT INTO t1 VALUES (32,'node1_to_be_committed_after');
66 INSERT INTO t1 VALUES (33,'node1_to_be_committed_after');
67 INSERT INTO t1 VALUES (34,'node1_to_be_committed_after');
68 INSERT INTO t1 VALUES (35,'node1_to_be_committed_after');
69 COMMIT;
70 SET AUTOCOMMIT=OFF;
71 START TRANSACTION;
72 INSERT INTO t1 VALUES (36,'node1_committed_after');
73 INSERT INTO t1 VALUES (37,'node1_committed_after');
74 INSERT INTO t1 VALUES (38,'node1_committed_after');
75 INSERT INTO t1 VALUES (39,'node1_committed_after');
76 INSERT INTO t1 VALUES (40,'node1_committed_after');
77 COMMIT;
78 connection node_1a_galera_st_disconnect_slave;
79 INSERT INTO t1 VALUES (41,'node1_to_be_rollbacked_after');
80 INSERT INTO t1 VALUES (42,'node1_to_be_rollbacked_after');
81 INSERT INTO t1 VALUES (43,'node1_to_be_rollbacked_after');
82 INSERT INTO t1 VALUES (44,'node1_to_be_rollbacked_after');
83 INSERT INTO t1 VALUES (45,'node1_to_be_rollbacked_after');
84 ROLLBACK;
85 SET AUTOCOMMIT=ON;
86 SET SESSION wsrep_sync_wait=15;
87 SELECT COUNT(*) AS EXPECT_35 FROM t1;
88 EXPECT_35
89 35
90 SELECT * FROM t1;
91 id f1
92 1 node1_committed_before
93 2 node1_committed_before
94 3 node1_committed_before
95 4 node1_committed_before
96 5 node1_committed_before
97 6 node2_committed_before
98 7 node2_committed_before
99 8 node2_committed_before
100 9 node2_committed_before
101 10 node2_committed_before
102 11 node1_committed_during
103 12 node1_committed_during
104 13 node1_committed_during
105 14 node1_committed_during
106 15 node1_committed_during
107 16 node1_to_be_committed_after
108 17 node1_to_be_committed_after
109 18 node1_to_be_committed_after
110 19 node1_to_be_committed_after
111 20 node1_to_be_committed_after
112 26 node2_committed_after
113 27 node2_committed_after
114 28 node2_committed_after
115 29 node2_committed_after
116 30 node2_committed_after
117 31 node1_to_be_committed_after
118 32 node1_to_be_committed_after
119 33 node1_to_be_committed_after
120 34 node1_to_be_committed_after
121 35 node1_to_be_committed_after
122 36 node1_committed_after
123 37 node1_committed_after
124 38 node1_committed_after
125 39 node1_committed_after
126 40 node1_committed_after
127 SELECT COUNT(*) = 0 FROM (SELECT COUNT(*) AS c, f1 FROM t1 GROUP BY f1 HAVING c NOT IN (5, 10)) AS a1;
128 COUNT(*) = 0
129 1
130 connection node_1;
131 SET AUTOCOMMIT=ON;
132 SET SESSION wsrep_sync_wait=15;
133 SELECT COUNT(*) AS EXPECT_35 FROM t1;
134 EXPECT_35
135 35
136 SELECT * FROM t1;
137 id f1
138 1 node1_committed_before
139 2 node1_committed_before
140 3 node1_committed_before
141 4 node1_committed_before
142 5 node1_committed_before
143 6 node2_committed_before
144 7 node2_committed_before
145 8 node2_committed_before
146 9 node2_committed_before
147 10 node2_committed_before
148 11 node1_committed_during
149 12 node1_committed_during
150 13 node1_committed_during
151 14 node1_committed_during
152 15 node1_committed_during
153 16 node1_to_be_committed_after
154 17 node1_to_be_committed_after
155 18 node1_to_be_committed_after
156 19 node1_to_be_committed_after
157 20 node1_to_be_committed_after
158 26 node2_committed_after
159 27 node2_committed_after
160 28 node2_committed_after
161 29 node2_committed_after
162 30 node2_committed_after
163 31 node1_to_be_committed_after
164 32 node1_to_be_committed_after
165 33 node1_to_be_committed_after
166 34 node1_to_be_committed_after
167 35 node1_to_be_committed_after
168 36 node1_committed_after
169 37 node1_committed_after
170 38 node1_committed_after
171 39 node1_committed_after
172 40 node1_committed_after
173 SELECT COUNT(*) = 0 FROM (SELECT COUNT(*) AS c, f1 FROM t1 GROUP BY f1 HAVING c NOT IN (5, 10)) AS a1;
174 COUNT(*) = 0
175 1
176 DROP TABLE t1;
177 COMMIT;
178 Performing State Transfer on a server that has been shut down cleanly and restarted
179 connection node_1;
180 CREATE TABLE t1 (id int not null primary key,f1 CHAR(255)) ENGINE=InnoDB;
181 SET AUTOCOMMIT=OFF;
182 START TRANSACTION;
183 INSERT INTO t1 VALUES (1,'node1_committed_before');
184 INSERT INTO t1 VALUES (2,'node1_committed_before');
185 INSERT INTO t1 VALUES (3,'node1_committed_before');
186 INSERT INTO t1 VALUES (4,'node1_committed_before');
187 INSERT INTO t1 VALUES (5,'node1_committed_before');
188 COMMIT;
189 connection node_2;
190 SET AUTOCOMMIT=OFF;
191 START TRANSACTION;
192 INSERT INTO t1 VALUES (6,'node2_committed_before');
193 INSERT INTO t1 VALUES (7,'node2_committed_before');
194 INSERT INTO t1 VALUES (8,'node2_committed_before');
195 INSERT INTO t1 VALUES (9,'node2_committed_before');
196 INSERT INTO t1 VALUES (10,'node2_committed_before');
197 COMMIT;
198 Shutting down server ...
199 connection node_1;
200 SET AUTOCOMMIT=OFF;
201 START TRANSACTION;
202 INSERT INTO t1 VALUES (11,'node1_committed_during');
203 INSERT INTO t1 VALUES (12,'node1_committed_during');
204 INSERT INTO t1 VALUES (13,'node1_committed_during');
205 INSERT INTO t1 VALUES (14,'node1_committed_during');
206 INSERT INTO t1 VALUES (15,'node1_committed_during');
207 COMMIT;
208 START TRANSACTION;
209 INSERT INTO t1 VALUES (16,'node1_to_be_committed_after');
210 INSERT INTO t1 VALUES (17,'node1_to_be_committed_after');
211 INSERT INTO t1 VALUES (18,'node1_to_be_committed_after');
212 INSERT INTO t1 VALUES (19,'node1_to_be_committed_after');
213 INSERT INTO t1 VALUES (20,'node1_to_be_committed_after');
214 connect node_1a_galera_st_shutdown_slave, 127.0.0.1, root, , test, $NODE_MYPORT_1;
215 SET AUTOCOMMIT=OFF;
216 START TRANSACTION;
217 INSERT INTO t1 VALUES (21,'node1_to_be_rollbacked_after');
218 INSERT INTO t1 VALUES (22,'node1_to_be_rollbacked_after');
219 INSERT INTO t1 VALUES (23,'node1_to_be_rollbacked_after');
220 INSERT INTO t1 VALUES (24,'node1_to_be_rollbacked_after');
221 INSERT INTO t1 VALUES (25,'node1_to_be_rollbacked_after');
222 connection node_2;
223 Starting server ...
224 SET AUTOCOMMIT=OFF;
225 START TRANSACTION;
226 INSERT INTO t1 VALUES (26,'node2_committed_after');
227 INSERT INTO t1 VALUES (27,'node2_committed_after');
228 INSERT INTO t1 VALUES (28,'node2_committed_after');
229 INSERT INTO t1 VALUES (29,'node2_committed_after');
230 INSERT INTO t1 VALUES (30,'node2_committed_after');
231 COMMIT;
232 connection node_1;
233 INSERT INTO t1 VALUES (31,'node1_to_be_committed_after');
234 INSERT INTO t1 VALUES (32,'node1_to_be_committed_after');
235 INSERT INTO t1 VALUES (33,'node1_to_be_committed_after');
236 INSERT INTO t1 VALUES (34,'node1_to_be_committed_after');
237 INSERT INTO t1 VALUES (35,'node1_to_be_committed_after');
238 COMMIT;
239 SET AUTOCOMMIT=OFF;
240 START TRANSACTION;
241 INSERT INTO t1 VALUES (36,'node1_committed_after');
242 INSERT INTO t1 VALUES (37,'node1_committed_after');
243 INSERT INTO t1 VALUES (38,'node1_committed_after');
244 INSERT INTO t1 VALUES (39,'node1_committed_after');
245 INSERT INTO t1 VALUES (40,'node1_committed_after');
246 COMMIT;
247 connection node_1a_galera_st_shutdown_slave;
248 INSERT INTO t1 VALUES (41,'node1_to_be_rollbacked_after');
249 INSERT INTO t1 VALUES (42,'node1_to_be_rollbacked_after');
250 INSERT INTO t1 VALUES (43,'node1_to_be_rollbacked_after');
251 INSERT INTO t1 VALUES (44,'node1_to_be_rollbacked_after');
252 INSERT INTO t1 VALUES (45,'node1_to_be_rollbacked_after');
253 ROLLBACK;
254 SET AUTOCOMMIT=ON;
255 SET SESSION wsrep_sync_wait=15;
256 SELECT COUNT(*) AS EXPECT_15 FROM t1;
257 EXPECT_15
258 35
259 SELECT * from t1;
260 id f1
261 1 node1_committed_before
262 2 node1_committed_before
263 3 node1_committed_before
264 4 node1_committed_before
265 5 node1_committed_before
266 6 node2_committed_before
267 7 node2_committed_before
268 8 node2_committed_before
269 9 node2_committed_before
270 10 node2_committed_before
271 11 node1_committed_during
272 12 node1_committed_during
273 13 node1_committed_during
274 14 node1_committed_during
275 15 node1_committed_during
276 16 node1_to_be_committed_after
277 17 node1_to_be_committed_after
278 18 node1_to_be_committed_after
279 19 node1_to_be_committed_after
280 20 node1_to_be_committed_after
281 26 node2_committed_after
282 27 node2_committed_after
283 28 node2_committed_after
284 29 node2_committed_after
285 30 node2_committed_after
286 31 node1_to_be_committed_after
287 32 node1_to_be_committed_after
288 33 node1_to_be_committed_after
289 34 node1_to_be_committed_after
290 35 node1_to_be_committed_after
291 36 node1_committed_after
292 37 node1_committed_after
293 38 node1_committed_after
294 39 node1_committed_after
295 40 node1_committed_after
296 SELECT COUNT(*) = 0 FROM (SELECT COUNT(*) AS c, f1 FROM t1 GROUP BY f1 HAVING c NOT IN (5, 10)) AS a1;
297 COUNT(*) = 0
298 1
299 COMMIT;
300 connection node_1;
301 SET AUTOCOMMIT=ON;
302 SET SESSION wsrep_sync_wait=15;
303 SELECT COUNT(*) AS EXPECT_15 FROM t1;
304 EXPECT_15
305 35
306 SELECT * from t1;
307 id f1
308 1 node1_committed_before
309 2 node1_committed_before
310 3 node1_committed_before
311 4 node1_committed_before
312 5 node1_committed_before
313 6 node2_committed_before
314 7 node2_committed_before
315 8 node2_committed_before
316 9 node2_committed_before
317 10 node2_committed_before
318 11 node1_committed_during
319 12 node1_committed_during
320 13 node1_committed_during
321 14 node1_committed_during
322 15 node1_committed_during
323 16 node1_to_be_committed_after
324 17 node1_to_be_committed_after
325 18 node1_to_be_committed_after
326 19 node1_to_be_committed_after
327 20 node1_to_be_committed_after
328 26 node2_committed_after
329 27 node2_committed_after
330 28 node2_committed_after
331 29 node2_committed_after
332 30 node2_committed_after
333 31 node1_to_be_committed_after
334 32 node1_to_be_committed_after
335 33 node1_to_be_committed_after
336 34 node1_to_be_committed_after
337 35 node1_to_be_committed_after
338 36 node1_committed_after
339 37 node1_committed_after
340 38 node1_committed_after
341 39 node1_committed_after
342 40 node1_committed_after
343 SELECT COUNT(*) = 0 FROM (SELECT COUNT(*) AS c, f1 FROM t1 GROUP BY f1 HAVING c NOT IN (5, 10)) AS a1;
344 COUNT(*) = 0
345 1
346 DROP TABLE t1;
347 COMMIT;
348 Performing State Transfer on a server that has been killed and restarted
349 connection node_1;
350 CREATE TABLE t1 (id int not null primary key,f1 CHAR(255)) ENGINE=InnoDB;
351 SET AUTOCOMMIT=OFF;
352 START TRANSACTION;
353 INSERT INTO t1 VALUES (1,'node1_committed_before');
354 INSERT INTO t1 VALUES (2,'node1_committed_before');
355 INSERT INTO t1 VALUES (3,'node1_committed_before');
356 INSERT INTO t1 VALUES (4,'node1_committed_before');
357 INSERT INTO t1 VALUES (5,'node1_committed_before');
358 COMMIT;
359 connection node_2;
360 SET AUTOCOMMIT=OFF;
361 START TRANSACTION;
362 INSERT INTO t1 VALUES (6,'node2_committed_before');
363 INSERT INTO t1 VALUES (7,'node2_committed_before');
364 INSERT INTO t1 VALUES (8,'node2_committed_before');
365 INSERT INTO t1 VALUES (9,'node2_committed_before');
366 INSERT INTO t1 VALUES (10,'node2_committed_before');
367 COMMIT;
368 Killing server ...
369 connection node_1;
370 SET AUTOCOMMIT=OFF;
371 START TRANSACTION;
372 INSERT INTO t1 VALUES (11,'node1_committed_during');
373 INSERT INTO t1 VALUES (12,'node1_committed_during');
374 INSERT INTO t1 VALUES (13,'node1_committed_during');
375 INSERT INTO t1 VALUES (14,'node1_committed_during');
376 INSERT INTO t1 VALUES (15,'node1_committed_during');
377 COMMIT;
378 START TRANSACTION;
379 INSERT INTO t1 VALUES (16,'node1_to_be_committed_after');
380 INSERT INTO t1 VALUES (17,'node1_to_be_committed_after');
381 INSERT INTO t1 VALUES (18,'node1_to_be_committed_after');
382 INSERT INTO t1 VALUES (19,'node1_to_be_committed_after');
383 INSERT INTO t1 VALUES (20,'node1_to_be_committed_after');
384 connect node_1a_galera_st_kill_slave, 127.0.0.1, root, , test, $NODE_MYPORT_1;
385 SET AUTOCOMMIT=OFF;
386 START TRANSACTION;
387 INSERT INTO t1 VALUES (21,'node1_to_be_rollbacked_after');
388 INSERT INTO t1 VALUES (22,'node1_to_be_rollbacked_after');
389 INSERT INTO t1 VALUES (23,'node1_to_be_rollbacked_after');
390 INSERT INTO t1 VALUES (24,'node1_to_be_rollbacked_after');
391 INSERT INTO t1 VALUES (25,'node1_to_be_rollbacked_after');
392 connection node_2;
393 Performing --wsrep-recover ...
394 Starting server ...
395 Using --wsrep-start-position when starting mysqld ...
396 SET AUTOCOMMIT=OFF;
397 START TRANSACTION;
398 INSERT INTO t1 VALUES (26,'node2_committed_after');
399 INSERT INTO t1 VALUES (27,'node2_committed_after');
400 INSERT INTO t1 VALUES (28,'node2_committed_after');
401 INSERT INTO t1 VALUES (29,'node2_committed_after');
402 INSERT INTO t1 VALUES (30,'node2_committed_after');
403 COMMIT;
404 connection node_1;
405 INSERT INTO t1 VALUES (31,'node1_to_be_committed_after');
406 INSERT INTO t1 VALUES (32,'node1_to_be_committed_after');
407 INSERT INTO t1 VALUES (33,'node1_to_be_committed_after');
408 INSERT INTO t1 VALUES (34,'node1_to_be_committed_after');
409 INSERT INTO t1 VALUES (35,'node1_to_be_committed_after');
410 COMMIT;
411 SET AUTOCOMMIT=OFF;
412 START TRANSACTION;
413 INSERT INTO t1 VALUES (36,'node1_committed_after');
414 INSERT INTO t1 VALUES (37,'node1_committed_after');
415 INSERT INTO t1 VALUES (38,'node1_committed_after');
416 INSERT INTO t1 VALUES (39,'node1_committed_after');
417 INSERT INTO t1 VALUES (40,'node1_committed_after');
418 COMMIT;
419 connection node_1a_galera_st_kill_slave;
420 INSERT INTO t1 VALUES (41,'node1_to_be_rollbacked_after');
421 INSERT INTO t1 VALUES (42,'node1_to_be_rollbacked_after');
422 INSERT INTO t1 VALUES (43,'node1_to_be_rollbacked_after');
423 INSERT INTO t1 VALUES (45,'node1_to_be_rollbacked_after');
424 INSERT INTO t1 VALUES (46,'node1_to_be_rollbacked_after');
425 ROLLBACK;
426 SET AUTOCOMMIT=ON;
427 SET SESSION wsrep_sync_wait=15;
428 SELECT COUNT(*) AS EXPECT_35 FROM t1;
429 EXPECT_35
430 35
431 SELECT * FROM t1;
432 id f1
433 1 node1_committed_before
434 2 node1_committed_before
435 3 node1_committed_before
436 4 node1_committed_before
437 5 node1_committed_before
438 6 node2_committed_before
439 7 node2_committed_before
440 8 node2_committed_before
441 9 node2_committed_before
442 10 node2_committed_before
443 11 node1_committed_during
444 12 node1_committed_during
445 13 node1_committed_during
446 14 node1_committed_during
447 15 node1_committed_during
448 16 node1_to_be_committed_after
449 17 node1_to_be_committed_after
450 18 node1_to_be_committed_after
451 19 node1_to_be_committed_after
452 20 node1_to_be_committed_after
453 26 node2_committed_after
454 27 node2_committed_after
455 28 node2_committed_after
456 29 node2_committed_after
457 30 node2_committed_after
458 31 node1_to_be_committed_after
459 32 node1_to_be_committed_after
460 33 node1_to_be_committed_after
461 34 node1_to_be_committed_after
462 35 node1_to_be_committed_after
463 36 node1_committed_after
464 37 node1_committed_after
465 38 node1_committed_after
466 39 node1_committed_after
467 40 node1_committed_after
468 SELECT COUNT(*) = 0 FROM (SELECT COUNT(*) AS c, f1 FROM t1 GROUP BY f1 HAVING c NOT IN (5, 10)) AS a1;
469 COUNT(*) = 0
470 1
471 COMMIT;
472 connection node_1;
473 SET AUTOCOMMIT=ON;
474 SET SESSION wsrep_sync_wait=15;
475 SELECT COUNT(*) AS EXPECT_35 FROM t1;
476 EXPECT_35
477 35
478 SELECT * FROM t1;
479 id f1
480 1 node1_committed_before
481 2 node1_committed_before
482 3 node1_committed_before
483 4 node1_committed_before
484 5 node1_committed_before
485 6 node2_committed_before
486 7 node2_committed_before
487 8 node2_committed_before
488 9 node2_committed_before
489 10 node2_committed_before
490 11 node1_committed_during
491 12 node1_committed_during
492 13 node1_committed_during
493 14 node1_committed_during
494 15 node1_committed_during
495 16 node1_to_be_committed_after
496 17 node1_to_be_committed_after
497 18 node1_to_be_committed_after
498 19 node1_to_be_committed_after
499 20 node1_to_be_committed_after
500 26 node2_committed_after
501 27 node2_committed_after
502 28 node2_committed_after
503 29 node2_committed_after
504 30 node2_committed_after
505 31 node1_to_be_committed_after
506 32 node1_to_be_committed_after
507 33 node1_to_be_committed_after
508 34 node1_to_be_committed_after
509 35 node1_to_be_committed_after
510 36 node1_committed_after
511 37 node1_committed_after
512 38 node1_committed_after
513 39 node1_committed_after
514 40 node1_committed_after
515 SELECT COUNT(*) = 0 FROM (SELECT COUNT(*) AS c, f1 FROM t1 GROUP BY f1 HAVING c NOT IN (5, 10)) AS a1;
516 COUNT(*) = 0
517 1
518 DROP TABLE t1;
519 COMMIT;