MySQL Forums
Forum List  »  General

Waiting for table metadata lock
Posted by: Andrew Kirkby
Date: December 22, 2022 04:36PM

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.

Options: ReplyQuote


Subject
Written By
Posted
Waiting for table metadata lock
December 22, 2022 04:36PM


Sorry, you can't reply to this topic. It has been closed.

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.