|
Sometimes (once a week), a node of our Galera Cluster ( 3 nodes) reaches an inconsistent state (WSREP_LOCAL_STATE = 5)
The cluster continues to work on the 2 others nodes.
In the log, I noticed these messages each time the problem occurs:
2020-09-05 0:06:56 240929 [Warning] WSREP: TO isolation failed for: 1, schema: information_schema, sql: FLUSH STATUS. Check wsrep connection state and retry the query.
|
2020-09-05 0:16:57 240929 [Warning] WSREP: TO isolation failed for: 1, schema: information_schema, sql: FLUSH STATUS. Check wsrep connection state and retry the query.
|
2020-09-05 0:26:57 240929 [Warning] WSREP: TO isolation failed for: 1, schema: information_schema, sql: FLUSH STATUS. Check wsrep connection state and retry the query.
|
2020-09-05 0:36:57 240929 [Warning] WSREP: TO isolation failed for: 1, schema: information_schema, sql: FLUSH STATUS. Check wsrep connection state and retry the query.
|
.....
|
|
node1.err