# Getting a lot of Wsrep\_rollback\_local logs and failed transactions **URL:** \ **Category:** Percona XtraDB Cluster 8.x\ **Created:** [March 27, 2026, 11:35am UTC](https://forums.percona.com/t/getting-a-lot-of-wsrep-rollback-local-logs-and-failed-transactions/40415 "2026-03-27T11:35:05Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![karl123](https://avatars.discourse-cdn.com/v4/letter/k/8491ac/32.png) [@karl123](https://forums.percona.com/u/karl123)\ **Post date:** [March 27, 2026, 11:35am UTC](https://forums.percona.com/t/getting-a-lot-of-wsrep-rollback-local-logs-and-failed-transactions/40415/1 "2026-03-27T11:35:05Z")
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 ---
**Author:** ![yunus.uyanik](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/yunus.uyanik/32/19250_2.png) [@yunus.uyanik](https://forums.percona.com/u/yunus.uyanik)\ **Post date:** [March 30, 2026, 8:57am UTC](https://forums.percona.com/t/getting-a-lot-of-wsrep-rollback-local-logs-and-failed-transactions/40415/2 "2026-03-30T08:57:18Z")
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](https://docs.percona.com/percona-xtradb-cluster/8.4/wsrep-system-index.html?h=wsrep_debug#wsrep_debug) ---
**Author:** ![karl123](https://avatars.discourse-cdn.com/v4/letter/k/8491ac/32.png) [@karl123](https://forums.percona.com/u/karl123)\ **Post date:** [April 30, 2026, 1:58pm UTC](https://forums.percona.com/t/getting-a-lot-of-wsrep-rollback-local-logs-and-failed-transactions/40415/3 "2026-04-30T13:58:33Z")
Hi Yunus, only just saw the reply. Apologies for the delay… Writes are going to all three nodes. With a network load balancer in front of it… Was thinking about setting up ProxySQL. Would something like this help? IS writing to all three nodes making the problem worse? ---
**Author:** ![Jyoti\_Rajai1](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jyoti_rajai1/32/22960_2.png) [@Jyoti\_Rajai1](https://forums.percona.com/u/Jyoti_Rajai1)\ **Post date:** [May 1, 2026, 5:33am UTC](https://forums.percona.com/t/getting-a-lot-of-wsrep-rollback-local-logs-and-failed-transactions/40415/4 "2026-05-01T05:33:40Z")
Hello Karl, As yunus said, “Those are conflicts being resolved through brute-force (BF) aborts. Does your write traffic goes more than one node in the cluster?” Sending writes to all nodes will lead to deadlocks and rollbacks. You need to enable debug logging to identify the issue. [Index of wsrep system variables - Percona XtraDB Cluster](https://docs.percona.com/percona-xtradb-cluster/8.4/wsrep-system-index.html?h=wsrep_debug#wsrep_debug) Yeah, but with the help of ProxySQL, I’d recommend routing all writes to a single node ( Writer hostgroup), and using the remaining nodes for reads/failover. ---
**Author:** ![Vin\_Perothas](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vin_perothas/32/21062_2.png) [@Vin\_Perothas](https://forums.percona.com/u/Vin_Perothas)\ **Post date:** [May 1, 2026, 7:57am UTC](https://forums.percona.com/t/getting-a-lot-of-wsrep-rollback-local-logs-and-failed-transactions/40415/5 "2026-05-01T07:57:41Z")
Writing to all three nodes simultaneously is the primary cause of `Wsrep_rollback_local` entries, and ProxySQL is the industry-standard way to fix this. When you write to all nodes via a Network Load Balancer (NLB), you are essentially forcing the cluster to gamble on every transaction. As your traffic or row contention increases, the “winning” node forces the “losing” node to roll back the transaction to maintain data integrity across the cluster. This is exactly what you are seeing in your logs. ---
**Author:** ![karl123](https://avatars.discourse-cdn.com/v4/letter/k/8491ac/32.png) [@karl123](https://forums.percona.com/u/karl123)\ **Post date:** [May 1, 2026, 10:01am UTC](https://forums.percona.com/t/getting-a-lot-of-wsrep-rollback-local-logs-and-failed-transactions/40415/6 "2026-05-01T10:01:31Z")
Thanks for the reply. I will give ProxySQL a go and report back in a few days