Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-917

postgresql insert fatal error kills zabbix server immediately after startup

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Blocker Blocker
    • 1.6
    • 1.6
    • Server (S)
    • None

      Database is created with the scripts and a few host are imported into it from older setup
      The first few times the server ran for some minutes, now it terminates immediately upon startup.

      It is seen from the log that there is inserted more values than intended, if I read it correctly:
      [insert into history (clock,itemid,value) values (1242119572,22570,58,000000)]

      Log with debug=4:

      19241:20090512:111249 Starting zabbix_server. ZABBIX 1.6.4.
      19241:20090512:111249 **** Enabled features ****
      19241:20090512:111249 SNMP monitoring: YES
      19241:20090512:111249 WEB monitoring: YES
      19241:20090512:111249 Jabber notifications: NO
      19241:20090512:111249 ODBC: NO
      19241:20090512:111249 IPv6 support: NO
      19241:20090512:111249 **************************
      19246:20090512:111250 server #1 started [Poller. SNMP:YES]
      19252:20090512:111250 server #7 started [Trapper]
      19251:20090512:111250 server #6 started [Trapper]
      19248:20090512:111250 server #3 started [Poller. SNMP:YES]
      19253:20090512:111250 server #8 started [Trapper]
      19254:20090512:111250 server #9 started [Trapper]
      19257:20090512:111250 server #12 started [Alerter]
      19255:20090512:111250 server #10 started [Trapper]
      19256:20090512:111250 server #11 started [ICMP pinger]
      19260:20090512:111250 server #13 started [Housekeeper]
      19260:20090512:111250 Executing housekeeper
      19247:20090512:111250 server #2 started [Poller. SNMP:YES]
      19249:20090512:111250 server #4 started [Poller. SNMP:YES]
      19261:20090512:111250 server #14 started [Timer]
      19250:20090512:111250 server #5 started [Poller. SNMP:YES]
      19262:20090512:111250 server #15 started [Poller for unreachable hosts. SNMP:YES]
      19263:20090512:111250 server #16 started [Node watcher. Node ID:0]
      19264:20090512:111250 server #17 started [HTTP Poller]
      19266:20090512:111250 server #19 started [Escalator]
      19241:20090512:111250 server #0 started [Watchdog]
      19241:20090512:111250 In main_watchdog_loop()
      19265:20090512:111250 server #18 started [Discoverer. SNMP:YES]
      19246:20090512:111252 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: INSERT has more expressions than target columns
      [insert into history (clock,itemid,value) values (1242119572,22570,58,000000)]
      19246:20090512:111252 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block
      [select num,value_min,value_avg,value_max from trends where itemid=22570 and clock=1242118800]
      19241:20090512:111252 One child process died. Exiting ...

            alexei Alexei Vladishev
            slmeyer Steen Meyer
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: