Debian Codegraph @

mysql-test/suite/galera/r/galera_sst_mariabackup_table_options.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 starts from a clean var directory
6 This is accomplished by shutting down node #2 and removing its var directory before restarting it
7 connection node_1;
8 CREATE TABLE t1 (f1 CHAR(255)) ENGINE=InnoDB;
9 CREATE TABLE t2 (f1 CHAR(255)) ENGINE=InnoDB PAGE_COMPRESSED=1;
10 CREATE TABLE t3 (f1 CHAR(255)) ENGINE=InnoDB PAGE_COMPRESSED=1 ENCRYPTED=NO;
11 CREATE TABLE t4 (f1 CHAR(255)) ENGINE=InnoDB PAGE_COMPRESSED=1 ENCRYPTED=YES;
12 CREATE TABLE t5 (f1 CHAR(255)) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
13 CREATE TABLE t6 (f1 CHAR(255)) ENGINE=InnoDB ROW_FORMAT=COMPRESSED ENCRYPTED=NO;
14 CREATE TABLE t7 (f1 CHAR(255)) ENGINE=InnoDB ROW_FORMAT=COMPRESSED ENCRYPTED=YES;
15 CREATE TABLE t8 (f1 CHAR(255)) ENGINE=InnoDB ENCRYPTED=NO;
16 CREATE TABLE t9 (f1 CHAR(255)) ENGINE=InnoDB ENCRYPTED=YES;
17 SET AUTOCOMMIT=OFF;
18 START TRANSACTION;
19 insert into t9 values ('node1_committed_before');
20 insert into t9 values ('node1_committed_before');
21 insert into t9 values ('node1_committed_before');
22 insert into t9 values ('node1_committed_before');
23 insert into t9 values ('node1_committed_before');
24 insert into t8 values ('node1_committed_before');
25 insert into t8 values ('node1_committed_before');
26 insert into t8 values ('node1_committed_before');
27 insert into t8 values ('node1_committed_before');
28 insert into t8 values ('node1_committed_before');
29 insert into t7 values ('node1_committed_before');
30 insert into t7 values ('node1_committed_before');
31 insert into t7 values ('node1_committed_before');
32 insert into t7 values ('node1_committed_before');
33 insert into t7 values ('node1_committed_before');
34 insert into t6 values ('node1_committed_before');
35 insert into t6 values ('node1_committed_before');
36 insert into t6 values ('node1_committed_before');
37 insert into t6 values ('node1_committed_before');
38 insert into t6 values ('node1_committed_before');
39 insert into t5 values ('node1_committed_before');
40 insert into t5 values ('node1_committed_before');
41 insert into t5 values ('node1_committed_before');
42 insert into t5 values ('node1_committed_before');
43 insert into t5 values ('node1_committed_before');
44 insert into t4 values ('node1_committed_before');
45 insert into t4 values ('node1_committed_before');
46 insert into t4 values ('node1_committed_before');
47 insert into t4 values ('node1_committed_before');
48 insert into t4 values ('node1_committed_before');
49 insert into t3 values ('node1_committed_before');
50 insert into t3 values ('node1_committed_before');
51 insert into t3 values ('node1_committed_before');
52 insert into t3 values ('node1_committed_before');
53 insert into t3 values ('node1_committed_before');
54 insert into t2 values ('node1_committed_before');
55 insert into t2 values ('node1_committed_before');
56 insert into t2 values ('node1_committed_before');
57 insert into t2 values ('node1_committed_before');
58 insert into t2 values ('node1_committed_before');
59 insert into t1 values ('node1_committed_before');
60 insert into t1 values ('node1_committed_before');
61 insert into t1 values ('node1_committed_before');
62 insert into t1 values ('node1_committed_before');
63 insert into t1 values ('node1_committed_before');
64 COMMIT;
65 connection node_2;
66 SET AUTOCOMMIT=OFF;
67 START TRANSACTION;
68 insert into t9 values ('node2_committed_before');
69 insert into t9 values ('node2_committed_before');
70 insert into t9 values ('node2_committed_before');
71 insert into t9 values ('node2_committed_before');
72 insert into t9 values ('node2_committed_before');
73 insert into t8 values ('node2_committed_before');
74 insert into t8 values ('node2_committed_before');
75 insert into t8 values ('node2_committed_before');
76 insert into t8 values ('node2_committed_before');
77 insert into t8 values ('node2_committed_before');
78 insert into t7 values ('node2_committed_before');
79 insert into t7 values ('node2_committed_before');
80 insert into t7 values ('node2_committed_before');
81 insert into t7 values ('node2_committed_before');
82 insert into t7 values ('node2_committed_before');
83 insert into t6 values ('node2_committed_before');
84 insert into t6 values ('node2_committed_before');
85 insert into t6 values ('node2_committed_before');
86 insert into t6 values ('node2_committed_before');
87 insert into t6 values ('node2_committed_before');
88 insert into t5 values ('node2_committed_before');
89 insert into t5 values ('node2_committed_before');
90 insert into t5 values ('node2_committed_before');
91 insert into t5 values ('node2_committed_before');
92 insert into t5 values ('node2_committed_before');
93 insert into t4 values ('node2_committed_before');
94 insert into t4 values ('node2_committed_before');
95 insert into t4 values ('node2_committed_before');
96 insert into t4 values ('node2_committed_before');
97 insert into t4 values ('node2_committed_before');
98 insert into t3 values ('node2_committed_before');
99 insert into t3 values ('node2_committed_before');
100 insert into t3 values ('node2_committed_before');
101 insert into t3 values ('node2_committed_before');
102 insert into t3 values ('node2_committed_before');
103 insert into t2 values ('node2_committed_before');
104 insert into t2 values ('node2_committed_before');
105 insert into t2 values ('node2_committed_before');
106 insert into t2 values ('node2_committed_before');
107 insert into t2 values ('node2_committed_before');
108 insert into t1 values ('node2_committed_before');
109 insert into t1 values ('node2_committed_before');
110 insert into t1 values ('node2_committed_before');
111 insert into t1 values ('node2_committed_before');
112 insert into t1 values ('node2_committed_before');
113 COMMIT;
114 Shutting down server ...
115 connection node_1;
116 Cleaning var directory ...
117 SET AUTOCOMMIT=OFF;
118 START TRANSACTION;
119 insert into t9 values ('node1_committed_during');
120 insert into t9 values ('node1_committed_during');
121 insert into t9 values ('node1_committed_during');
122 insert into t9 values ('node1_committed_during');
123 insert into t9 values ('node1_committed_during');
124 insert into t8 values ('node1_committed_during');
125 insert into t8 values ('node1_committed_during');
126 insert into t8 values ('node1_committed_during');
127 insert into t8 values ('node1_committed_during');
128 insert into t8 values ('node1_committed_during');
129 insert into t7 values ('node1_committed_during');
130 insert into t7 values ('node1_committed_during');
131 insert into t7 values ('node1_committed_during');
132 insert into t7 values ('node1_committed_during');
133 insert into t7 values ('node1_committed_during');
134 insert into t6 values ('node1_committed_during');
135 insert into t6 values ('node1_committed_during');
136 insert into t6 values ('node1_committed_during');
137 insert into t6 values ('node1_committed_during');
138 insert into t6 values ('node1_committed_during');
139 insert into t5 values ('node1_committed_during');
140 insert into t5 values ('node1_committed_during');
141 insert into t5 values ('node1_committed_during');
142 insert into t5 values ('node1_committed_during');
143 insert into t5 values ('node1_committed_during');
144 insert into t4 values ('node1_committed_during');
145 insert into t4 values ('node1_committed_during');
146 insert into t4 values ('node1_committed_during');
147 insert into t4 values ('node1_committed_during');
148 insert into t4 values ('node1_committed_during');
149 insert into t3 values ('node1_committed_during');
150 insert into t3 values ('node1_committed_during');
151 insert into t3 values ('node1_committed_during');
152 insert into t3 values ('node1_committed_during');
153 insert into t3 values ('node1_committed_during');
154 insert into t2 values ('node1_committed_during');
155 insert into t2 values ('node1_committed_during');
156 insert into t2 values ('node1_committed_during');
157 insert into t2 values ('node1_committed_during');
158 insert into t2 values ('node1_committed_during');
159 insert into t1 values ('node1_committed_during');
160 insert into t1 values ('node1_committed_during');
161 insert into t1 values ('node1_committed_during');
162 insert into t1 values ('node1_committed_during');
163 insert into t1 values ('node1_committed_during');
164 COMMIT;
165 START TRANSACTION;
166 insert into t9 values ('node1_to_be_committed_after');
167 insert into t9 values ('node1_to_be_committed_after');
168 insert into t9 values ('node1_to_be_committed_after');
169 insert into t9 values ('node1_to_be_committed_after');
170 insert into t9 values ('node1_to_be_committed_after');
171 insert into t8 values ('node1_to_be_committed_after');
172 insert into t8 values ('node1_to_be_committed_after');
173 insert into t8 values ('node1_to_be_committed_after');
174 insert into t8 values ('node1_to_be_committed_after');
175 insert into t8 values ('node1_to_be_committed_after');
176 insert into t7 values ('node1_to_be_committed_after');
177 insert into t7 values ('node1_to_be_committed_after');
178 insert into t7 values ('node1_to_be_committed_after');
179 insert into t7 values ('node1_to_be_committed_after');
180 insert into t7 values ('node1_to_be_committed_after');
181 insert into t6 values ('node1_to_be_committed_after');
182 insert into t6 values ('node1_to_be_committed_after');
183 insert into t6 values ('node1_to_be_committed_after');
184 insert into t6 values ('node1_to_be_committed_after');
185 insert into t6 values ('node1_to_be_committed_after');
186 insert into t5 values ('node1_to_be_committed_after');
187 insert into t5 values ('node1_to_be_committed_after');
188 insert into t5 values ('node1_to_be_committed_after');
189 insert into t5 values ('node1_to_be_committed_after');
190 insert into t5 values ('node1_to_be_committed_after');
191 insert into t4 values ('node1_to_be_committed_after');
192 insert into t4 values ('node1_to_be_committed_after');
193 insert into t4 values ('node1_to_be_committed_after');
194 insert into t4 values ('node1_to_be_committed_after');
195 insert into t4 values ('node1_to_be_committed_after');
196 insert into t3 values ('node1_to_be_committed_after');
197 insert into t3 values ('node1_to_be_committed_after');
198 insert into t3 values ('node1_to_be_committed_after');
199 insert into t3 values ('node1_to_be_committed_after');
200 insert into t3 values ('node1_to_be_committed_after');
201 insert into t2 values ('node1_to_be_committed_after');
202 insert into t2 values ('node1_to_be_committed_after');
203 insert into t2 values ('node1_to_be_committed_after');
204 insert into t2 values ('node1_to_be_committed_after');
205 insert into t2 values ('node1_to_be_committed_after');
206 insert into t1 values ('node1_to_be_committed_after');
207 insert into t1 values ('node1_to_be_committed_after');
208 insert into t1 values ('node1_to_be_committed_after');
209 insert into t1 values ('node1_to_be_committed_after');
210 insert into t1 values ('node1_to_be_committed_after');
211 connect node_1a_galera_st_clean_slave, 127.0.0.1, root, , test, $NODE_MYPORT_1;
212 SET AUTOCOMMIT=OFF;
213 START TRANSACTION;
214 insert into t9 values ('node1_to_be_rollbacked_after');
215 insert into t9 values ('node1_to_be_rollbacked_after');
216 insert into t9 values ('node1_to_be_rollbacked_after');
217 insert into t9 values ('node1_to_be_rollbacked_after');
218 insert into t9 values ('node1_to_be_rollbacked_after');
219 insert into t8 values ('node1_to_be_rollbacked_after');
220 insert into t8 values ('node1_to_be_rollbacked_after');
221 insert into t8 values ('node1_to_be_rollbacked_after');
222 insert into t8 values ('node1_to_be_rollbacked_after');
223 insert into t8 values ('node1_to_be_rollbacked_after');
224 insert into t7 values ('node1_to_be_rollbacked_after');
225 insert into t7 values ('node1_to_be_rollbacked_after');
226 insert into t7 values ('node1_to_be_rollbacked_after');
227 insert into t7 values ('node1_to_be_rollbacked_after');
228 insert into t7 values ('node1_to_be_rollbacked_after');
229 insert into t6 values ('node1_to_be_rollbacked_after');
230 insert into t6 values ('node1_to_be_rollbacked_after');
231 insert into t6 values ('node1_to_be_rollbacked_after');
232 insert into t6 values ('node1_to_be_rollbacked_after');
233 insert into t6 values ('node1_to_be_rollbacked_after');
234 insert into t5 values ('node1_to_be_rollbacked_after');
235 insert into t5 values ('node1_to_be_rollbacked_after');
236 insert into t5 values ('node1_to_be_rollbacked_after');
237 insert into t5 values ('node1_to_be_rollbacked_after');
238 insert into t5 values ('node1_to_be_rollbacked_after');
239 insert into t4 values ('node1_to_be_rollbacked_after');
240 insert into t4 values ('node1_to_be_rollbacked_after');
241 insert into t4 values ('node1_to_be_rollbacked_after');
242 insert into t4 values ('node1_to_be_rollbacked_after');
243 insert into t4 values ('node1_to_be_rollbacked_after');
244 insert into t3 values ('node1_to_be_rollbacked_after');
245 insert into t3 values ('node1_to_be_rollbacked_after');
246 insert into t3 values ('node1_to_be_rollbacked_after');
247 insert into t3 values ('node1_to_be_rollbacked_after');
248 insert into t3 values ('node1_to_be_rollbacked_after');
249 insert into t2 values ('node1_to_be_rollbacked_after');
250 insert into t2 values ('node1_to_be_rollbacked_after');
251 insert into t2 values ('node1_to_be_rollbacked_after');
252 insert into t2 values ('node1_to_be_rollbacked_after');
253 insert into t2 values ('node1_to_be_rollbacked_after');
254 insert into t1 values ('node1_to_be_rollbacked_after');
255 insert into t1 values ('node1_to_be_rollbacked_after');
256 insert into t1 values ('node1_to_be_rollbacked_after');
257 insert into t1 values ('node1_to_be_rollbacked_after');
258 insert into t1 values ('node1_to_be_rollbacked_after');
259 connection node_2;
260 Starting server ...
261 SET AUTOCOMMIT=OFF;
262 START TRANSACTION;
263 COMMIT;
264 connection node_1;
265 insert into t9 values ('node1_to_be_committed_after');
266 insert into t9 values ('node1_to_be_committed_after');
267 insert into t9 values ('node1_to_be_committed_after');
268 insert into t9 values ('node1_to_be_committed_after');
269 insert into t9 values ('node1_to_be_committed_after');
270 insert into t8 values ('node1_to_be_committed_after');
271 insert into t8 values ('node1_to_be_committed_after');
272 insert into t8 values ('node1_to_be_committed_after');
273 insert into t8 values ('node1_to_be_committed_after');
274 insert into t8 values ('node1_to_be_committed_after');
275 insert into t7 values ('node1_to_be_committed_after');
276 insert into t7 values ('node1_to_be_committed_after');
277 insert into t7 values ('node1_to_be_committed_after');
278 insert into t7 values ('node1_to_be_committed_after');
279 insert into t7 values ('node1_to_be_committed_after');
280 insert into t6 values ('node1_to_be_committed_after');
281 insert into t6 values ('node1_to_be_committed_after');
282 insert into t6 values ('node1_to_be_committed_after');
283 insert into t6 values ('node1_to_be_committed_after');
284 insert into t6 values ('node1_to_be_committed_after');
285 insert into t5 values ('node1_to_be_committed_after');
286 insert into t5 values ('node1_to_be_committed_after');
287 insert into t5 values ('node1_to_be_committed_after');
288 insert into t5 values ('node1_to_be_committed_after');
289 insert into t5 values ('node1_to_be_committed_after');
290 insert into t4 values ('node1_to_be_committed_after');
291 insert into t4 values ('node1_to_be_committed_after');
292 insert into t4 values ('node1_to_be_committed_after');
293 insert into t4 values ('node1_to_be_committed_after');
294 insert into t4 values ('node1_to_be_committed_after');
295 insert into t3 values ('node1_to_be_committed_after');
296 insert into t3 values ('node1_to_be_committed_after');
297 insert into t3 values ('node1_to_be_committed_after');
298 insert into t3 values ('node1_to_be_committed_after');
299 insert into t3 values ('node1_to_be_committed_after');
300 insert into t2 values ('node1_to_be_committed_after');
301 insert into t2 values ('node1_to_be_committed_after');
302 insert into t2 values ('node1_to_be_committed_after');
303 insert into t2 values ('node1_to_be_committed_after');
304 insert into t2 values ('node1_to_be_committed_after');
305 insert into t1 values ('node1_to_be_committed_after');
306 insert into t1 values ('node1_to_be_committed_after');
307 insert into t1 values ('node1_to_be_committed_after');
308 insert into t1 values ('node1_to_be_committed_after');
309 insert into t1 values ('node1_to_be_committed_after');
310 COMMIT;
311 SET AUTOCOMMIT=OFF;
312 START TRANSACTION;
313 insert into t9 values ('node1_committed_after');
314 insert into t9 values ('node1_committed_after');
315 insert into t9 values ('node1_committed_after');
316 insert into t9 values ('node1_committed_after');
317 insert into t9 values ('node1_committed_after');
318 insert into t8 values ('node1_committed_after');
319 insert into t8 values ('node1_committed_after');
320 insert into t8 values ('node1_committed_after');
321 insert into t8 values ('node1_committed_after');
322 insert into t8 values ('node1_committed_after');
323 insert into t7 values ('node1_committed_after');
324 insert into t7 values ('node1_committed_after');
325 insert into t7 values ('node1_committed_after');
326 insert into t7 values ('node1_committed_after');
327 insert into t7 values ('node1_committed_after');
328 insert into t6 values ('node1_committed_after');
329 insert into t6 values ('node1_committed_after');
330 insert into t6 values ('node1_committed_after');
331 insert into t6 values ('node1_committed_after');
332 insert into t6 values ('node1_committed_after');
333 insert into t5 values ('node1_committed_after');
334 insert into t5 values ('node1_committed_after');
335 insert into t5 values ('node1_committed_after');
336 insert into t5 values ('node1_committed_after');
337 insert into t5 values ('node1_committed_after');
338 insert into t4 values ('node1_committed_after');
339 insert into t4 values ('node1_committed_after');
340 insert into t4 values ('node1_committed_after');
341 insert into t4 values ('node1_committed_after');
342 insert into t4 values ('node1_committed_after');
343 insert into t3 values ('node1_committed_after');
344 insert into t3 values ('node1_committed_after');
345 insert into t3 values ('node1_committed_after');
346 insert into t3 values ('node1_committed_after');
347 insert into t3 values ('node1_committed_after');
348 insert into t2 values ('node1_committed_after');
349 insert into t2 values ('node1_committed_after');
350 insert into t2 values ('node1_committed_after');
351 insert into t2 values ('node1_committed_after');
352 insert into t2 values ('node1_committed_after');
353 insert into t1 values ('node1_committed_after');
354 insert into t1 values ('node1_committed_after');
355 insert into t1 values ('node1_committed_after');
356 insert into t1 values ('node1_committed_after');
357 insert into t1 values ('node1_committed_after');
358 COMMIT;
359 connection node_1a_galera_st_clean_slave;
360 ROLLBACK;
361 SELECT COUNT(*) FROM t1;
362 COUNT(*)
363 30
364 SELECT COUNT(*) FROM t2;
365 COUNT(*)
366 30
367 SELECT COUNT(*) FROM t3;
368 COUNT(*)
369 30
370 SELECT COUNT(*) FROM t4;
371 COUNT(*)
372 30
373 SELECT COUNT(*) FROM t5;
374 COUNT(*)
375 30
376 SELECT COUNT(*) FROM t6;
377 COUNT(*)
378 30
379 SELECT COUNT(*) FROM t7;
380 COUNT(*)
381 30
382 SELECT COUNT(*) FROM t8;
383 COUNT(*)
384 30
385 SELECT COUNT(*) FROM t9;
386 COUNT(*)
387 30
388 SELECT * FROM t1;
389 f1
390 node1_committed_before
391 node1_committed_before
392 node1_committed_before
393 node1_committed_before
394 node1_committed_before
395 node2_committed_before
396 node2_committed_before
397 node2_committed_before
398 node2_committed_before
399 node2_committed_before
400 node1_committed_during
401 node1_committed_during
402 node1_committed_during
403 node1_committed_during
404 node1_committed_during
405 node1_to_be_committed_after
406 node1_to_be_committed_after
407 node1_to_be_committed_after
408 node1_to_be_committed_after
409 node1_to_be_committed_after
410 node1_to_be_committed_after
411 node1_to_be_committed_after
412 node1_to_be_committed_after
413 node1_to_be_committed_after
414 node1_to_be_committed_after
415 node1_committed_after
416 node1_committed_after
417 node1_committed_after
418 node1_committed_after
419 node1_committed_after
420 SELECT * FROM t2;
421 f1
422 node1_committed_before
423 node1_committed_before
424 node1_committed_before
425 node1_committed_before
426 node1_committed_before
427 node2_committed_before
428 node2_committed_before
429 node2_committed_before
430 node2_committed_before
431 node2_committed_before
432 node1_committed_during
433 node1_committed_during
434 node1_committed_during
435 node1_committed_during
436 node1_committed_during
437 node1_to_be_committed_after
438 node1_to_be_committed_after
439 node1_to_be_committed_after
440 node1_to_be_committed_after
441 node1_to_be_committed_after
442 node1_to_be_committed_after
443 node1_to_be_committed_after
444 node1_to_be_committed_after
445 node1_to_be_committed_after
446 node1_to_be_committed_after
447 node1_committed_after
448 node1_committed_after
449 node1_committed_after
450 node1_committed_after
451 node1_committed_after
452 SELECT * FROM t3;
453 f1
454 node1_committed_before
455 node1_committed_before
456 node1_committed_before
457 node1_committed_before
458 node1_committed_before
459 node2_committed_before
460 node2_committed_before
461 node2_committed_before
462 node2_committed_before
463 node2_committed_before
464 node1_committed_during
465 node1_committed_during
466 node1_committed_during
467 node1_committed_during
468 node1_committed_during
469 node1_to_be_committed_after
470 node1_to_be_committed_after
471 node1_to_be_committed_after
472 node1_to_be_committed_after
473 node1_to_be_committed_after
474 node1_to_be_committed_after
475 node1_to_be_committed_after
476 node1_to_be_committed_after
477 node1_to_be_committed_after
478 node1_to_be_committed_after
479 node1_committed_after
480 node1_committed_after
481 node1_committed_after
482 node1_committed_after
483 node1_committed_after
484 SELECT * FROM t4;
485 f1
486 node1_committed_before
487 node1_committed_before
488 node1_committed_before
489 node1_committed_before
490 node1_committed_before
491 node2_committed_before
492 node2_committed_before
493 node2_committed_before
494 node2_committed_before
495 node2_committed_before
496 node1_committed_during
497 node1_committed_during
498 node1_committed_during
499 node1_committed_during
500 node1_committed_during
501 node1_to_be_committed_after
502 node1_to_be_committed_after
503 node1_to_be_committed_after
504 node1_to_be_committed_after
505 node1_to_be_committed_after
506 node1_to_be_committed_after
507 node1_to_be_committed_after
508 node1_to_be_committed_after
509 node1_to_be_committed_after
510 node1_to_be_committed_after
511 node1_committed_after
512 node1_committed_after
513 node1_committed_after
514 node1_committed_after
515 node1_committed_after
516 SELECT * FROM t5;
517 f1
518 node1_committed_before
519 node1_committed_before
520 node1_committed_before
521 node1_committed_before
522 node1_committed_before
523 node2_committed_before
524 node2_committed_before
525 node2_committed_before
526 node2_committed_before
527 node2_committed_before
528 node1_committed_during
529 node1_committed_during
530 node1_committed_during
531 node1_committed_during
532 node1_committed_during
533 node1_to_be_committed_after
534 node1_to_be_committed_after
535 node1_to_be_committed_after
536 node1_to_be_committed_after
537 node1_to_be_committed_after
538 node1_to_be_committed_after
539 node1_to_be_committed_after
540 node1_to_be_committed_after
541 node1_to_be_committed_after
542 node1_to_be_committed_after
543 node1_committed_after
544 node1_committed_after
545 node1_committed_after
546 node1_committed_after
547 node1_committed_after
548 SELECT * FROM t6;
549 f1
550 node1_committed_before
551 node1_committed_before
552 node1_committed_before
553 node1_committed_before
554 node1_committed_before
555 node2_committed_before
556 node2_committed_before
557 node2_committed_before
558 node2_committed_before
559 node2_committed_before
560 node1_committed_during
561 node1_committed_during
562 node1_committed_during
563 node1_committed_during
564 node1_committed_during
565 node1_to_be_committed_after
566 node1_to_be_committed_after
567 node1_to_be_committed_after
568 node1_to_be_committed_after
569 node1_to_be_committed_after
570 node1_to_be_committed_after
571 node1_to_be_committed_after
572 node1_to_be_committed_after
573 node1_to_be_committed_after
574 node1_to_be_committed_after
575 node1_committed_after
576 node1_committed_after
577 node1_committed_after
578 node1_committed_after
579 node1_committed_after
580 SELECT * FROM t7;
581 f1
582 node1_committed_before
583 node1_committed_before
584 node1_committed_before
585 node1_committed_before
586 node1_committed_before
587 node2_committed_before
588 node2_committed_before
589 node2_committed_before
590 node2_committed_before
591 node2_committed_before
592 node1_committed_during
593 node1_committed_during
594 node1_committed_during
595 node1_committed_during
596 node1_committed_during
597 node1_to_be_committed_after
598 node1_to_be_committed_after
599 node1_to_be_committed_after
600 node1_to_be_committed_after
601 node1_to_be_committed_after
602 node1_to_be_committed_after
603 node1_to_be_committed_after
604 node1_to_be_committed_after
605 node1_to_be_committed_after
606 node1_to_be_committed_after
607 node1_committed_after
608 node1_committed_after
609 node1_committed_after
610 node1_committed_after
611 node1_committed_after
612 SELECT * FROM t8;
613 f1
614 node1_committed_before
615 node1_committed_before
616 node1_committed_before
617 node1_committed_before
618 node1_committed_before
619 node2_committed_before
620 node2_committed_before
621 node2_committed_before
622 node2_committed_before
623 node2_committed_before
624 node1_committed_during
625 node1_committed_during
626 node1_committed_during
627 node1_committed_during
628 node1_committed_during
629 node1_to_be_committed_after
630 node1_to_be_committed_after
631 node1_to_be_committed_after
632 node1_to_be_committed_after
633 node1_to_be_committed_after
634 node1_to_be_committed_after
635 node1_to_be_committed_after
636 node1_to_be_committed_after
637 node1_to_be_committed_after
638 node1_to_be_committed_after
639 node1_committed_after
640 node1_committed_after
641 node1_committed_after
642 node1_committed_after
643 node1_committed_after
644 SELECT * FROM t9;
645 f1
646 node1_committed_before
647 node1_committed_before
648 node1_committed_before
649 node1_committed_before
650 node1_committed_before
651 node2_committed_before
652 node2_committed_before
653 node2_committed_before
654 node2_committed_before
655 node2_committed_before
656 node1_committed_during
657 node1_committed_during
658 node1_committed_during
659 node1_committed_during
660 node1_committed_during
661 node1_to_be_committed_after
662 node1_to_be_committed_after
663 node1_to_be_committed_after
664 node1_to_be_committed_after
665 node1_to_be_committed_after
666 node1_to_be_committed_after
667 node1_to_be_committed_after
668 node1_to_be_committed_after
669 node1_to_be_committed_after
670 node1_to_be_committed_after
671 node1_committed_after
672 node1_committed_after
673 node1_committed_after
674 node1_committed_after
675 node1_committed_after
676 COMMIT;
677 SET AUTOCOMMIT=ON;
678 connection node_1;
679 SELECT COUNT(*) FROM t1;
680 COUNT(*)
681 30
682 SELECT COUNT(*) FROM t2;
683 COUNT(*)
684 30
685 SELECT COUNT(*) FROM t3;
686 COUNT(*)
687 30
688 SELECT COUNT(*) FROM t4;
689 COUNT(*)
690 30
691 SELECT COUNT(*) FROM t5;
692 COUNT(*)
693 30
694 SELECT COUNT(*) FROM t6;
695 COUNT(*)
696 30
697 SELECT COUNT(*) FROM t7;
698 COUNT(*)
699 30
700 SELECT COUNT(*) FROM t8;
701 COUNT(*)
702 30
703 SELECT COUNT(*) FROM t9;
704 COUNT(*)
705 30
706 SELECT * FROM t1;
707 f1
708 node1_committed_before
709 node1_committed_before
710 node1_committed_before
711 node1_committed_before
712 node1_committed_before
713 node2_committed_before
714 node2_committed_before
715 node2_committed_before
716 node2_committed_before
717 node2_committed_before
718 node1_committed_during
719 node1_committed_during
720 node1_committed_during
721 node1_committed_during
722 node1_committed_during
723 node1_to_be_committed_after
724 node1_to_be_committed_after
725 node1_to_be_committed_after
726 node1_to_be_committed_after
727 node1_to_be_committed_after
728 node1_to_be_committed_after
729 node1_to_be_committed_after
730 node1_to_be_committed_after
731 node1_to_be_committed_after
732 node1_to_be_committed_after
733 node1_committed_after
734 node1_committed_after
735 node1_committed_after
736 node1_committed_after
737 node1_committed_after
738 SELECT * FROM t2;
739 f1
740 node1_committed_before
741 node1_committed_before
742 node1_committed_before
743 node1_committed_before
744 node1_committed_before
745 node2_committed_before
746 node2_committed_before
747 node2_committed_before
748 node2_committed_before
749 node2_committed_before
750 node1_committed_during
751 node1_committed_during
752 node1_committed_during
753 node1_committed_during
754 node1_committed_during
755 node1_to_be_committed_after
756 node1_to_be_committed_after
757 node1_to_be_committed_after
758 node1_to_be_committed_after
759 node1_to_be_committed_after
760 node1_to_be_committed_after
761 node1_to_be_committed_after
762 node1_to_be_committed_after
763 node1_to_be_committed_after
764 node1_to_be_committed_after
765 node1_committed_after
766 node1_committed_after
767 node1_committed_after
768 node1_committed_after
769 node1_committed_after
770 SELECT * FROM t3;
771 f1
772 node1_committed_before
773 node1_committed_before
774 node1_committed_before
775 node1_committed_before
776 node1_committed_before
777 node2_committed_before
778 node2_committed_before
779 node2_committed_before
780 node2_committed_before
781 node2_committed_before
782 node1_committed_during
783 node1_committed_during
784 node1_committed_during
785 node1_committed_during
786 node1_committed_during
787 node1_to_be_committed_after
788 node1_to_be_committed_after
789 node1_to_be_committed_after
790 node1_to_be_committed_after
791 node1_to_be_committed_after
792 node1_to_be_committed_after
793 node1_to_be_committed_after
794 node1_to_be_committed_after
795 node1_to_be_committed_after
796 node1_to_be_committed_after
797 node1_committed_after
798 node1_committed_after
799 node1_committed_after
800 node1_committed_after
801 node1_committed_after
802 SELECT * FROM t4;
803 f1
804 node1_committed_before
805 node1_committed_before
806 node1_committed_before
807 node1_committed_before
808 node1_committed_before
809 node2_committed_before
810 node2_committed_before
811 node2_committed_before
812 node2_committed_before
813 node2_committed_before
814 node1_committed_during
815 node1_committed_during
816 node1_committed_during
817 node1_committed_during
818 node1_committed_during
819 node1_to_be_committed_after
820 node1_to_be_committed_after
821 node1_to_be_committed_after
822 node1_to_be_committed_after
823 node1_to_be_committed_after
824 node1_to_be_committed_after
825 node1_to_be_committed_after
826 node1_to_be_committed_after
827 node1_to_be_committed_after
828 node1_to_be_committed_after
829 node1_committed_after
830 node1_committed_after
831 node1_committed_after
832 node1_committed_after
833 node1_committed_after
834 SELECT * FROM t5;
835 f1
836 node1_committed_before
837 node1_committed_before
838 node1_committed_before
839 node1_committed_before
840 node1_committed_before
841 node2_committed_before
842 node2_committed_before
843 node2_committed_before
844 node2_committed_before
845 node2_committed_before
846 node1_committed_during
847 node1_committed_during
848 node1_committed_during
849 node1_committed_during
850 node1_committed_during
851 node1_to_be_committed_after
852 node1_to_be_committed_after
853 node1_to_be_committed_after
854 node1_to_be_committed_after
855 node1_to_be_committed_after
856 node1_to_be_committed_after
857 node1_to_be_committed_after
858 node1_to_be_committed_after
859 node1_to_be_committed_after
860 node1_to_be_committed_after
861 node1_committed_after
862 node1_committed_after
863 node1_committed_after
864 node1_committed_after
865 node1_committed_after
866 SELECT * FROM t6;
867 f1
868 node1_committed_before
869 node1_committed_before
870 node1_committed_before
871 node1_committed_before
872 node1_committed_before
873 node2_committed_before
874 node2_committed_before
875 node2_committed_before
876 node2_committed_before
877 node2_committed_before
878 node1_committed_during
879 node1_committed_during
880 node1_committed_during
881 node1_committed_during
882 node1_committed_during
883 node1_to_be_committed_after
884 node1_to_be_committed_after
885 node1_to_be_committed_after
886 node1_to_be_committed_after
887 node1_to_be_committed_after
888 node1_to_be_committed_after
889 node1_to_be_committed_after
890 node1_to_be_committed_after
891 node1_to_be_committed_after
892 node1_to_be_committed_after
893 node1_committed_after
894 node1_committed_after
895 node1_committed_after
896 node1_committed_after
897 node1_committed_after
898 SELECT * FROM t7;
899 f1
900 node1_committed_before
901 node1_committed_before
902 node1_committed_before
903 node1_committed_before
904 node1_committed_before
905 node2_committed_before
906 node2_committed_before
907 node2_committed_before
908 node2_committed_before
909 node2_committed_before
910 node1_committed_during
911 node1_committed_during
912 node1_committed_during
913 node1_committed_during
914 node1_committed_during
915 node1_to_be_committed_after
916 node1_to_be_committed_after
917 node1_to_be_committed_after
918 node1_to_be_committed_after
919 node1_to_be_committed_after
920 node1_to_be_committed_after
921 node1_to_be_committed_after
922 node1_to_be_committed_after
923 node1_to_be_committed_after
924 node1_to_be_committed_after
925 node1_committed_after
926 node1_committed_after
927 node1_committed_after
928 node1_committed_after
929 node1_committed_after
930 SELECT * FROM t8;
931 f1
932 node1_committed_before
933 node1_committed_before
934 node1_committed_before
935 node1_committed_before
936 node1_committed_before
937 node2_committed_before
938 node2_committed_before
939 node2_committed_before
940 node2_committed_before
941 node2_committed_before
942 node1_committed_during
943 node1_committed_during
944 node1_committed_during
945 node1_committed_during
946 node1_committed_during
947 node1_to_be_committed_after
948 node1_to_be_committed_after
949 node1_to_be_committed_after
950 node1_to_be_committed_after
951 node1_to_be_committed_after
952 node1_to_be_committed_after
953 node1_to_be_committed_after
954 node1_to_be_committed_after
955 node1_to_be_committed_after
956 node1_to_be_committed_after
957 node1_committed_after
958 node1_committed_after
959 node1_committed_after
960 node1_committed_after
961 node1_committed_after
962 SELECT * FROM t9;
963 f1
964 node1_committed_before
965 node1_committed_before
966 node1_committed_before
967 node1_committed_before
968 node1_committed_before
969 node2_committed_before
970 node2_committed_before
971 node2_committed_before
972 node2_committed_before
973 node2_committed_before
974 node1_committed_during
975 node1_committed_during
976 node1_committed_during
977 node1_committed_during
978 node1_committed_during
979 node1_to_be_committed_after
980 node1_to_be_committed_after
981 node1_to_be_committed_after
982 node1_to_be_committed_after
983 node1_to_be_committed_after
984 node1_to_be_committed_after
985 node1_to_be_committed_after
986 node1_to_be_committed_after
987 node1_to_be_committed_after
988 node1_to_be_committed_after
989 node1_committed_after
990 node1_committed_after
991 node1_committed_after
992 node1_committed_after
993 node1_committed_after
994 COMMIT;
995 DROP TABLE t1,t2,t3,t4,t5,t6,t7,t8,t9;
996 COMMIT;
997 SET AUTOCOMMIT=ON;
998 disconnect node_2;
999 disconnect node_1;