MySQL Forums
Forum List  »  Replication

Replication replay errors?
Posted by: Jason K
Date: September 29, 2023 01:47PM

I have some weirdness I am struggling with.

I have one slave database (8.0.32) replicating multiple remotes (different sites) databases.

I have a specific remote master database (8.0.34) where the slave has stopped and thrown errors twice in the last week.

However, these errors are really weird. They include 'duplicate entries' for tables with auto_increment ids. Entries that where NEVER in the slave database to begin with.

Its almost as if the slave database added a bunch of entries and then started to replay the logs trying to re-enter those rows?

If I delete those rows on the slave database then I can restart the slave.


ps. Three times :-(

Options: ReplyQuote

Written By
Replication replay errors?
September 29, 2023 01:47PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.