Inconsistency in Tables - Galera Cluster

38 views
Skip to first unread message

Ramiz

unread,
Mar 15, 2017, 12:00:57 AM3/15/17
to codership
Hi ,

MariaDB cluster Version : mysql  Ver 15.1 Distrib 10.0.24-MariaDB,

I have a two node + arbitrator cluster which is live and replicating data across nodes.

Unfortunately we found some inconsistency in some of the tables in Databases.

For instance:

Node1:

MariaDB [(none)]> select count(*) from example_db.reports;
+----------+
| count(*) |
+----------+
|      299 |
+----------+
1 row in set (0.00 sec)

Node2:

MariaDB [(none)]> select count(*) from example_db.reports;
+----------+
| count(*) |
+----------+
|      285 |
+----------+
1 row in set (0.00 sec)

Note: Not find any noticeable errors in mysql error log

What could be the reasons for these kind of inconsistency ?
Is that a bug or a known issues ?


Thank you.



Reply all
Reply to author
Forward
0 new messages