XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Critical Critical
    • 1.6
    • 1.6
    • Server (S)
    • 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.

            alexei Alexei Vladishev
            lukecyca Luke Cyca
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: