3656
MySQLERRORCommonReplicationHIGH confidence
Replica has exhausted all retries for the failed transaction
Production Risk
Critical — Replication is stopped; replica is diverged from primary.
How to reproduce
trigger — this will error
trigger — this will error
-- Transaction repeatedly deadlocks on replica
expected output
ERROR 3656 (HY000): Replica has exhausted all retry attempts; replication stopped.
Fix
Investigate and skip the failing transaction
Investigate and skip the failing transaction
SHOW REPLICA STATUS\G -- Note Executed_Gtid_Set, then: SET GTID_NEXT='source_uuid:N'; BEGIN; COMMIT; SET GTID_NEXT=AUTOMATIC;
Why this works
Manually marks the failing GTID as executed to allow replication to advance.
What not to do
✕
Version notes
Sources
Official documentation ↗
MySQL 8.0 — 3656 ER_REPLICA_NO_MORE_RETRIES
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev