Debian Codegraph @

mysql-test/suite/galera_3nodes/r/galera_certification_double_failure.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 CREATE TABLE t2 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
6 SET AUTOCOMMIT=OFF;
7 START TRANSACTION;
8 INSERT INTO t1 VALUES (1);
9 INSERT INTO t2 VALUES (1);
10 connection node_2;
11 INSERT INTO t1 VALUES (1);
12 connection node_3;
13 INSERT INTO t2 VALUES (1);
14 connection node_1;
15 COMMIT;
16 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
17 connection node_3;
18 DROP TABLE t1;
19 DROP TABLE t2;