Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE grandparent (
4 id INT NOT NULL PRIMARY KEY
5 ) ENGINE=InnoDB;
6 CREATE TABLE parent (
7 id INT NOT NULL PRIMARY KEY,
8 grandparent_id INT,
9 FOREIGN KEY (grandparent_id)
10 REFERENCES grandparent(id)
11 ON UPDATE CASCADE
12 ) ENGINE=InnoDB;
13 CREATE TABLE child (
14 id INT NOT NULL PRIMARY KEY,
15 grandparent_id INT,
16 FOREIGN KEY (grandparent_id)
17 REFERENCES parent(grandparent_id)
18 ON UPDATE CASCADE
19 ) ENGINE=InnoDB;
20 INSERT INTO grandparent VALUES (1),(2),(3),(4);
21 INSERT INTO parent VALUES (1,1), (2,2);
22 INSERT INTO child VALUES (1,1), (2,2);
23 connection node_1;
24 SET AUTOCOMMIT=OFF;
25 SET SESSION wsrep_trx_fragment_size = 1;
26 START TRANSACTION;
27 UPDATE grandparent SET id = 5 WHERE id = 1;
28 connection node_2;
29 SET SESSION innodb_lock_wait_timeout = 1;
30 UPDATE grandparent SET id = 10 WHERE id = 5;
31 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
32 DELETE FROM child;
33 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
34 connection node_1;
35 COMMIT;
36 include/diff_servers.inc [servers=1 2]
37 DROP TABLE child;
38 DROP TABLE parent;
39 DROP TABLE grandparent;