Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE parent(parent_id int not null AUTO_INCREMENT PRIMARY KEY,
4 parent_name varchar(80)) ENGINE=InnoDB;
5 CREATE TABLE child(child_id int not null AUTO_INCREMENT PRIMARY KEY,
6 child_name varchar(80),
7 child_parent_id int not null,
8 CONSTRAINT `fk_child_parent`
9 FOREIGN KEY (child_parent_id) REFERENCES parent (parent_id)
10 ON DELETE CASCADE
11 ON UPDATE CASCADE) ENGINE=InnoDB;
12 INSERT INTO parent VALUES (1, 'first'),(2,'second'),(3,'foo'),(4,'tmp');
13 INSERT INTO child VALUES (NULL,'first_child',1);
14 INSERT INTO child VALUES (NULL,'second_child',1);
15 INSERT INTO child VALUES (NULL,'first_child2',2);
16 INSERT INTO child VALUES (NULL,'first_child3',2);
17 INSERT INTO child VALUES (NULL,'first_child4',3);
18 BEGIN;
19 UPDATE parent SET parent_name = 'bar' WHERE parent_id = 2;
20 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
21 SET SESSION innodb_lock_wait_timeout=2;
22 UPDATE child SET child_parent_id = 5 where child_parent_id = 2;
23 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
24 connection node_1;
25 COMMIT;
26 SELECT * FROM parent;
27 parent_id parent_name
28 1 first
29 2 bar
30 3 foo
31 4 tmp
32 SELECT * FROM child;
33 child_id child_name child_parent_id
34 1 first_child 1
35 3 second_child 1
36 5 first_child2 2
37 7 first_child3 2
38 9 first_child4 3
39 connection node_2;
40 SELECT * FROM parent;
41 parent_id parent_name
42 1 first
43 2 bar
44 3 foo
45 4 tmp
46 SELECT * FROM child;
47 child_id child_name child_parent_id
48 1 first_child 1
49 3 second_child 1
50 5 first_child2 2
51 7 first_child3 2
52 9 first_child4 3
53 DROP TABLE child, parent;
54 disconnect node_1a;