Not the answer you need?
Register and ask your own question!

WSREP: cluster conflict due to certification failure for threads:

paramesh.nparamesh.n EntrantLegacy User Role Beginner
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

Comments

  • miguelangelnietomiguelangelnieto Member Inactive User Role Beginner
    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:

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

    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.