Debian Codegraph @

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

raw
1 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
2 INSERT INTO t1 VALUES (0);
3 CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
4 INSERT INTO t2 VALUES (0);
5 # On connection 1
6 BEGIN;
7 SELECT * FROM t2 WHERE c1=0 FOR SHARE;
8 c1
9 0
10 # On connection 2
11 BEGIN;
12 SELECT * FROM t1 WHERE c1=0 FOR SHARE;
13 c1
14 0
15 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL con2_will_wait';
16 SELECT * FROM t2 WHERE c1=0 FOR UPDATE;
17 # On connection 3
18 SET DEBUG_SYNC = 'now WAIT_FOR con2_will_wait';
19 include/start_transaction_high_prio.inc
20 START TRANSACTION /* HIGH PRIORITY */;
21 SELECT * FROM t1 WHERE c1=0 FOR UPDATE;
22 c1
23 0
24 COMMIT;
25 # On connection 2
26 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
27 COMMIT;
28 # On connection 1
29 COMMIT;
30 DROP TABLE t1;
31 DROP TABLE t2;