Debian Codegraph @

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

raw
1 #
2 # Bug #21278148 DEADLOCKS MISSED BY INFORMATION_SCHEMA.INNODB_METRICS
3 # LOCK_DEADLOCKS COUNTER
4 #
5 CREATE TABLE t(a INT PRIMARY KEY, b INT) ENGINE=InnoDB;
6 INSERT INTO t VALUES (2,1), (1,2);
7 # Scenario 1: the con1 will be chosen as victim
8 SELECT `count` INTO @deadlocks_before_test
9 FROM INFORMATION_SCHEMA.INNODB_METRICS
10 WHERE NAME="lock_deadlocks";
11 BEGIN;
12 SELECT b FROM t WHERE a=1 FOR UPDATE;
13 b
14 2
15 BEGIN;
16 INSERT INTO t VALUES (3,3), (4,4), (5,5);
17 SELECT b FROM t WHERE a=2 FOR UPDATE;
18 b
19 1
20 SET DEBUG_SYNC='lock_wait_will_wait SIGNAL con1_will_wait';
21 SELECT b FROM t WHERE a=2 FOR UPDATE;;
22 SET DEBUG_SYNC='now WAIT_FOR con1_will_wait';
23 SELECT b FROM t WHERE a=1 FOR UPDATE;
24 b
25 2
26 ROLLBACK;
27 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
28 SELECT `count` - @deadlocks_before_test AS deadlocks_during_test
29 FROM INFORMATION_SCHEMA.INNODB_METRICS
30 WHERE NAME="lock_deadlocks";
31 deadlocks_during_test
32 1
33 # Scenario 2: the con2 will be chosen as victim
34 SELECT `count` INTO @deadlocks_before_test
35 FROM INFORMATION_SCHEMA.INNODB_METRICS
36 WHERE NAME="lock_deadlocks";
37 BEGIN;
38 SELECT b FROM t WHERE a=1 FOR UPDATE;
39 b
40 2
41 BEGIN;
42 SELECT b FROM t WHERE a=2 FOR UPDATE;
43 b
44 1
45 SET DEBUG_SYNC='lock_wait_will_wait SIGNAL con1_will_wait';
46 SELECT b FROM t WHERE a=2 FOR UPDATE;;
47 SET DEBUG_SYNC='now WAIT_FOR con1_will_wait';
48 SELECT b FROM t WHERE a=1 FOR UPDATE;
49 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
50 b
51 1
52 ROLLBACK;
53 SELECT `count` - @deadlocks_before_test AS deadlocks_during_test
54 FROM INFORMATION_SCHEMA.INNODB_METRICS
55 WHERE NAME="lock_deadlocks";
56 deadlocks_during_test
57 1
58 DROP TABLE t;