Debian Codegraph @

mysql-test/suite/galera/r/MW-369.result

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