[MDEV-21948] Data Inconsistency across MariaDB Galera DR Nodes Created: 2020-03-16  Updated: 2020-03-16

Status: Open
Project: MariaDB Server
Component/s: Configuration
Affects Version/s: 10.2.25
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Tarun Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

We are having MariaDB Galera DR 3 Node Replication environment , where I am observing Data Inconsistency across Nodes.

I have checked wsrep_local_state_comment for Galera configuration is in Synced state and all three incoming address of MariaDB are able to listen connections.

When I executed across all 3 MariaDB DR nodes , I found table row count different on all nodes

select TABLE_SCHEMA,TABLE_NAME,TABLE_ROWS from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA='ABC';



 Comments   
Comment by Tarun [ 2020-03-16 ]

Kindly suggest some areas where I can make necessary checks to see why data is getting dropped across Nodes or there is data inconsistency

Do we have need to apply Bug fixing patch to resolve this issue ?

Kindly suggest

Generated at Thu Feb 08 09:11:03 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.