My Oracle Support Banner

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 later
Information in this document applies to any platform.
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.


The replica thread is found in state 'Waiting for table metadata lock'.



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
 Purpose of Metadata locks
 A long-running query on replica server can cause waits on metadata locks
 Analysis of the result of the two queries on the replica server:


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.