HA app Nodes switch regularly

[nico0551]

Hi together,

I have Zabbix running in HA-Mode with 2 nodes and a mariadb galera-cluster database. At the beginning everything was fine, but after we started adding more hosts the app server nodes started switching every day without any reason. I tried increasing the failover time without any impact.
After checking the logs everything looks fine, just out of the blue I get:

1601722:20220912:030556.023 "zabbix-node-01" node switched to "standby" mode
2264645:20220912:030556.023 executing housekeeper
2282716:20220912:030556.116 starting HA manager
2282716:20220912:030556.117 HA manager started in standby mode
2282716:20220912:031054.775 slow query: 289.648984 sec, "select ha_nodeid,name,status,lastaccess,address,port,ha_s essionid from ha_node order by ha_nodeid for update"
2282716:20220912:031054.816 [Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [commit;]
1601722:20220912:040556.122 "zabbix-node-01" node is working in "standby" mode​​

I wasn't able to find any information regarding this topic, is this just a normal housekeeping behavior or is there an issue with my setup?

Thanks a lot for every suggestion.

[nico0551]

I forgot, I'm running Zabbix v6.2.0 and mariadb 10.6.8.