Waiting for table metadata lock
We are using MySQL community version engine 8.0.31
The database has been running for over two years without issues.
We have an issue with a table in that whenever we try to update the table, add or delete a column, any DDL, we get a waiting for table metadata lock, and this causes a lot of other processes to stop and wait.
We have managed to drop the table and recreate it a number of times with no resolution.
It is hosted in AWS RDS, and we and AWS have checked the database and it is okay. It is only a problem with this table, a table which has been working for over two years and only has a few rows.
I'd be grateful if anyone has any ideas.
Subject
Written By
Posted
Waiting for table metadata lock
December 22, 2022 04:36PM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.