Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE parent (
4 id INT PRIMARY KEY,
5 KEY (id)
6 ) ENGINE=InnoDB;
7 CREATE TABLE child (
8 id INT PRIMARY KEY,
9 parent_id INT,
10 FOREIGN KEY (parent_id)
11 REFERENCES parent(id)
12 ) ENGINE=InnoDB;
13 INSERT INTO parent VALUES (1), (2);
14 INSERT INTO child VALUES (1,1);
15 connection node_1;
16 SET AUTOCOMMIT = OFF;
17 START TRANSACTION;
18 DELETE FROM parent WHERE id = 2;
19 connection node_2;
20 SET AUTOCOMMIT = OFF;
21 START TRANSACTION;
22 INSERT INTO child VALUES (2, 2);
23 connection node_1;
24 COMMIT;
25 connection node_2;
26 COMMIT;
27 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
28 DROP TABLE child;
29 DROP TABLE parent;