Debian Codegraph @

mysql-test/suite/galera/r/galera_insert_bulk.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
5 SET GLOBAL DEBUG_DBUG = 'd,sync.wsrep_apply_cb';
6 connection node_1;
7 SET foreign_key_checks = 0;
8 SET unique_checks = 0;
9 START TRANSACTION;
10 connection node_2;
11 SET foreign_key_checks = 1;
12 SET unique_checks = 1;
13 INSERT INTO t1 VALUES (1001);
14 connection node_1;
15 SET DEBUG_SYNC = 'wsrep_before_certification WAIT_FOR sync.wsrep_apply_cb_reached';
16 SET DEBUG_SYNC = 'wsrep_after_certification SIGNAL signal.wsrep_apply_cb';
17 COMMIT;
18 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
19 DROP TABLE t1;
20 SET GLOBAL DEBUG_DBUG = '';
21 SET DEBUG_SYNC = 'RESET';
22 connection node_1;
23 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
24 connection node_2;
25 SET GLOBAL DEBUG_DBUG = 'd,sync.wsrep_apply_cb';
26 connection node_1;
27 SET foreign_key_checks = 0;
28 SET unique_checks = 0;
29 START TRANSACTION;
30 connection node_2;
31 SET foreign_key_checks = 1;
32 SET unique_checks = 1;
33 START TRANSACTION;
34 INSERT INTO t1 VALUES (1001);
35 connection node_1;
36 COMMIT;
37 3
38 connection node_2;
39 SET DEBUG_SYNC = 'wsrep_before_certification WAIT_FOR sync.wsrep_apply_cb_reached';
40 SET DEBUG_SYNC = 'wsrep_after_certification SIGNAL signal.wsrep_apply_cb';
41 COMMIT;
42 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
43 DROP TABLE t1;
44 SET GLOBAL DEBUG_DBUG = '';
45 SET DEBUG_SYNC = 'RESET';
46 disconnect node_2;
47 disconnect node_1;