Debian Codegraph @

mysql-test/suite/innodb/t/high_prio_trx_9.test

raw
1 # Scenario:
2 # con1 acquires a shared lock on row B
3 # con2 acquires a shared lock on row A
4 # con2 requests an exclusive lock on row B and has to wait for con1
5 # con3 requests an exclusive lock on row A, and would have to wait for con2,
6 # but con3 is a HP trx and does not want to wait, so it
7 # decides to kill con2
8 # con3 commits
9 # con2 observes a deadlock
10 # con1 commits
11
12 --source include/have_debug_sync.inc
13 --source include/count_sessions.inc
14
15 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
16 INSERT INTO t1 VALUES (0);
17 CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
18 INSERT INTO t2 VALUES (0);
19
20 --connect(con1,localhost,root,,test)
21 --connect(con2,localhost,root,,test)
22 --connect(con3,localhost,root,,test)
23
24 --connection con1
25 --echo # On connection 1
26 BEGIN;
27 SELECT * FROM t2 WHERE c1=0 FOR SHARE;
28
29 --connection con2
30 --echo # On connection 2
31 BEGIN;
32 SELECT * FROM t1 WHERE c1=0 FOR SHARE;
33 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL con2_will_wait';
34 --send SELECT * FROM t2 WHERE c1=0 FOR UPDATE
35
36 --connection con3
37 --echo # On connection 3
38 SET DEBUG_SYNC = 'now WAIT_FOR con2_will_wait';
39 --source include/start_transaction_high_prio.inc
40 SELECT * FROM t1 WHERE c1=0 FOR UPDATE;
41 COMMIT;
42
43 --connection con2
44 --echo # On connection 2
45 --error ER_LOCK_DEADLOCK
46 --reap
47 COMMIT;
48
49 --connection con1
50 --echo # On connection 1
51 COMMIT;
52
53 --connection default
54 --disconnect con1
55 --disconnect con2
56 --disconnect con3
57
58 DROP TABLE t1;
59 DROP TABLE t2;
60
61 --source include/wait_until_count_sessions.inc