-
Incident report
-
Resolution: Fixed
-
Critical
-
1.6
-
None
-
Gentoo Linux
I've been getting the following error at random intervals throughout the last few days. If I restart the Postgres database and Zabbix server, everything works again for a a day or so and then the same error happens again.
32557:20090306:211157 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: deadlock detected
DETAIL: Process 32599 waits for ShareLock on transaction 578682166; blocked by process 32601.
Process 32601 waits for ShareLock on transaction 578682165; blocked by process 32599.
[update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
32557:20090306:211157 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block
[select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
32518:20090306:211158 One child process died. Exiting ...
32518:20090306:211200 ZABBIX Server stopped. ZABBIX 1.6.2.