Troubleshooting Of A Replica Thread In State 'Waiting for table metadata lock'
(Doc ID 3003242.1)
Last updated on FEBRUARY 26, 2024
Applies to:
MySQL Server - Version 8.0 and laterInformation in this document applies to any platform.
---------
Purpose
---------
This KM explains a possible sequence of events which can cause a replica thread to enter state 'Waiting for table metadata lock' and also suggests queries to troubleshoot the same with the help of an example.
Symptoms
The replica thread is found in state 'Waiting for table metadata lock'.
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 |
Cause |
Purpose of Metadata locks |
A long-running query on replica server can cause waits on metadata locks |
Solution |
Analysis of the result of the two queries on the replica server: |
REFERENCES |
References |