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 CREATE TABLE `t`(
5 `id` INT,
6 `a` INT DEFAULT NULL,
7 PRIMARY KEY(`id`),
8 UNIQUE KEY `u`(`a`)
9 ) ENGINE=InnoDB;
10 INSERT INTO t (`id`,`a`) VALUES
11 (1,1),
12 (2,9999),
13 (3,10000);
14 SET DEBUG_SYNC =
15 'lock_sec_rec_read_check_and_lock_has_locked
16 SIGNAL deleter_has_locked
17 WAIT_FOR waiter_has_locked';
18 DELETE FROM t WHERE a = 9999;
19 SET DEBUG_SYNC=
20 'now WAIT_FOR deleter_has_locked';
21 SET DEBUG_SYNC=
22 'lock_sec_rec_read_check_and_lock_has_locked SIGNAL holder_has_locked';
23 DELETE FROM t WHERE a = 9999;
24 SET DEBUG_SYNC=
25 'now WAIT_FOR holder_has_locked';
26 SET DEBUG_SYNC=
27 'lock_sec_rec_read_check_and_lock_has_locked SIGNAL waiter_has_locked';
28 DELETE FROM t WHERE a = 9999;
29 DROP TABLE `t`;
30 CREATE TABLE `t`(
31 `id` INT NOT NULL PRIMARY KEY
32 ) ENGINE=InnoDB;
33 INSERT INTO t (`id`) VALUES (1), (2);
34 BEGIN;
35 SELECT id FROM t WHERE id=1 FOR UPDATE;
36 id
37 1
38 SELECT id FROM t WHERE id=2 FOR UPDATE;
39 id
40 2
41 SET DEBUG_SYNC=
42 'lock_wait_will_wait SIGNAL waiter_will_wait';
43 SELECT id FROM t WHERE id = 1 FOR UPDATE;
44 SET DEBUG_SYNC=
45 'now WAIT_FOR waiter_will_wait';
46 SELECT * FROM t FOR UPDATE;
47 id
48 1
49 2
50 COMMIT;
51 id
52 1
53 DROP TABLE `t`;