Debian Codegraph @

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

raw
1 create table t1 (id int key, c1 int);
2 insert into t1 values (1, 10);
3 SET DEBUG_SYNC='RESET';
4 SET DEBUG_SYNC= 'alter_opened_table WAIT_FOR continue1';
5 SET DEBUG_SYNC= 'alter_table_copy_after_lock_upgrade WAIT_FOR continue2';
6 SET DEBUG_SYNC= 'alter_table_before_main_binlog WAIT_FOR continue3';
7 # Sending:
8 alter table t1 change column c1 c1 bigint;
9 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
10 FROM performance_schema.metadata_locks
11 WHERE OBJECT_TYPE = 'TABLE' and OBJECT_NAME = 't1';
12 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS
13 TABLE test t1 SHARED_UPGRADABLE TRANSACTION GRANTED
14 SET DEBUG_SYNC= 'now SIGNAL continue1';
15 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
16 FROM performance_schema.metadata_locks
17 WHERE OBJECT_TYPE = 'TABLE' and OBJECT_NAME = 't1';
18 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS
19 TABLE test t1 SHARED_NO_WRITE TRANSACTION GRANTED
20 SET DEBUG_SYNC= 'now SIGNAL continue2';
21 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
22 FROM performance_schema.metadata_locks
23 WHERE OBJECT_TYPE = 'TABLE' and OBJECT_NAME = 't1';
24 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS
25 TABLE test t1 EXCLUSIVE TRANSACTION GRANTED
26 SET DEBUG_SYNC= 'now SIGNAL continue3';
27 # Reaping ALTER TABLE ...
28 SET DEBUG_SYNC= 'RESET';
29 drop table t1;