Slave parallel workers stuck on "Waiting For Table Metadata Lock" when having MTS enabled
(Doc ID 2623029.1)
Last updated on MARCH 19, 2020
Applies to:MySQL Server - Version 8.0 and later
Information in this document applies to any platform.
On Master-Slave replication environment using MTS (slave_parallel_workers > 0), there is a deadlock between slave threads, when it has a replicated transaction that needs to acquire a metadata lock (MDL) like "OPTIMIZE TABLE"
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