Debian Codegraph @

mysql-test/suite/perfschema/t/innodb_data_locks2.test

raw
1 # This test is a continuation of innodb_data_locks.test
2 # However it requires DEBUG_SYNC support and
3 # setting --innodb-autoinc-lock-mode=0 both of which are
4 # controled at the test file level, so I've moved it to
5 # separate file, not to impact the old test which do not
6 # have such specific requirements.
7
8 --source include/have_debug_sync.inc
9
10 --echo
11 --echo Bug #28176805 PERFORMANCE_SCHEMA.DATA_LOCKS.LOCK_MODE
12 --echo DOES NOT RECOGNIZE LOCK_REC_NOT_GAP
13 --echo
14
15 # This test attempts to demonstrate various modes of locking
16
17 CREATE TABLE t1 (id INT PRIMARY KEY) Engine=InnoDB;
18 INSERT INTO t1 VALUES (0),(10),(20),(30);
19 CREATE TABLE t2 (id INT PRIMARY KEY AUTO_INCREMENT, val INT) Engine=InnoDB;
20
21 --connect (C1, localhost, root,,)
22 --connect (C2, localhost, root,,)
23 --connect (C3, localhost, root,,)
24 --connect (C4, localhost, root,,)
25
26 --connection C1
27 BEGIN;
28 # table IS
29 # S
30 SELECT * FROM t1 WHERE id=10 FOR SHARE;
31 # table IX
32 # X,REC_NOT_GAP
33 INSERT INTO t1 VALUES (5);
34 # S,GAP
35 SELECT * FROM t1 WHERE id=25 FOR SHARE;
36 # X,GAP
37 SELECT * FROM t1 WHERE id=22 FOR UPDATE;
38 # S,REC_NOT_GAP
39 SELECT * FROM t1 where id>=10 and id<=20 FOR SHARE;
40 # X
41 SELECT * FROM t1 WHERE id>20 FOR UPDATE;
42
43 --connection C2
44 BEGIN;
45 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL C2_will_wait';
46 # X,GAP,INSERT_INTENTION
47 --send INSERT INTO t1 VALUES (21)
48
49 --connection C3
50 SET DEBUG_SYNC = 'now WAIT_FOR C2_will_wait';
51 BEGIN;
52 SHOW VARIABLES LIKE 'innodb_autoinc_lock_mode';
53 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL C3_will_wait';
54 # AUTO_INC
55 --send INSERT INTO t2 (val) SELECT id FROM t1 WHERE id>=0 AND id< 10;
56
57 --connection C4
58 SET DEBUG_SYNC = 'now WAIT_FOR C3_will_wait';
59 BEGIN;
60 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL C4_will_wait';
61 # X,INSERT_INTENTION
62 --send INSERT INTO t1 VALUES (35)
63
64 --connection default
65 SET DEBUG_SYNC = 'now WAIT_FOR C4_will_wait';
66
67 SELECT
68 object_name,
69 index_name,
70 lock_type,
71 lock_mode,
72 lock_status,
73 lock_data
74 FROM performance_schema.data_locks
75 ORDER BY 1,2,3,4,5,6;
76
77
78 --connection C1
79 ROLLBACK;
80 --connection C2
81 --reap
82 ROLLBACK;
83 --connection C3
84 --reap
85 ROLLBACK;
86 --connection C4
87 --reap
88 ROLLBACK;
89
90 --connection default
91 --disconnect C1
92 --disconnect C2
93 --disconnect C3
94 --disconnect C4
95 DROP TABLE t1;
96 DROP TABLE t2;