How To Recover Group Replication/InnoDB Cluster Data Inconsistencies Which All Secondaries Are Out-Of-Sync From Primary In Single-Primary Mode (Doc ID 2774365.1)

Last updated on JULY 18, 2021

Applies to:

Goal

In certain cases, it is possible that only the source, the primary has a correct data, and the secondary nodes have corrupted data. By design, secondaries should have identical data to the primary node with a little delay because of its asynchronous characteristics; all secondaries catch up with the primary continuously through replication. However, inconsistency in their data can happen due to various reasons:

• Operation mistakes
• Bugs like <Bug 31869146>, which the GRANT statement causes different results between the source/primary and the replica/secondary.
• Physical data corruption.

This document describes how to fix the situation where all secondary nodes have inconsistent data.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.