Detected occurrence(s) of ‘WSREP: last inactive check more than
Seeing this several times. What exactly am I looking for and where?
-
This is written out by the Galera nodes if they have trouble pinging each other:
[Warning] WSREP: last inactive check more than PT1.5S ago (PT3.03891S), skipping check
Usually its an indication of an unstable network or that the server is temporarily blocking on IO or is overloaded or swapping. You have the full entry in the MySQL error log. Take a look at them for all your Galera nodes and try to pinpoint when these warnings are occurring. You can use ClusterControl > Nodes to check:
- The host is swapping
- Any CPU/network/IO spike on that host
- Timestamp when the problem occurs
Please sign in to leave a comment.
Comments
2 comments