Debian Codegraph @

mysql-test/suite/galera_sr/r/mysql-wsrep-features#165.result

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