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.
Thoughts?
ps. Three times :-(
Subject
Views
Written By
Posted
Replication replay errors?
361
September 29, 2023 01:47PM
Sorry, you can't reply to this topic. It has been closed.
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.