Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.11.11
-
None
-
None
-
None
Description
Using mydumper to backup the mysql system table , restore on a replica, then this can deadlock on metadata lock with our workload
Our MariaDB orchestrator and other in the cloud i get inspiration from.
We do regular create table if no exist slow_log_<datetime> insert from slow_log to slow_log_<datetime> ;truncate table slow_log when log_output=TABLE to avoid that table growing for ever
We can code a workaround in our case but this may be nice to fixe as metadata deadlock should not happen by design ?
Using mysqldump --system=ALL does not deadlock so this is probably caused by the DROP TABLE from the myloader
Attachments
Issue Links
- duplicates
-
MDEV-36137 parallel replication deadlock between DML in one domain and DDL in another
-
- Open
-