Debian Codegraph @

mysql-test/suite/galera/r/MW-402.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 p (f1 INTEGER PRIMARY KEY, f2 INTEGER) ENGINE=INNODB;
6 CREATE TABLE c (f1 INTEGER PRIMARY KEY, p_id INTEGER, f2 INTEGER,
7 CONSTRAINT fk_1 FOREIGN KEY (p_id) REFERENCES p (f1) ON DELETE CASCADE);
8 INSERT INTO p VALUES (1, 0);
9 INSERT INTO p VALUES (2, 0);
10 INSERT INTO c VALUES (1, 1, 0);
11 connection node_1a;
12 connection node_1;
13 SET AUTOCOMMIT=ON;
14 START TRANSACTION;
15 UPDATE c SET f2=1 where f1=1;
16 connection node_1a;
17 SET SESSION wsrep_sync_wait = 0;
18 SET GLOBAL DEBUG_DBUG = "d,sync.wsrep_apply_cb";
19 connection node_2;
20 DELETE FROM p WHERE f1 = 1;
21 connection node_1a;
22 SET SESSION DEBUG_SYNC = "now WAIT_FOR sync.wsrep_apply_cb_reached";
23 connection node_1;
24 SET SESSION DEBUG_SYNC = "wsrep_before_certification SIGNAL before_certification_reached WAIT_FOR continue_before_certification";
25 COMMIT;
26 connection node_1a;
27 SET SESSION DEBUG_SYNC = "now WAIT_FOR before_certification_reached";
28 SET SESSION DEBUG_SYNC = 'now SIGNAL continue_before_certification';
29 SET SESSION DEBUG_SYNC = 'now SIGNAL signal.wsrep_apply_cb';
30 SET GLOBAL DEBUG_DBUG = "";
31 SET DEBUG_SYNC = 'RESET';
32 connection node_1;
33 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
34 SET DEBUG_SYNC = 'RESET';
35 connection node_2;
36 SELECT * FROM p;
37 f1 f2
38 2 0
39 SELECT * FROM c;
40 f1 p_id f2
41 DROP TABLE c;
42 DROP TABLE p;
43 connection node_1;
44 CREATE TABLE p (f1 INTEGER PRIMARY KEY, f2 INTEGER) ENGINE=INNODB;
45 CREATE TABLE c (f1 INTEGER PRIMARY KEY, p_id INTEGER, f2 INTEGER,
46 CONSTRAINT fk_1 FOREIGN KEY (p_id) REFERENCES p (f1) ON UPDATE CASCADE);
47 INSERT INTO p VALUES (1, 0);
48 INSERT INTO p VALUES (2, 0);
49 INSERT INTO c VALUES (1, 1, 0);
50 connection node_1a;
51 connection node_1;
52 SET AUTOCOMMIT=ON;
53 START TRANSACTION;
54 UPDATE c SET f2=2 where f1=1;
55 connection node_1a;
56 SET SESSION wsrep_sync_wait = 0;
57 SET GLOBAL DEBUG_DBUG = "d,sync.wsrep_apply_cb";
58 connection node_2;
59 UPDATE p set f1=11 WHERE f1 = 1;
60 connection node_1a;
61 SET SESSION DEBUG_SYNC = "now WAIT_FOR sync.wsrep_apply_cb_reached";
62 connection node_1;
63 SET SESSION DEBUG_SYNC = "wsrep_before_certification SIGNAL before_certification_reached WAIT_FOR continue_before_certification";
64 COMMIT;
65 connection node_1a;
66 SET SESSION DEBUG_SYNC = "now WAIT_FOR before_certification_reached";
67 SET SESSION DEBUG_SYNC = 'now SIGNAL continue_before_certification';
68 SET SESSION DEBUG_SYNC = 'now SIGNAL signal.wsrep_apply_cb';
69 SET GLOBAL DEBUG_DBUG = "";
70 SET DEBUG_SYNC = 'RESET';
71 connection node_1;
72 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
73 SET DEBUG_SYNC = 'RESET';
74 connection node_2;
75 SELECT * FROM p;
76 f1 f2
77 2 0
78 11 0
79 SELECT * FROM c;
80 f1 p_id f2
81 1 11 0
82 DROP TABLE c;
83 DROP TABLE p;
84 connection node_1;
85 CREATE TABLE p (f1 INTEGER PRIMARY KEY, f2 INTEGER) ENGINE=INNODB;
86 CREATE TABLE c (f1 INTEGER PRIMARY KEY, p_id INTEGER, f2 INTEGER,
87 CONSTRAINT fk_1 FOREIGN KEY (p_id) REFERENCES p (f1) ON UPDATE CASCADE);
88 INSERT INTO p VALUES (1, 0);
89 INSERT INTO p VALUES (2, 0);
90 INSERT INTO c VALUES (1, 1, 0);
91 connection node_1a;
92 connection node_1;
93 SET AUTOCOMMIT=ON;
94 START TRANSACTION;
95 UPDATE c SET p_id=2 where f1=1;
96 connection node_1a;
97 SET SESSION wsrep_sync_wait = 0;
98 SET GLOBAL DEBUG_DBUG = "d,sync.wsrep_apply_cb";
99 connection node_2;
100 UPDATE p set f1=11 WHERE f1 = 1;
101 connection node_1a;
102 SET SESSION DEBUG_SYNC = "now WAIT_FOR sync.wsrep_apply_cb_reached";
103 connection node_1;
104 SET SESSION DEBUG_SYNC = "wsrep_before_certification SIGNAL before_certification_reached WAIT_FOR continue_before_certification";
105 COMMIT;
106 connection node_1a;
107 SET SESSION DEBUG_SYNC = "now WAIT_FOR before_certification_reached";
108 SET SESSION DEBUG_SYNC = 'now SIGNAL continue_before_certification';
109 SET SESSION DEBUG_SYNC = 'now SIGNAL signal.wsrep_apply_cb';
110 SET GLOBAL DEBUG_DBUG = "";
111 SET DEBUG_SYNC = 'RESET';
112 connection node_1;
113 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
114 SET DEBUG_SYNC = 'RESET';
115 connection node_2;
116 SELECT * FROM p;
117 f1 f2
118 2 0
119 11 0
120 SELECT * FROM c;
121 f1 p_id f2
122 1 11 0
123 connection node_1a;
124 connection node_1;
125 SET AUTOCOMMIT=ON;
126 START TRANSACTION;
127 UPDATE p set f1=21 WHERE f1 = 11;
128 connection node_1a;
129 SET SESSION wsrep_sync_wait = 0;
130 SET GLOBAL DEBUG_DBUG = "d,sync.wsrep_apply_cb";
131 connection node_2;
132 UPDATE c SET p_id=2 where f1=1;
133 connection node_1a;
134 SET SESSION DEBUG_SYNC = "now WAIT_FOR sync.wsrep_apply_cb_reached";
135 connection node_1;
136 SET SESSION DEBUG_SYNC = "wsrep_before_certification SIGNAL before_certification_reached WAIT_FOR continue_before_certification";
137 COMMIT;
138 connection node_1a;
139 SET SESSION DEBUG_SYNC = "now WAIT_FOR before_certification_reached";
140 SET SESSION DEBUG_SYNC = 'now SIGNAL continue_before_certification';
141 SET SESSION DEBUG_SYNC = 'now SIGNAL signal.wsrep_apply_cb';
142 SET GLOBAL DEBUG_DBUG = "";
143 SET DEBUG_SYNC = 'RESET';
144 connection node_1;
145 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
146 SET DEBUG_SYNC = 'RESET';
147 connection node_2;
148 SELECT * FROM p;
149 f1 f2
150 2 0
151 11 0
152 SELECT * FROM c;
153 f1 p_id f2
154 1 2 0
155 DROP TABLE c;
156 DROP TABLE p;
157 connection node_1;
158 CREATE TABLE p1 (f1 INTEGER PRIMARY KEY, f2 INTEGER) ENGINE=INNODB;
159 CREATE TABLE p2 (f1 INTEGER PRIMARY KEY, f2 INTEGER) ENGINE=INNODB;
160 CREATE TABLE c (f1 INTEGER PRIMARY KEY, p1_id INTEGER, p2_id INTEGER,
161 f2 INTEGER,
162 CONSTRAINT fk_1 FOREIGN KEY (p1_id) REFERENCES p1 (f1)
163 ON DELETE CASCADE,
164 CONSTRAINT fk_2 FOREIGN KEY (p2_id) REFERENCES p2 (f1));
165 INSERT INTO p1 VALUES (1, 0);
166 INSERT INTO p2 VALUES (1, 0);
167 INSERT INTO c VALUES (1, 1, 1, 0);
168 connection node_1a;
169 connection node_1;
170 SET AUTOCOMMIT=ON;
171 START TRANSACTION;
172 UPDATE p2 SET f2=2 where f1=1;
173 connection node_1a;
174 SET SESSION wsrep_sync_wait = 0;
175 SET GLOBAL DEBUG_DBUG = "d,sync.wsrep_apply_cb";
176 connection node_2;
177 DELETE FROM p1 WHERE f1 = 1;
178 connection node_1a;
179 SET SESSION DEBUG_SYNC = "now WAIT_FOR sync.wsrep_apply_cb_reached";
180 connection node_1;
181 SET SESSION DEBUG_SYNC = "wsrep_before_certification SIGNAL before_certification_reached WAIT_FOR continue_before_certification";
182 COMMIT;
183 connection node_1a;
184 SET SESSION DEBUG_SYNC = "now WAIT_FOR before_certification_reached";
185 SET SESSION DEBUG_SYNC = 'now SIGNAL continue_before_certification';
186 SET SESSION DEBUG_SYNC = 'now SIGNAL signal.wsrep_apply_cb';
187 SET GLOBAL DEBUG_DBUG = "";
188 SET DEBUG_SYNC = 'RESET';
189 connection node_1;
190 SET DEBUG_SYNC = 'RESET';
191 connection node_2;
192 SELECT * FROM p1;
193 f1 f2
194 SELECT * FROM p2;
195 f1 f2
196 1 2
197 SELECT * FROM c;
198 f1 p1_id p2_id f2
199 DROP TABLE c;
200 DROP TABLE p1;
201 DROP TABLE p2;
202 connection node_1;
203 CREATE TABLE p1 (f1 INTEGER PRIMARY KEY, f2 INTEGER) ENGINE=INNODB;
204 CREATE TABLE p2 (f1 INTEGER PRIMARY KEY, f2 INTEGER) ENGINE=INNODB;
205 CREATE TABLE c (f1 INTEGER PRIMARY KEY, p1_id INTEGER, p2_id INTEGER,
206 f2 INTEGER,
207 CONSTRAINT fk_1 FOREIGN KEY (p1_id) REFERENCES p1 (f1)
208 ON DELETE CASCADE,
209 CONSTRAINT fk_2 FOREIGN KEY (p2_id) REFERENCES p2 (f1)
210 ON DELETE CASCADE);
211 INSERT INTO p1 VALUES (1, 0);
212 INSERT INTO p2 VALUES (1, 0);
213 INSERT INTO c VALUES (1, 1, 1, 0);
214 connection node_1a;
215 connection node_1;
216 SET AUTOCOMMIT=ON;
217 START TRANSACTION;
218 DELETE FROM p2 WHERE f1=1;
219 connection node_1a;
220 SET SESSION wsrep_sync_wait = 0;
221 SET GLOBAL DEBUG_DBUG = "d,sync.wsrep_apply_cb";
222 connection node_2;
223 DELETE FROM p1 WHERE f1=1;
224 connection node_1a;
225 SET SESSION DEBUG_SYNC = "now WAIT_FOR sync.wsrep_apply_cb_reached";
226 connection node_1;
227 SET SESSION DEBUG_SYNC = "wsrep_before_certification SIGNAL before_certification_reached WAIT_FOR continue_before_certification";
228 COMMIT;
229 connection node_1a;
230 SET SESSION DEBUG_SYNC = "now WAIT_FOR before_certification_reached";
231 SET SESSION DEBUG_SYNC = 'now SIGNAL continue_before_certification';
232 SET SESSION DEBUG_SYNC = 'now SIGNAL signal.wsrep_apply_cb';
233 SET GLOBAL DEBUG_DBUG = "";
234 SET DEBUG_SYNC = 'RESET';
235 connection node_1;
236 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
237 SET DEBUG_SYNC = 'RESET';
238 connection node_2;
239 SELECT * FROM p1;
240 f1 f2
241 SELECT * FROM p2;
242 f1 f2
243 1 0
244 SELECT * FROM c;
245 f1 p1_id p2_id f2
246 DROP TABLE c,p1,p2;