WSREP: cluster conflict due to certification failure for threads:

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hi All,

We are using an online application built on Liferay framework with Ubunt mysql as the database. We use multi-thread calls for the application and it used to work fine with stand alone server(dev) and 2 node cluster for UAT and Prod. We have upgraded the db version to Percona now and we are struggling with multiple issue such as pxc_strict_mode set as Enforcing causing deadlocks and mandatory to add primary key in all the tables. We have addressed these two issues, however we are facing the WSREP: cluster conflict due to certification failure for threads. We are going crazy on how to get this resolved.

Kindly request any of the experts to help us in this regard.

Thanks
Paramesh

2

Hello,

First you need some more info about what those cluster conflicts are and what queries are causing them. You can enable extra log information by following this link:

[url]http://www.fromdual.com/logging-galera-cluster-conflicts[/url]

Then you will get an output similar to what you see in InnoDB with deadlocks. There you can see what transactions are in conflict and investigate why. Maybe you are updating the same row on different nodes.