Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6.14
-
None
-
RHEL7 on VMware
Description
Our environment is 3 nodes Galera cluster - 2 DB nodes + 1 arbitrator. HAProxy redirected traffic to one 1 DB node.
On standby node, we encountered node inconsistent after getting warning message "WSREP: BF applier failed to open_and_lock_tables: 1317"
We needed to restart DB node manually and let it triggered implicitly SST to get it resolved.
Kindly advise what we can check to troubleshot this case.
2023-12-29 20:31:35 52 [Warning] WSREP: BF applier failed to open_and_lock_tables: 1317, fatal: 0 wsrep = (exec_mode: 2 conflict_state: 0 seqno: 5967252914)
|
2023-12-29 20:31:35 52 [ERROR] Slave SQL: Error executing row event: 'Query execution was interrupted', Internal MariaDB error code: 1317
|
2023-12-29 20:31:35 52 [Warning] WSREP: Event 4 Delete_rows_v1 apply failed: 1317, seqno 5967252914
|
2023-12-29 20:31:35 0 [Note] WSREP: Member 1(p2vdbs-tdffsbe-ptdb04-2-01) initiates vote on f1302072-0331-11ed-9082-aaafb2897127:5967252914,cdf63d1db21d2e93: Query execution was interrupted, Error_code: 1317;
|
2023-12-29 20:31:35 0 [Note] WSREP: Votes over f1302072-0331-11ed-9082-aaafb2897127:5967252914:
|
cdf63d1db21d2e93: 1/2
|
Waiting for more votes.
|
2023-12-29 20:31:35 0 [Note] WSREP: Member 2(p1vdbs-tdffsbe-ptdb04-1-01) responds to vote on f1302072-0331-11ed-9082-aaafb2897127:5967252914,0000000000000000: Success
|
2023-12-29 20:31:35 0 [Note] WSREP: Votes over f1302072-0331-11ed-9082-aaafb2897127:5967252914:
|
0000000000000000: 1/2
|
cdf63d1db21d2e93: 1/2
|
Winner: 0000000000000000
|
2023-12-29 20:31:35 52 [ERROR] WSREP: Inconsistency detected: Inconsistent by consensus on f1302072-0331-11ed-9082-aaafb2897127:5967252914
|
at /home/buildbot/buildbot/build/galera/src/replicator_smm.cpp:process_apply_error():1357
|
|