Wait event - wsrep: replicating and certifying write set(-1)

MySQL & MariaDB Percona XtraDB Cluster 8.x
,
1

Hello Everyone

We have below setup:
3 Node Percona XtraDB (Galera Libraries Installed)
Server version: 8.0.21-12.1 Percona XtraDB Cluster (GPL), Release rel12, Revision 4d973e2, WSREP version 26.4.3

We are seeing below wait event resulting on replication getting paused and max_connections and max_user_connections reaching max limit.

wsrep: replicating and certifying write set(-1)

Any advise on tuning and resolving the issue.

Regards
Srikanth

1 Like
2

Hello @Srikanth_Lingala,
You probably have a transaction held open on one of your nodes which is blocking the incoming transaction. Be sure to close all transactions as soon as the last query finishes.

1 Like