Debian Codegraph @

mysql-test/suite/innodb/r/insert-before-delete.result

raw
1 connect pause_purge,localhost,root;
2 START TRANSACTION WITH CONSISTENT SNAPSHOT;
3 connection default;
4 CREATE TABLE t (pk int PRIMARY KEY, sk INT UNIQUE) ENGINE=InnoDB;
5 INSERT INTO t VALUES (10, 100);
6 connect con1,localhost,root;
7 BEGIN;
8 SELECT * FROM t WHERE sk = 100 FOR UPDATE;
9 pk sk
10 10 100
11 connect con2,localhost,root;
12 SET DEBUG_SYNC="lock_wait_start SIGNAL insert_wait_started";
13 INSERT INTO t VALUES (5, 100) # trx 1;
14 connect con3,localhost,root;
15 SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
16 SET DEBUG_SYNC="now WAIT_FOR insert_wait_started";
17 SET DEBUG_SYNC="lock_wait_start SIGNAL delete_started_waiting";
18 DELETE FROM t WHERE sk = 100 # trx 2;
19 connection con1;
20 SET DEBUG_SYNC="now WAIT_FOR delete_started_waiting";
21 DELETE FROM t WHERE sk=100;
22 COMMIT;
23 disconnect con1;
24 connection con2;
25 disconnect con2;
26 connection con3;
27 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
28 disconnect con3;
29 connection default;
30 SELECT * FROM t;
31 pk sk
32 5 100
33 disconnect pause_purge;
34 SET DEBUG_SYNC="RESET";
35 DROP TABLE t;