Debian Codegraph @

mysql-test/suite/galera/r/galera_sst_mariabackup.result

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