Debian Codegraph @

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

raw
1 --echo #
2 --echo # Bug #21278148 DEADLOCKS MISSED BY INFORMATION_SCHEMA.INNODB_METRICS
3 --echo # LOCK_DEADLOCKS COUNTER
4 --echo #
5
6 --source include/have_debug_sync.inc
7
8 CREATE TABLE t(a INT PRIMARY KEY, b INT) ENGINE=InnoDB;
9 INSERT INTO t VALUES (2,1), (1,2);
10
11 --echo # Scenario 1: the con1 will be chosen as victim
12
13 SELECT `count` INTO @deadlocks_before_test
14 FROM INFORMATION_SCHEMA.INNODB_METRICS
15 WHERE NAME="lock_deadlocks";
16
17 --connect (con1,localhost,root,,)
18 BEGIN;
19 SELECT b FROM t WHERE a=1 FOR UPDATE;
20
21 --connect (con2,localhost,root,,)
22 BEGIN;
23 # Make con2 "heavy" by creating new rows
24 INSERT INTO t VALUES (3,3), (4,4), (5,5);
25 SELECT b FROM t WHERE a=2 FOR UPDATE;
26
27 --connection con1
28 SET DEBUG_SYNC='lock_wait_will_wait SIGNAL con1_will_wait';
29 --send SELECT b FROM t WHERE a=2 FOR UPDATE;
30
31 --connection con2
32 SET DEBUG_SYNC='now WAIT_FOR con1_will_wait';
33 SELECT b FROM t WHERE a=1 FOR UPDATE;
34 ROLLBACK;
35
36 --connection con1
37 --error ER_LOCK_DEADLOCK
38 --reap
39
40 --connection default
41 --disconnect con1
42 --disconnect con2
43
44 SELECT `count` - @deadlocks_before_test AS deadlocks_during_test
45 FROM INFORMATION_SCHEMA.INNODB_METRICS
46 WHERE NAME="lock_deadlocks";
47
48 --echo # Scenario 2: the con2 will be chosen as victim
49
50 SELECT `count` INTO @deadlocks_before_test
51 FROM INFORMATION_SCHEMA.INNODB_METRICS
52 WHERE NAME="lock_deadlocks";
53
54 --connect (con1,localhost,root,,)
55 BEGIN;
56 SELECT b FROM t WHERE a=1 FOR UPDATE;
57
58 --connect (con2,localhost,root,,)
59 BEGIN;
60 SELECT b FROM t WHERE a=2 FOR UPDATE;
61
62 --connection con1
63 SET DEBUG_SYNC='lock_wait_will_wait SIGNAL con1_will_wait';
64 --send SELECT b FROM t WHERE a=2 FOR UPDATE;
65
66 --connection con2
67 SET DEBUG_SYNC='now WAIT_FOR con1_will_wait';
68 --error ER_LOCK_DEADLOCK
69 SELECT b FROM t WHERE a=1 FOR UPDATE;
70
71 --connection con1
72 --reap
73 ROLLBACK;
74
75 --connection default
76 --disconnect con1
77 --disconnect con2
78
79 SELECT `count` - @deadlocks_before_test AS deadlocks_during_test
80 FROM INFORMATION_SCHEMA.INNODB_METRICS
81 WHERE NAME="lock_deadlocks";
82
83 DROP TABLE t;