Debian Codegraph @

mysql-test/suite/innodb/r/deadlock_on_lock_upgrade.result

raw
1 #
2 # Bug #23755664 DEADLOCK WITH 3 CONCURRENT DELETES BY UNIQUE KEY
3 #
4 connection default;
5 CREATE TABLE `t`(
6 `id` INT,
7 `a` INT DEFAULT NULL,
8 PRIMARY KEY(`id`),
9 UNIQUE KEY `u`(`a`)
10 ) ENGINE=InnoDB;
11 INSERT INTO t (`id`,`a`) VALUES
12 (1,1),
13 (2,9999),
14 (3,10000);
15 connect deleter,localhost,root,,;
16 connect holder,localhost,root,,;
17 connect waiter,localhost,root,,;
18 connection deleter;
19 SET DEBUG_SYNC =
20 'lock_sec_rec_read_check_and_lock_has_locked
21 SIGNAL deleter_has_locked
22 WAIT_FOR waiter_has_locked';
23 DELETE FROM t WHERE a = 9999;
24 connection holder;
25 SET DEBUG_SYNC=
26 'now WAIT_FOR deleter_has_locked';
27 SET DEBUG_SYNC=
28 'lock_sec_rec_read_check_and_lock_has_locked SIGNAL holder_has_locked';
29 DELETE FROM t WHERE a = 9999;
30 connection waiter;
31 SET DEBUG_SYNC=
32 'now WAIT_FOR holder_has_locked';
33 SET DEBUG_SYNC=
34 'lock_sec_rec_read_check_and_lock_has_locked SIGNAL waiter_has_locked';
35 DELETE FROM t WHERE a = 9999;
36 connection deleter;
37 connection holder;
38 connection waiter;
39 connection default;
40 disconnect deleter;
41 disconnect holder;
42 disconnect waiter;
43 DROP TABLE `t`;
44 SET DEBUG_SYNC='reset';
45 CREATE TABLE `t`(
46 `id` INT NOT NULL PRIMARY KEY
47 ) ENGINE=InnoDB;
48 INSERT INTO t (`id`) VALUES (1), (2);
49 connect holder,localhost,root,,;
50 connect waiter,localhost,root,,;
51 connection holder;
52 BEGIN;
53 SELECT id FROM t WHERE id=1 FOR UPDATE;
54 id
55 1
56 SELECT id FROM t WHERE id=2 FOR UPDATE;
57 id
58 2
59 connection waiter;
60 SET DEBUG_SYNC=
61 'lock_wait_before_suspend SIGNAL waiter_will_wait';
62 SELECT id FROM t WHERE id = 1 FOR UPDATE;
63 connection holder;
64 SET DEBUG_SYNC=
65 'now WAIT_FOR waiter_will_wait';
66 SELECT * FROM t FOR UPDATE;
67 id
68 1
69 2
70 COMMIT;
71 connection waiter;
72 id
73 1
74 connection default;
75 disconnect holder;
76 disconnect waiter;
77 DROP TABLE `t`;
78 SET DEBUG_SYNC='reset';