Debian Codegraph @

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

raw
1 SET GLOBAL innodb_deadlock_detect = 'OFF';
2 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
3 INSERT INTO t1 VALUES (0);
4 CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
5 INSERT INTO t2 VALUES (0);
6 CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
7 INSERT INTO t3 VALUES (0);
8 include/start_transaction_high_prio.inc
9 START TRANSACTION /* HIGH PRIORITY */;
10 DELETE FROM t1;
11 include/start_transaction_high_prio.inc
12 START TRANSACTION /* HIGH PRIORITY */;
13 DELETE FROM t2;
14 include/start_transaction_high_prio.inc
15 START TRANSACTION /* HIGH PRIORITY */;
16 DELETE FROM t3;
17 SET DEBUG_SYNC='lock_wait_will_wait SIGNAL con3_will_wait';
18 DELETE FROM t2; COMMIT;
19 SET DEBUG_SYNC='now WAIT_FOR con3_will_wait';
20 SET DEBUG_SYNC='lock_wait_will_wait SIGNAL con2_will_wait';
21 DELETE FROM t1; COMMIT;
22 SET DEBUG_SYNC='now WAIT_FOR con2_will_wait';
23 SET DEBUG_SYNC='lock_wait_will_wait SIGNAL con1_will_wait';
24 DELETE FROM t3; COMMIT;
25 SET DEBUG_SYNC='now WAIT_FOR con1_will_wait';
26 # restart
27 SELECT * FROM t1;
28 c1
29 0
30 DROP TABLE t1;
31 SELECT * FROM t2;
32 c1
33 0
34 DROP TABLE t2;
35 SELECT * FROM t3;
36 c1
37 0
38 DROP TABLE t3;