Debian Codegraph @

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

raw
1 CREATE TABLE t (a int PRIMARY KEY, b int) engine = InnoDB STATS_PERSISTENT=0;
2 CREATE TABLE t2 (a int PRIMARY KEY) engine = InnoDB STATS_PERSISTENT=0;
3 INSERT INTO t VALUES (10, 10), (20, 20), (30, 30);
4 INSERT INTO t2 VALUES (10), (20), (30);
5 BEGIN;
6 UPDATE t2 SET a = a + 100;
7 SELECT * FROM t WHERE a = 20 FOR UPDATE;
8 a b
9 20 20
10 connect con_2,localhost,root,,;
11 SET innodb_snapshot_isolation=OFF;
12 SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
13 BEGIN;
14 SET DEBUG_SYNC = 'lock_trx_handle_wait_before_unlocked_wait_lock_check SIGNAL upd_locked WAIT_FOR upd_cont';
15 UPDATE t SET b = 100;
16 connection default;
17 SET DEBUG_SYNC="now WAIT_FOR upd_locked";
18 SET DEBUG_SYNC="lock_wait_before_suspend SIGNAL upd_cont";
19 SELECT * FROM t WHERE a = 10 FOR UPDATE;
20 connection con_2;
21 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
22 disconnect con_2;
23 connection default;
24 a b
25 10 10
26 SET DEBUG_SYNC = 'RESET';
27 DROP TABLE t;
28 DROP TABLE t2;