Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6.16
-
None
Description
Our architecture is 3-node galera cluster - 2 DB nodes + 1 arbitrator in different locations. Plus running haproxy as the front end.
One of the DB nodes (node 2) hit a series of error, with the first one as follows:
2025-01-05 0:51:33 108 [ERROR] Slave SQL: Could not execute Write_rows_v1 event on table bes_core.tb_message_queue_medium_logger; Deadlock found when trying to get lock; try restarting transaction, Error_code: 1213; handler error HA_ERR_LOCK_DEADLOCK; the event's master log FIRST, end_log_pos 217, Internal MariaDB error code: 1213
This node was removed from the cluster. When we tried to restart it, it required SST to re-form the cluster.
I will upload the maria-error.log for node 1 and 2 for your review.