Details
-
Incident report
-
Resolution: Fixed
-
Blocker
-
2.2.7rc1, 2.4.1
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.