| 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; |