Inconsistency detected: Inconsistent by consensus on

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

Hi!

I’m running Percona XtraDB Cluster with 3 nodes, and HAProxy for loadbalancer.
I received this error message during database migration:

[Galera] Member 1(pxc8p03) initiates vote on 6fe3aebd-25e3-11ec-a74f-6b710e4e3097:6151,e6d7029077e93196: Can’t create database ‘xxxxx’; database exists, Error_code: 1007;
2021-10-10T11:32:33.096402Z 0 [Note] [MY-000000] [Galera] Votes over 6fe3aebd-25e3-11ec-a74f-6b710e4e3097:6151:
e6d7029077e93196: 1/3
Waiting for more votes.
2021-10-10T11:32:33.096455Z 0 [Note] [MY-000000] [Galera] Member 2(pxc8p02) initiates vote on 6fe3aebd-25e3-11ec-a74f-6b710e4e3097:6151,afb314b952946880: Can’t create database ‘xxxxx’; database exists, Error_code: 1007;
2021-10-10T11:32:33.096481Z 0 [Note] [MY-000000] [Galera] Votes over 6fe3aebd-25e3-11ec-a74f-6b710e4e3097:6151:
afb314b952946880: 1/3
e6d7029077e93196: 1/3
Waiting for more votes.
2021-10-10T11:32:33.096505Z 0 [Note] [MY-000000] [Galera] Member 0(pxc8p01) initiates vote on 6fe3aebd-25e3-11ec-a74f-6b710e4e3097:6151,afb314b952946880: Can’t create database ‘xxxxx’; database exists, Error_code: 1007;
2021-10-10T11:32:33.096531Z 0 [Note] [MY-000000] [Galera] Votes over 6fe3aebd-25e3-11ec-a74f-6b710e4e3097:6151:
afb314b952946880: 2/3
e6d7029077e93196: 1/3
Winner: afb314b952946880

Inconsistency detected: Inconsistent by consensus on 6fe3aebd-25e3-11ec-a74f-6b710e4e3097

What could have caused the error?

1 Like
2

Hi, it seems one of your nodes already has a database you are trying to create. To be on the safe side I’d drop data on the failing node and let it do an SST to resync from scratch.

1 Like
3

Hi igroene,

Thaks for reply!

If i have only one node in primary state, and do SST , the status of this node will be a donor.
In donor state can i use this node for read/write purpose?

1 Like
4

Only if you are using xtrabackup method for SST the donor can still be used for read/write.

1 Like