Debian Codegraph @

mysql-test/suite/galera_sr/r/galera_sr_bf_abort.result

raw
1 connection node_2;
2 connection node_1;
3 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
4 SET SESSION wsrep_sync_wait = 0;
5 galera_sr_bf_abort_at_commit = 0
6 after_replicate_sync
7 connection node_1;
8 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
9 SET SESSION wsrep_trx_fragment_size = 1;
10 SET AUTOCOMMIT=OFF;
11 INSERT INTO t1 VALUES (1);
12 SELECT * FROM t1 FOR UPDATE;
13 f1
14 1
15 connection node_1a;
16 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync';
17 connection node_2;
18 SET AUTOCOMMIT=ON;
19 INSERT INTO t1 VALUES (2);
20 connection node_1a;
21 SET SESSION wsrep_on = 0;
22 SET SESSION wsrep_on = 1;
23 SET GLOBAL wsrep_provider_options = 'dbug=';
24 SET GLOBAL wsrep_provider_options = 'dbug=d,after_replicate_sync';
25 connection node_1;
26 INSERT INTO t1 VALUES (3);
27 connection node_1a;
28 SET SESSION wsrep_on = 0;
29 SET SESSION wsrep_on = 1;
30 SET GLOBAL wsrep_provider_options = 'dbug=';
31 SET GLOBAL wsrep_provider_options = 'dbug=d,abort_trx_end';
32 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
33 SET SESSION wsrep_on = 0;
34 SET SESSION wsrep_on = 1;
35 SET GLOBAL wsrep_provider_options = 'dbug=';
36 SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end';
37 SET GLOBAL wsrep_provider_options = 'signal=after_replicate_sync';
38 connection node_1;
39 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
40 ROLLBACK;
41 connection node_1a;
42 SET GLOBAL wsrep_provider_options = 'dbug=';
43 SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end';
44 connection node_1;
45 SELECT * FROM t1;
46 f1
47 2
48 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2;
49 COUNT(*) = 1
50 1
51 connection node_2;
52 SELECT * FROM t1;
53 f1
54 2
55 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2;
56 COUNT(*) = 1
57 1
58 connection node_1;
59 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
60 COUNT(*) = 0
61 1
62 connection node_2;
63 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
64 COUNT(*) = 0
65 1
66 connection node_1;
67 SET AUTOCOMMIT=ON;
68 SET SESSION wsrep_trx_fragment_size = 0;
69 DELETE FROM t1;
70 DROP TABLE t1;
71 local_monitor_master_enter_sync
72 connection node_1;
73 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
74 SET SESSION wsrep_trx_fragment_size = 1;
75 SET AUTOCOMMIT=OFF;
76 INSERT INTO t1 VALUES (1);
77 SELECT * FROM t1 FOR UPDATE;
78 f1
79 1
80 connection node_1a;
81 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync';
82 connection node_2;
83 SET AUTOCOMMIT=ON;
84 INSERT INTO t1 VALUES (2);
85 connection node_1a;
86 SET SESSION wsrep_on = 0;
87 SET SESSION wsrep_on = 1;
88 SET GLOBAL wsrep_provider_options = 'dbug=';
89 SET GLOBAL wsrep_provider_options = 'dbug=d,local_monitor_master_enter_sync';
90 connection node_1;
91 INSERT INTO t1 VALUES (3);
92 connection node_1a;
93 SET SESSION wsrep_on = 0;
94 SET SESSION wsrep_on = 1;
95 SET GLOBAL wsrep_provider_options = 'dbug=';
96 SET GLOBAL wsrep_provider_options = 'dbug=d,abort_trx_end';
97 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
98 SET SESSION wsrep_on = 0;
99 SET SESSION wsrep_on = 1;
100 SET GLOBAL wsrep_provider_options = 'dbug=';
101 SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end';
102 SET GLOBAL wsrep_provider_options = 'signal=local_monitor_master_enter_sync';
103 connection node_1;
104 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
105 ROLLBACK;
106 connection node_1a;
107 SET GLOBAL wsrep_provider_options = 'dbug=';
108 SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end';
109 connection node_1;
110 SELECT * FROM t1;
111 f1
112 2
113 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2;
114 COUNT(*) = 1
115 1
116 connection node_2;
117 SELECT * FROM t1;
118 f1
119 2
120 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2;
121 COUNT(*) = 1
122 1
123 connection node_1;
124 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
125 COUNT(*) = 0
126 1
127 connection node_2;
128 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
129 COUNT(*) = 0
130 1
131 connection node_1;
132 SET AUTOCOMMIT=ON;
133 SET SESSION wsrep_trx_fragment_size = 0;
134 DELETE FROM t1;
135 DROP TABLE t1;
136 apply_monitor_master_enter_sync
137 connection node_1;
138 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
139 SET SESSION wsrep_trx_fragment_size = 1;
140 SET AUTOCOMMIT=OFF;
141 INSERT INTO t1 VALUES (1);
142 SELECT * FROM t1 FOR UPDATE;
143 f1
144 1
145 connection node_1a;
146 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync';
147 connection node_2;
148 SET AUTOCOMMIT=ON;
149 INSERT INTO t1 VALUES (2);
150 connection node_1a;
151 SET SESSION wsrep_on = 0;
152 SET SESSION wsrep_on = 1;
153 SET GLOBAL wsrep_provider_options = 'dbug=';
154 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_master_enter_sync';
155 connection node_1;
156 INSERT INTO t1 VALUES (3);
157 connection node_1a;
158 SET SESSION wsrep_on = 0;
159 SET SESSION wsrep_on = 1;
160 SET GLOBAL wsrep_provider_options = 'dbug=';
161 SET GLOBAL wsrep_provider_options = 'dbug=d,abort_trx_end';
162 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
163 SET SESSION wsrep_on = 0;
164 SET SESSION wsrep_on = 1;
165 SET GLOBAL wsrep_provider_options = 'dbug=';
166 SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end';
167 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_master_enter_sync';
168 connection node_1;
169 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
170 ROLLBACK;
171 connection node_1a;
172 SET GLOBAL wsrep_provider_options = 'dbug=';
173 SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end';
174 connection node_1;
175 SELECT * FROM t1;
176 f1
177 2
178 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2;
179 COUNT(*) = 1
180 1
181 connection node_2;
182 SELECT * FROM t1;
183 f1
184 2
185 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2;
186 COUNT(*) = 1
187 1
188 connection node_1;
189 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
190 COUNT(*) = 0
191 1
192 connection node_2;
193 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
194 COUNT(*) = 0
195 1
196 connection node_1;
197 SET AUTOCOMMIT=ON;
198 SET SESSION wsrep_trx_fragment_size = 0;
199 DELETE FROM t1;
200 DROP TABLE t1;
201 commit_monitor_master_enter_sync
202 connection node_1;
203 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
204 SET SESSION wsrep_trx_fragment_size = 1;
205 SET AUTOCOMMIT=OFF;
206 INSERT INTO t1 VALUES (1);
207 SELECT * FROM t1 FOR UPDATE;
208 f1
209 1
210 connection node_1a;
211 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync';
212 connection node_2;
213 SET AUTOCOMMIT=ON;
214 INSERT INTO t1 VALUES (2);
215 connection node_1a;
216 SET SESSION wsrep_on = 0;
217 SET SESSION wsrep_on = 1;
218 SET GLOBAL wsrep_provider_options = 'dbug=';
219 SET GLOBAL wsrep_provider_options = 'dbug=d,commit_monitor_master_enter_sync';
220 connection node_1;
221 INSERT INTO t1 VALUES (3);
222 connection node_1a;
223 SET SESSION wsrep_on = 0;
224 SET SESSION wsrep_on = 1;
225 SET GLOBAL wsrep_provider_options = 'dbug=';
226 SET GLOBAL wsrep_provider_options = 'dbug=d,abort_trx_end';
227 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
228 SET SESSION wsrep_on = 0;
229 SET SESSION wsrep_on = 1;
230 SET GLOBAL wsrep_provider_options = 'dbug=';
231 SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end';
232 SET GLOBAL wsrep_provider_options = 'signal=commit_monitor_master_enter_sync';
233 connection node_1;
234 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
235 ROLLBACK;
236 connection node_1a;
237 SET GLOBAL wsrep_provider_options = 'dbug=';
238 SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end';
239 connection node_1;
240 SELECT * FROM t1;
241 f1
242 2
243 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2;
244 COUNT(*) = 1
245 1
246 connection node_2;
247 SELECT * FROM t1;
248 f1
249 2
250 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2;
251 COUNT(*) = 1
252 1
253 connection node_1;
254 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
255 COUNT(*) = 0
256 1
257 connection node_2;
258 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
259 COUNT(*) = 0
260 1
261 connection node_1;
262 SET AUTOCOMMIT=ON;
263 SET SESSION wsrep_trx_fragment_size = 0;
264 DELETE FROM t1;
265 DROP TABLE t1;
266 galera_sr_bf_abort_at_commit = 1
267 after_replicate_sync
268 connection node_1;
269 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
270 SET SESSION wsrep_trx_fragment_size = 1;
271 SET AUTOCOMMIT=OFF;
272 INSERT INTO t1 VALUES (1);
273 SELECT * FROM t1 FOR UPDATE;
274 f1
275 1
276 connection node_1a;
277 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync';
278 connection node_2;
279 SET AUTOCOMMIT=ON;
280 INSERT INTO t1 VALUES (2);
281 connection node_1a;
282 SET SESSION wsrep_on = 0;
283 SET SESSION wsrep_on = 1;
284 SET GLOBAL wsrep_provider_options = 'dbug=';
285 SET GLOBAL wsrep_provider_options = 'dbug=d,after_replicate_sync';
286 connection node_1;
287 COMMIT;
288 connection node_1a;
289 SET SESSION wsrep_on = 0;
290 SET SESSION wsrep_on = 1;
291 SET GLOBAL wsrep_provider_options = 'dbug=';
292 SET GLOBAL wsrep_provider_options = 'dbug=d,abort_trx_end';
293 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
294 SET SESSION wsrep_on = 0;
295 SET SESSION wsrep_on = 1;
296 SET GLOBAL wsrep_provider_options = 'dbug=';
297 SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end';
298 SET GLOBAL wsrep_provider_options = 'signal=after_replicate_sync';
299 connection node_1;
300 ROLLBACK;
301 connection node_1a;
302 SET GLOBAL wsrep_provider_options = 'dbug=';
303 SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end';
304 connection node_1;
305 SELECT * FROM t1;
306 f1
307 1
308 2
309 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 1;
310 COUNT(*) = 1
311 1
312 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2;
313 COUNT(*) = 1
314 1
315 connection node_2;
316 SELECT * FROM t1;
317 f1
318 1
319 2
320 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 1;
321 COUNT(*) = 1
322 1
323 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2;
324 COUNT(*) = 1
325 1
326 connection node_1;
327 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
328 COUNT(*) = 0
329 1
330 connection node_2;
331 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
332 COUNT(*) = 0
333 1
334 connection node_1;
335 SET AUTOCOMMIT=ON;
336 SET SESSION wsrep_trx_fragment_size = 0;
337 DELETE FROM t1;
338 DROP TABLE t1;
339 local_monitor_master_enter_sync
340 connection node_1;
341 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
342 SET SESSION wsrep_trx_fragment_size = 1;
343 SET AUTOCOMMIT=OFF;
344 INSERT INTO t1 VALUES (1);
345 SELECT * FROM t1 FOR UPDATE;
346 f1
347 1
348 connection node_1a;
349 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync';
350 connection node_2;
351 SET AUTOCOMMIT=ON;
352 INSERT INTO t1 VALUES (2);
353 connection node_1a;
354 SET SESSION wsrep_on = 0;
355 SET SESSION wsrep_on = 1;
356 SET GLOBAL wsrep_provider_options = 'dbug=';
357 SET GLOBAL wsrep_provider_options = 'dbug=d,local_monitor_master_enter_sync';
358 connection node_1;
359 COMMIT;
360 connection node_1a;
361 SET SESSION wsrep_on = 0;
362 SET SESSION wsrep_on = 1;
363 SET GLOBAL wsrep_provider_options = 'dbug=';
364 SET GLOBAL wsrep_provider_options = 'dbug=d,abort_trx_end';
365 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
366 SET SESSION wsrep_on = 0;
367 SET SESSION wsrep_on = 1;
368 SET GLOBAL wsrep_provider_options = 'dbug=';
369 SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end';
370 SET GLOBAL wsrep_provider_options = 'signal=local_monitor_master_enter_sync';
371 connection node_1;
372 ROLLBACK;
373 connection node_1a;
374 SET GLOBAL wsrep_provider_options = 'dbug=';
375 SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end';
376 connection node_1;
377 SELECT * FROM t1;
378 f1
379 1
380 2
381 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 1;
382 COUNT(*) = 1
383 1
384 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2;
385 COUNT(*) = 1
386 1
387 connection node_2;
388 SELECT * FROM t1;
389 f1
390 1
391 2
392 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 1;
393 COUNT(*) = 1
394 1
395 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2;
396 COUNT(*) = 1
397 1
398 connection node_1;
399 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
400 COUNT(*) = 0
401 1
402 connection node_2;
403 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
404 COUNT(*) = 0
405 1
406 connection node_1;
407 SET AUTOCOMMIT=ON;
408 SET SESSION wsrep_trx_fragment_size = 0;
409 DELETE FROM t1;
410 DROP TABLE t1;
411 apply_monitor_master_enter_sync
412 connection node_1;
413 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
414 SET SESSION wsrep_trx_fragment_size = 1;
415 SET AUTOCOMMIT=OFF;
416 INSERT INTO t1 VALUES (1);
417 SELECT * FROM t1 FOR UPDATE;
418 f1
419 1
420 connection node_1a;
421 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync';
422 connection node_2;
423 SET AUTOCOMMIT=ON;
424 INSERT INTO t1 VALUES (2);
425 connection node_1a;
426 SET SESSION wsrep_on = 0;
427 SET SESSION wsrep_on = 1;
428 SET GLOBAL wsrep_provider_options = 'dbug=';
429 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_master_enter_sync';
430 connection node_1;
431 COMMIT;
432 connection node_1a;
433 SET SESSION wsrep_on = 0;
434 SET SESSION wsrep_on = 1;
435 SET GLOBAL wsrep_provider_options = 'dbug=';
436 SET GLOBAL wsrep_provider_options = 'dbug=d,abort_trx_end';
437 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
438 SET SESSION wsrep_on = 0;
439 SET SESSION wsrep_on = 1;
440 SET GLOBAL wsrep_provider_options = 'dbug=';
441 SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end';
442 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_master_enter_sync';
443 connection node_1;
444 ROLLBACK;
445 connection node_1a;
446 SET GLOBAL wsrep_provider_options = 'dbug=';
447 SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end';
448 connection node_1;
449 SELECT * FROM t1;
450 f1
451 1
452 2
453 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 1;
454 COUNT(*) = 1
455 1
456 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2;
457 COUNT(*) = 1
458 1
459 connection node_2;
460 SELECT * FROM t1;
461 f1
462 1
463 2
464 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 1;
465 COUNT(*) = 1
466 1
467 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2;
468 COUNT(*) = 1
469 1
470 connection node_1;
471 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
472 COUNT(*) = 0
473 1
474 connection node_2;
475 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
476 COUNT(*) = 0
477 1
478 connection node_1;
479 SET AUTOCOMMIT=ON;
480 SET SESSION wsrep_trx_fragment_size = 0;
481 DELETE FROM t1;
482 DROP TABLE t1;
483 commit_monitor_master_enter_sync
484 connection node_1;
485 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
486 SET SESSION wsrep_trx_fragment_size = 1;
487 SET AUTOCOMMIT=OFF;
488 INSERT INTO t1 VALUES (1);
489 SELECT * FROM t1 FOR UPDATE;
490 f1
491 1
492 connection node_1a;
493 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync';
494 connection node_2;
495 SET AUTOCOMMIT=ON;
496 INSERT INTO t1 VALUES (2);
497 connection node_1a;
498 SET SESSION wsrep_on = 0;
499 SET SESSION wsrep_on = 1;
500 SET GLOBAL wsrep_provider_options = 'dbug=';
501 SET GLOBAL wsrep_provider_options = 'dbug=d,commit_monitor_master_enter_sync';
502 connection node_1;
503 COMMIT;
504 connection node_1a;
505 SET SESSION wsrep_on = 0;
506 SET SESSION wsrep_on = 1;
507 SET GLOBAL wsrep_provider_options = 'dbug=';
508 SET GLOBAL wsrep_provider_options = 'dbug=d,abort_trx_end';
509 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
510 SET SESSION wsrep_on = 0;
511 SET SESSION wsrep_on = 1;
512 SET GLOBAL wsrep_provider_options = 'dbug=';
513 SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end';
514 SET GLOBAL wsrep_provider_options = 'signal=commit_monitor_master_enter_sync';
515 connection node_1;
516 ROLLBACK;
517 connection node_1a;
518 SET GLOBAL wsrep_provider_options = 'dbug=';
519 SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end';
520 connection node_1;
521 SELECT * FROM t1;
522 f1
523 1
524 2
525 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 1;
526 COUNT(*) = 1
527 1
528 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2;
529 COUNT(*) = 1
530 1
531 connection node_2;
532 SELECT * FROM t1;
533 f1
534 1
535 2
536 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 1;
537 COUNT(*) = 1
538 1
539 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2;
540 COUNT(*) = 1
541 1
542 connection node_1;
543 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
544 COUNT(*) = 0
545 1
546 connection node_2;
547 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
548 COUNT(*) = 0
549 1
550 connection node_1;
551 SET AUTOCOMMIT=ON;
552 SET SESSION wsrep_trx_fragment_size = 0;
553 DELETE FROM t1;
554 DROP TABLE t1;
555 CALL mtr.add_suppression("WSREP: fragment replication failed: 1");