Debian Codegraph @

mysql-test/suite/perfschema/r/sorting_data_locks.result

raw
1 # Bug #28176910
2 # PERFORMANCE_SCHEMA.DATA_LOCKS.OBJECT_INSTANCE_BEGIN
3 # CHANGES DEPENDING ON ORDER
4 CREATE TABLE t1(
5 id INT PRIMARY KEY
6 ) Engine=InnoDB;
7 INSERT INTO t1 VALUES (1);
8 BEGIN;
9 SELECT * FROM t1 WHERE id=1 FOR SHARE;
10 id
11 1
12 SELECT * FROM t1 WHERE id=1 FOR UPDATE;
13 id
14 1
15 SELECT COUNT(DISTINCT engine_lock_id) FROM performance_schema.data_locks;
16 COUNT(DISTINCT engine_lock_id)
17 4
18 SELECT
19 lock_type,
20 lock_mode,
21 lock_status,
22 lock_data
23 FROM performance_schema.data_locks
24 ORDER BY 1,2,3,4;
25 lock_type lock_mode lock_status lock_data
26 RECORD S,REC_NOT_GAP GRANTED 1
27 RECORD X,REC_NOT_GAP GRANTED 1
28 TABLE IS GRANTED NULL
29 TABLE IX GRANTED NULL
30 BEGIN;
31 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL C1_will_wait';
32 SELECT * FROM t1 FOR UPDATE;;
33 SET DEBUG_SYNC = 'now WAIT_FOR C1_will_wait';
34 SELECT
35 r.object_name,r.lock_type,r.lock_mode,r.lock_status,r.lock_data ,
36 b.object_name,b.lock_type,b.lock_mode,b.lock_status,b.lock_data
37 FROM performance_schema.data_lock_waits
38 JOIN performance_schema.data_locks r
39 ON(r.engine_lock_id = requesting_engine_lock_id)
40 JOIN performance_schema.data_locks b
41 ON(b.engine_lock_id = blocking_engine_lock_id)
42 ORDER BY b.lock_mode;
43 object_name lock_type lock_mode lock_status lock_data object_name lock_type lock_mode lock_status lock_data
44 t1 RECORD X WAITING 1 t1 RECORD S,REC_NOT_GAP GRANTED 1
45 t1 RECORD X WAITING 1 t1 RECORD X,REC_NOT_GAP GRANTED 1
46 SELECT r.object_name,r.lock_type,r.lock_mode,r.lock_status,r.lock_data
47 FROM information_schema.innodb_trx
48 JOIN performance_schema.data_locks r
49 ON(r.engine_lock_id = trx_requested_lock_id);
50 object_name lock_type lock_mode lock_status lock_data
51 t1 RECORD X WAITING 1
52 ROLLBACK;
53 id
54 1
55 ROLLBACK;
56 DROP TABLE t1;