Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 connection node_2;
5 connection node_1;
6 Performing State Transfer on a server that has been shut down cleanly and restarted
7 connection node_1;
8 CREATE TABLE t1 (id int not null primary key,f1 CHAR(255)) ENGINE=InnoDB;
9 SET AUTOCOMMIT=OFF;
10 START TRANSACTION;
11 INSERT INTO t1 VALUES (1,'node1_committed_before');
12 INSERT INTO t1 VALUES (2,'node1_committed_before');
13 INSERT INTO t1 VALUES (3,'node1_committed_before');
14 INSERT INTO t1 VALUES (4,'node1_committed_before');
15 INSERT INTO t1 VALUES (5,'node1_committed_before');
16 COMMIT;
17 connection node_2;
18 SET AUTOCOMMIT=OFF;
19 START TRANSACTION;
20 INSERT INTO t1 VALUES (6,'node2_committed_before');
21 INSERT INTO t1 VALUES (7,'node2_committed_before');
22 INSERT INTO t1 VALUES (8,'node2_committed_before');
23 INSERT INTO t1 VALUES (9,'node2_committed_before');
24 INSERT INTO t1 VALUES (10,'node2_committed_before');
25 COMMIT;
26 Shutting down server ...
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_shutdown_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 Starting server ...
52 SET AUTOCOMMIT=OFF;
53 START TRANSACTION;
54 INSERT INTO t1 VALUES (26,'node2_committed_after');
55 INSERT INTO t1 VALUES (27,'node2_committed_after');
56 INSERT INTO t1 VALUES (28,'node2_committed_after');
57 INSERT INTO t1 VALUES (29,'node2_committed_after');
58 INSERT INTO t1 VALUES (30,'node2_committed_after');
59 COMMIT;
60 connection node_1;
61 INSERT INTO t1 VALUES (31,'node1_to_be_committed_after');
62 INSERT INTO t1 VALUES (32,'node1_to_be_committed_after');
63 INSERT INTO t1 VALUES (33,'node1_to_be_committed_after');
64 INSERT INTO t1 VALUES (34,'node1_to_be_committed_after');
65 INSERT INTO t1 VALUES (35,'node1_to_be_committed_after');
66 COMMIT;
67 SET AUTOCOMMIT=OFF;
68 START TRANSACTION;
69 INSERT INTO t1 VALUES (36,'node1_committed_after');
70 INSERT INTO t1 VALUES (37,'node1_committed_after');
71 INSERT INTO t1 VALUES (38,'node1_committed_after');
72 INSERT INTO t1 VALUES (39,'node1_committed_after');
73 INSERT INTO t1 VALUES (40,'node1_committed_after');
74 COMMIT;
75 connection node_1a_galera_st_shutdown_slave;
76 INSERT INTO t1 VALUES (41,'node1_to_be_rollbacked_after');
77 INSERT INTO t1 VALUES (42,'node1_to_be_rollbacked_after');
78 INSERT INTO t1 VALUES (43,'node1_to_be_rollbacked_after');
79 INSERT INTO t1 VALUES (44,'node1_to_be_rollbacked_after');
80 INSERT INTO t1 VALUES (45,'node1_to_be_rollbacked_after');
81 ROLLBACK;
82 SET AUTOCOMMIT=ON;
83 SET SESSION wsrep_sync_wait=15;
84 SELECT COUNT(*) AS EXPECT_15 FROM t1;
85 EXPECT_15
86 35
87 SELECT * from t1;
88 id f1
89 1 node1_committed_before
90 2 node1_committed_before
91 3 node1_committed_before
92 4 node1_committed_before
93 5 node1_committed_before
94 6 node2_committed_before
95 7 node2_committed_before
96 8 node2_committed_before
97 9 node2_committed_before
98 10 node2_committed_before
99 11 node1_committed_during
100 12 node1_committed_during
101 13 node1_committed_during
102 14 node1_committed_during
103 15 node1_committed_during
104 16 node1_to_be_committed_after
105 17 node1_to_be_committed_after
106 18 node1_to_be_committed_after
107 19 node1_to_be_committed_after
108 20 node1_to_be_committed_after
109 26 node2_committed_after
110 27 node2_committed_after
111 28 node2_committed_after
112 29 node2_committed_after
113 30 node2_committed_after
114 31 node1_to_be_committed_after
115 32 node1_to_be_committed_after
116 33 node1_to_be_committed_after
117 34 node1_to_be_committed_after
118 35 node1_to_be_committed_after
119 36 node1_committed_after
120 37 node1_committed_after
121 38 node1_committed_after
122 39 node1_committed_after
123 40 node1_committed_after
124 SELECT COUNT(*) = 0 FROM (SELECT COUNT(*) AS c, f1 FROM t1 GROUP BY f1 HAVING c NOT IN (5, 10)) AS a1;
125 COUNT(*) = 0
126 1
127 COMMIT;
128 connection node_1;
129 SET AUTOCOMMIT=ON;
130 SET SESSION wsrep_sync_wait=15;
131 SELECT COUNT(*) AS EXPECT_15 FROM t1;
132 EXPECT_15
133 35
134 SELECT * from t1;
135 id f1
136 1 node1_committed_before
137 2 node1_committed_before
138 3 node1_committed_before
139 4 node1_committed_before
140 5 node1_committed_before
141 6 node2_committed_before
142 7 node2_committed_before
143 8 node2_committed_before
144 9 node2_committed_before
145 10 node2_committed_before
146 11 node1_committed_during
147 12 node1_committed_during
148 13 node1_committed_during
149 14 node1_committed_during
150 15 node1_committed_during
151 16 node1_to_be_committed_after
152 17 node1_to_be_committed_after
153 18 node1_to_be_committed_after
154 19 node1_to_be_committed_after
155 20 node1_to_be_committed_after
156 26 node2_committed_after
157 27 node2_committed_after
158 28 node2_committed_after
159 29 node2_committed_after
160 30 node2_committed_after
161 31 node1_to_be_committed_after
162 32 node1_to_be_committed_after
163 33 node1_to_be_committed_after
164 34 node1_to_be_committed_after
165 35 node1_to_be_committed_after
166 36 node1_committed_after
167 37 node1_committed_after
168 38 node1_committed_after
169 39 node1_committed_after
170 40 node1_committed_after
171 SELECT COUNT(*) = 0 FROM (SELECT COUNT(*) AS c, f1 FROM t1 GROUP BY f1 HAVING c NOT IN (5, 10)) AS a1;
172 COUNT(*) = 0
173 1
174 DROP TABLE t1;
175 COMMIT;
176 Performing State Transfer on a server that starts from a clean var directory
177 This is accomplished by shutting down node #2 and removing its var directory before restarting it
178 connection node_1;
179 CREATE TABLE t1 (id int not null primary key,f1 CHAR(255)) ENGINE=InnoDB;
180 SET AUTOCOMMIT=OFF;
181 START TRANSACTION;
182 INSERT INTO t1 VALUES (1,'node1_committed_before');
183 INSERT INTO t1 VALUES (2,'node1_committed_before');
184 INSERT INTO t1 VALUES (3,'node1_committed_before');
185 INSERT INTO t1 VALUES (4,'node1_committed_before');
186 INSERT INTO t1 VALUES (5,'node1_committed_before');
187 COMMIT;
188 connection node_2;
189 SET AUTOCOMMIT=OFF;
190 START TRANSACTION;
191 INSERT INTO t1 VALUES (6,'node2_committed_before');
192 INSERT INTO t1 VALUES (7,'node2_committed_before');
193 INSERT INTO t1 VALUES (8,'node2_committed_before');
194 INSERT INTO t1 VALUES (9,'node2_committed_before');
195 INSERT INTO t1 VALUES (10,'node2_committed_before');
196 COMMIT;
197 Shutting down server ...
198 connection node_1;
199 Cleaning var directory ...
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_clean_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_clean_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_35 FROM t1;
257 EXPECT_35
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_35 FROM t1;
304 EXPECT_35
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;
520 include/assert_grep.inc [Using stunnel for SSL encryption]