SQL numeric field overflow causes zabbix to crash

XMLWordPrintable

    • Type: Incident report
    • Resolution: Fixed
    • Priority: Critical
    • None
    • Affects Version/s: 1.6
    • Component/s: Server (S)
    • None
    • Environment:
      Linux, postgreSQL

      I woke up and this is what I found in the log file:

      4100:20081202:072243 Query::insert into history (clock,itemid,value) values (1228231363,4363,54368664179395.906250)
      4100:20081202:072243 Query failed:PGRES_FATAL_ERROR:ERROR: numeric field overflowDETAIL: A field with precision 16, scale 4 must round to an absolute value less than 10^12.

      4100:20081202:072243 Query::select num,value_min,value_avg,value_max from trends where itemid=4363 and clock=1228230000
      4100:20081202:072243 Query failed:PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of tr
      ansaction block

      4041:20081202:072243 One child process died. Exiting ...

      It's rather disconcerting to see my monitoring application die. It seems that there was not sufficient sanitization of data before it was inserted into the "history" table.

            Assignee:
            Alexei Vladishev
            Reporter:
            Jason Wright
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: