[MDEV-33204] [Warning] WSREP: BF applier failed to open_and_lock_tables: 1317, fatal: 0 wsrep = (exec_mode: 2 conflict_state: 0 seqno: NNNN) Created: 2024-01-09  Updated: 2024-01-09

Status: Open
Project: MariaDB Server
Component/s: Galera, Server
Affects Version/s: 10.6.14
Fix Version/s: None

Type: Bug Priority: Major
Reporter: William Wong Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

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


Generated at Thu Feb 08 10:37:09 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.