Details
-
Type:
Incident report
-
Status: Closed
-
Priority:
Blocker
-
Resolution: Fixed
-
Affects Version/s: 2.2.7rc1, 2.4.1
-
Component/s: Frontend (F), Server (S)
-
Labels:
Description
It can happen because Zabbix frontend and server can use the same table row for updating at the same time:
31628:20141020:094957.796 [Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [update ids set nextid=nextid+14 where nodeid=0 and table_name='housekeeper' and field_name='housekeeperid'] zabbix_server [31628]: ERROR [file:db.c,line:999] Something impossible has just happened. 31616:20141020:094930.468 [Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [update ids set nextid=nextid+14 where nodeid=0 and table_name='housekeeper' and field_name='housekeeperid'] zabbix_server [31616]: ERROR [file:db.c,line:999] Something impossible has just happened.