zabbix server crashes after unsuccessful insert to postgresql database

XMLWordPrintable

    • Type: Incident report
    • Resolution: Fixed
    • Priority: Critical
    • None
    • Affects Version/s: 1.4.2
    • Component/s: Server (S)
    • None
    • Environment:
      zabbix 1.4.2, postgresql 8.0.14

      zabbix server crashes after unsuccessful insert to postgresql database, happens after a short time zabbix server runs (~3-4 mins).
      server log says:
      15654:20071204:145038 Query::insert into trends (clock,itemid,num,value_min,value_avg,value_max) values (1196766000,20163,1,0.000000,0.000000,0.000000)
      15654:20071204:145038 Query failed:PGRES_FATAL_ERROR:ERROR: duplicate key violates unique constraint "trends_pkey"

      15654:20071204:145038 Query::update items set nextcheck=1196769218,prevvalue=lastvalue,lastvalue='0',lastclock=1196769038 where itemid=20163
      15654:20071204:145038 Query failed:PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block

      15654:20071204:145038 Query::select distinct function,parameter,itemid,lastvalue from functions where itemid=20163
      15654:20071204:145038 Query failed:PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block

      the number of hosts monitored ~140, each with ~25 items

            Assignee:
            Alexander Vladishev
            Reporter:
            Konstantin Pavlov
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: