Debian Codegraph @

mysql-test/suite/innodb/t/long_deadlock_cycle.test

raw
1 --source include/have_debug_sync.inc
2
3 # A scenario in which we choose the "joining" transaction (the
4 # one which added the last edge to form the cycle) con1 to be
5 # the victim
6
7 CREATE TABLE t1 (id INT NOT NULL PRIMARY KEY) Engine=InnoDB;
8 INSERT INTO t1 (id) VALUES (1),(2),(3),(4),(5);
9
10 --connect (con1, localhost, root,,)
11 BEGIN;
12 SELECT * FROM t1 WHERE id = 1 FOR UPDATE;
13
14 --connect (con2, localhost, root,,)
15 BEGIN;
16 SELECT * FROM t1 WHERE id = 2 FOR UPDATE;
17 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL con2_will_wait';
18 --send SELECT * FROM t1 WHERE id = 1 FOR UPDATE; ROLLBACK
19
20 --connect (con3, localhost, root,,)
21 BEGIN;
22 SET DEBUG_SYNC = 'now WAIT_FOR con2_will_wait';
23 SELECT * FROM t1 WHERE id = 3 FOR UPDATE;
24 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL con3_will_wait';
25 --send SELECT * FROM t1 WHERE id = 2 FOR UPDATE; ROLLBACK
26
27 --connect (con4, localhost, root,,)
28 BEGIN;
29 SET DEBUG_SYNC = 'now WAIT_FOR con3_will_wait';
30 SELECT * FROM t1 WHERE id = 4 FOR UPDATE;
31 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL con4_will_wait';
32 --send SELECT * FROM t1 WHERE id = 3 FOR UPDATE; ROLLBACK
33
34 --connection con1
35 SET DEBUG_SYNC = 'now WAIT_FOR con4_will_wait';
36 --error ER_LOCK_DEADLOCK
37 SELECT * FROM t1 WHERE id = 4 FOR UPDATE;
38
39 --connection con2
40 --reap
41
42 --connection con3
43 --reap
44
45 --connection con4
46 --reap
47
48 --source suite/innodb/include/show_last_deadlock.inc
49
50
51 # A scenario in which we choose the transaction waiting for our
52 # "joining" transaction, which is con2.
53
54 CREATE TABLE t2 (id INT NOT NULL PRIMARY KEY) Engine=InnoDB;
55 INSERT INTO t2 (id) VALUES (1),(2),(3),(4),(5);
56
57 --connection con1
58 BEGIN;
59 # Make con1 "heavy" so it is not chosen as victim
60 SELECT * FROM t2 FOR UPDATE;
61 SELECT * FROM t1 WHERE id = 1 FOR UPDATE;
62
63 --connection con2
64 BEGIN;
65 SELECT * FROM t1 WHERE id = 2 FOR UPDATE;
66 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL con2_will_wait';
67 --send SELECT * FROM t1 WHERE id = 1 FOR UPDATE; ROLLBACK
68
69 --connection con3
70 BEGIN;
71 SET DEBUG_SYNC = 'now WAIT_FOR con2_will_wait';
72 SELECT * FROM t1 WHERE id = 3 FOR UPDATE;
73 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL con3_will_wait';
74 --send SELECT * FROM t1 WHERE id = 2 FOR UPDATE; ROLLBACK
75
76 --connection con4
77 BEGIN;
78 SET DEBUG_SYNC = 'now WAIT_FOR con3_will_wait';
79 SELECT * FROM t1 WHERE id = 4 FOR UPDATE;
80 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL con4_will_wait';
81 --send SELECT * FROM t1 WHERE id = 3 FOR UPDATE; ROLLBACK
82
83 --connection con1
84 SET DEBUG_SYNC = 'now WAIT_FOR con4_will_wait';
85 SELECT * FROM t1 WHERE id = 4 FOR UPDATE;
86 ROLLBACK;
87
88 --connection con2
89 --error ER_LOCK_DEADLOCK
90 --reap
91
92 --connection con3
93 --reap
94
95 --connection con4
96 --reap
97
98 --source suite/innodb/include/show_last_deadlock.inc
99
100 --connection default
101 --disconnect con1
102 --disconnect con2
103 --disconnect con3
104 --disconnect con4
105
106
107 DROP TABLE t2;
108 DROP TABLE t1;