Debian Codegraph @

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

raw
1 connect cancel_purge,localhost,root,,;
2 START TRANSACTION WITH CONSISTENT SNAPSHOT;
3 connection default;
4 CREATE TABLE t (a int PRIMARY KEY, b int) engine = InnoDB;
5 CREATE TABLE t2 (a int PRIMARY KEY) engine = InnoDB;
6 INSERT INTO t VALUES (10, 10), (20, 20), (30, 30);
7 INSERT INTO t2 VALUES (10), (20), (30);
8 BEGIN;
9 SELECT * FROM t WHERE a = 20 FOR UPDATE;
10 a b
11 20 20
12 connect con_2,localhost,root,,;
13 SET innodb_snapshot_isolation=OFF;
14 SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
15 BEGIN;
16 SET DEBUG_SYNC = 'lock_trx_handle_wait_enter SIGNAL upd_locked WAIT_FOR upd_cont EXECUTE 2';
17 UPDATE t SET b = 100;
18 connect con_3,localhost,root,,;
19 BEGIN;
20 UPDATE t2 SET a = a + 100;
21 SELECT * FROM t WHERE a = 30 FOR UPDATE;
22 a b
23 30 30
24 SET DEBUG_SYNC='now WAIT_FOR upd_locked';
25 SET DEBUG_SYNC = 'lock_wait_start SIGNAL sel_locked';
26 SELECT * FROM t WHERE a = 20 FOR UPDATE;
27 connection default;
28 SET DEBUG_SYNC='now WAIT_FOR sel_locked';
29 ROLLBACK;
30 SET DEBUG_SYNC='now SIGNAL upd_cont';
31 SET DEBUG_SYNC="now WAIT_FOR upd_locked";
32 SET SESSION innodb_lock_wait_timeout=1;
33 SELECT * FROM t WHERE a = 10 FOR UPDATE;
34 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
35 SET DEBUG_SYNC="now SIGNAL upd_cont";
36 connection con_3;
37 a b
38 20 20
39 connection con_2;
40 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
41 disconnect con_3;
42 disconnect con_2;
43 connection default;
44 SET DEBUG_SYNC = 'RESET';
45 DROP TABLE t;
46 DROP TABLE t2;
47 disconnect cancel_purge;