MySQL从库报错Clarification about error: "Errno: 1032 (Doc ID 2790142.1)

jiawang

db:mysql8.0.30
参考文档：
In this Document
Symptoms
Changes
Cause
Solution
        Workaround
        Solution
References


APPLIES TO:
MySQL Server - Version 5.7 and later
Information in this document applies to any platform.
SYMPTOMS
Disclaimer: Starting from v8.0, some terms have been deprecated. Older releases will only use the deprecated terminology, and new releases will only use new terminology. Please see https://dev.mysql.com/doc/mysqld-version-reference/en/ for a complete list of those changes, and in which minor versions it happened.
Seeing the following error:


Last_Errno: 1032
Last_Error: Coordinator stopped because there were error(s) in the worker(s). The most recent failure being: Worker 2 failed executing transaction '' at replica , end_log_pos . See error log and/or performance_schema.replication_applier_status_by_worker table for more details about this failure or others, if any.


CHANGES



CAUSE
High OLTP load along with large batch jobs can trigger this issue consistently.


The error is caused by


Bug 26376586: REPEATED MULTI-THREADED REPLICA REPLICATION FAILURES
SOLUTION
Workaround
Disable replica-parallel-workers.


Solution
Bug 26376586 wasn't reproduced with 5.7.41 nor 8.0.33, so upgrade to those versions or higher.


REFERENCES
NOTE:2425284.1 - When Cleanly Stopping Multi-Threaded Replica: "The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state. ... Error_code: 1756"
https://dev.mysql.com/doc/refman/en/replication-options-replica.html#sysvar_replica_parallel_workers
BUG:26376586 - REPEATED MULTI-THREADED REPLICA REPLICATION FAILURES