MariaDB Galera cluster encountered severe inconsistency issues when handling data synchronization

The MariaDB Galera cluster was experiencing severe errors and inconsistencies when processing DML operations and consistency checks. The following is a detailed analysis:
1. Record not found error
2024-10-27 6:33:04 2 [ERROR] mariadbd: Can't find record in 'test8'
2024-10-27 6:33:04 2 [Warning] WSREP: Ignoring error 'Can't find record in 'test8'' on Delete_rows_v1 event. Error_code: 1032
2. Duplicate entry error
2024-10-27 6:33:22 2 [ERROR] Slave SQL: Could not execute Update_rows_v1 event on table mytest1.test8; Duplicate entry '75.41' for key 'column3', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log FIRST, end_log_pos 204, Internal MariaDB error code: 1062
2024-10-27 6:33:22 2 [Warning] WSREP: Event 3 Update_rows_v1 apply failed: 121, seqno 39957
3. WSREP consistency voting and inconsistency detection
2024-10-27 6:33:22 0 [Note] WSREP: Member 0(node0) initiates vote on a9e687f9-9421-11ef-8f3c-322ad9279b98:39957,e813fdab298b3dec: Duplicate entry '75.41' for key 'column3', Error_code: 1062;
2024-10-27 6:33:22 0 [Note] WSREP: Votes over a9e687f9-9421-11ef-8f3c-322ad9279b98:39957:
e813fdab298b3dec: 1/4
Waiting for more votes.
2024-10-27 6:33:22 0 [Note] WSREP: Member 2(node2) responds to vote on a9e687f9-9421-11ef-8f3c-322ad9279b98:39957,0000000000000000: Success
2024-10-27 6:33:22 0 [Note] WSREP: Votes over a9e687f9-9421-11ef-8f3c-322ad9279b98:39957:
0000000000000000: 1/4
e813fdab298b3dec: 1/4
Waiting for more votes.
2024-10-27 6:33:22 0 [Note] WSREP: Member 3(node4) responds to vote on a9e687f9-9421-11ef-8f3c-322ad9279b98:39957,0000000000000000: Success
2024-10-27 6:33:22 0 [Note] WSREP: Votes over a9e687f9-9421-11ef-8f3c-322ad9279b98:39957:
0000000000000000: 2/4
e813fdab298b3dec: 1/4
Winner: 0000000000000000
2024-10-27 6:33:22 2 [ERROR] WSREP: Inconsistency detected: Inconsistent by consensus on a9e687f9-9421-11ef-8f3c-322ad9279b98:39957
at ./galera/src/replicator_smm.cpp:process_apply_error():1343
2024-10-27 6:33:22 2 [Note] WSREP: Closing send monitor...
2024-10-27 6:33:22 2 [Note] WSREP: Closed send monitor.
2024-10-27 6:33:22 2 [Note] WSREP: gcomm: terminating thread
2024-10-27 6:33:22 2 [Note] WSREP: gcomm: joining thread
2024-10-27 6:33:22 2 [Note] WSREP: gcomm: closing backend