ALTER TABLE ADD INDEX Hangs On "Waiting For Table Metadata Lock"
(Doc ID 2757435.1)
Last updated on MARCH 24, 2021
Applies to:
MySQL Cluster - Version 7.6 and laterInformation in this document applies to any platform.
Symptoms
ALTER TABLE ADD INDEX command hangs on "Waiting for table metadata lock" state. Check bellow:
mysql> show full processlist;
| Id | ... |State |
| 1 | ... |Waiting for table metadata lock | ALTER TABLE t1 ADD INDEX index_id (id)
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |