create table t1 (id int key, c1 int); insert into t1 values (1, 10); SET DEBUG_SYNC='RESET'; SET DEBUG_SYNC= 'alter_opened_table WAIT_FOR continue1'; SET DEBUG_SYNC= 'alter_table_copy_after_lock_upgrade WAIT_FOR continue2'; SET DEBUG_SYNC= 'alter_table_before_main_binlog WAIT_FOR continue3'; # Sending: alter table t1 change column c1 c1 bigint; SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, LOCK_TYPE, LOCK_DURATION, LOCK_STATUS FROM performance_schema.metadata_locks WHERE OBJECT_TYPE = 'TABLE' and OBJECT_NAME = 't1'; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS TABLE test t1 SHARED_UPGRADABLE TRANSACTION GRANTED SET DEBUG_SYNC= 'now SIGNAL continue1'; SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, LOCK_TYPE, LOCK_DURATION, LOCK_STATUS FROM performance_schema.metadata_locks WHERE OBJECT_TYPE = 'TABLE' and OBJECT_NAME = 't1'; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS TABLE test t1 SHARED_NO_WRITE TRANSACTION GRANTED SET DEBUG_SYNC= 'now SIGNAL continue2'; SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, LOCK_TYPE, LOCK_DURATION, LOCK_STATUS FROM performance_schema.metadata_locks WHERE OBJECT_TYPE = 'TABLE' and OBJECT_NAME = 't1'; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS TABLE test t1 EXCLUSIVE TRANSACTION GRANTED SET DEBUG_SYNC= 'now SIGNAL continue3'; # Reaping ALTER TABLE ... SET DEBUG_SYNC= 'RESET'; drop table t1;