Debian Codegraph @

mysql-test/suite/galera_sr/r/mysql-wsrep#215.result

raw
1 connection node_2;
2 connection node_1;
3 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
4 connection node_1;
5 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB;
6 SET SESSION wsrep_trx_fragment_size = 2;
7 SET SESSION wsrep_trx_fragment_unit = 'statements';
8 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
9 COUNT(*) = 0
10 1
11 SET AUTOCOMMIT=OFF;
12 START TRANSACTION;
13 connection node_1a;
14 SET GLOBAL DEBUG_DBUG = 'd,sync.wsrep_apply_cb';
15 SET SESSION wsrep_sync_wait = 0;
16 connection node_2;
17 INSERT INTO t1 VALUES (1);
18 connection node_1a;
19 SET SESSION debug_sync = "now WAIT_FOR sync.wsrep_apply_cb_reached";
20 SELECT COUNT(*) = 0 FROM t1;
21 COUNT(*) = 0
22 1
23 connection node_1;
24 SELECT COUNT(*) = 0 FROM t1;
25 COUNT(*) = 0
26 1
27 INSERT INTO t1 VALUES (1);;
28 connection node_1a;
29 connection node_1a;
30 SET GLOBAL DEBUG_DBUG = '';
31 SET DEBUG_SYNC='now SIGNAL signal.wsrep_apply_cb';
32 connection node_1;
33 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
34 COMMIT;
35 SELECT COUNT(*) = 1 FROM t1;
36 COUNT(*) = 1
37 1
38 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
39 COUNT(*) = 0
40 1
41 connection node_2;
42 SELECT COUNT(*) = 1 FROM t1;
43 COUNT(*) = 1
44 1
45 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
46 COUNT(*) = 0
47 1
48 connection node_1a;
49 SET DEBUG_SYNC = 'RESET';
50 connection node_1;
51 TRUNCATE TABLE t1;
52 SET SESSION wsrep_trx_fragment_size = 10;
53 SET SESSION wsrep_trx_fragment_unit = 'bytes';
54 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
55 COUNT(*) = 0
56 1
57 SET AUTOCOMMIT=OFF;
58 START TRANSACTION;
59 connection node_1a;
60 SET GLOBAL DEBUG_DBUG = 'd,sync.wsrep_apply_cb';
61 SET SESSION wsrep_sync_wait = 0;
62 connection node_2;
63 INSERT INTO t1 VALUES (1);
64 connection node_1a;
65 SET SESSION debug_sync = "now WAIT_FOR sync.wsrep_apply_cb_reached";
66 SELECT COUNT(*) = 0 FROM t1;
67 COUNT(*) = 0
68 1
69 connection node_1;
70 SELECT COUNT(*) = 0 FROM t1;
71 COUNT(*) = 0
72 1
73 INSERT INTO t1 VALUES (1);
74 connection node_1a;
75 SET GLOBAL DEBUG_DBUG = '';
76 SET DEBUG_SYNC='now SIGNAL signal.wsrep_apply_cb';
77 connection node_1;
78 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
79 ROLLBACK;
80 SELECT * FROM t1;
81 f1
82 1
83 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
84 COUNT(*) = 0
85 1
86 connection node_2;
87 SELECT * FROM t1;
88 f1
89 1
90 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
91 COUNT(*) = 0
92 1
93 connection node_1a;
94 SET DEBUG_SYNC = 'RESET';
95 connection node_1;
96 TRUNCATE TABLE t1;
97 SET SESSION wsrep_trx_fragment_size = 200;
98 SET SESSION wsrep_trx_fragment_unit = 'bytes';
99 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
100 COUNT(*) = 0
101 1
102 SET AUTOCOMMIT=OFF;
103 START TRANSACTION;
104 connection node_1a;
105 SET GLOBAL DEBUG_DBUG = 'd,sync.wsrep_apply_cb';
106 SET SESSION wsrep_sync_wait = 0;
107 connection node_2;
108 INSERT INTO t1 VALUES (1);
109 connection node_1a;
110 SET SESSION debug_sync = "now WAIT_FOR sync.wsrep_apply_cb_reached";
111 SELECT COUNT(*) = 0 FROM t1;
112 COUNT(*) = 0
113 1
114 connection node_1;
115 INSERT INTO t1 VALUES (1);
116 INSERT INTO t1 VALUES (2);
117 connection node_1a;
118 SET GLOBAL DEBUG_DBUG = '';
119 SET DEBUG_SYNC='now SIGNAL signal.wsrep_apply_cb';
120 connection node_1;
121 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
122 COMMIT;
123 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
124 COUNT(*) = 0
125 1
126 connection node_2;
127 SELECT COUNT(*) = 1 FROM t1;
128 COUNT(*) = 1
129 1
130 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
131 COUNT(*) = 0
132 1
133 connection node_1a;
134 DROP TABLE t1;
135 SET DEBUG_SYNC = 'RESET';
136 connection node_2;
137 CALL mtr.add_suppression("WSREP: Could not find applier context for");