Getting a lot of Wsrep_rollback_local logs and failed transactions

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

Hi, I have finally migrated my DB from 5.7 to 8.4. Everything nominally works… But I am frequently getting Wsrep_rollback_local log entries (1 per min) on each of my 3 nodes.

I did not have this problem on 5.7… It is causing problems in my application and DB transactions are failing… frequently as a result…

Any help much appreciated

2

Hi @karl123

Those are conflicts being resolved through brute-force (BF) aborts. Does your write traffic goes more than one node in the cluster?

Also, enabling debug log would be helpful for this kind of case to see more details: Index of wsrep system variables - Percona XtraDB Cluster