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

Need to fix numeric field overflow error when using custom miltiplier for the item.

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Critical Critical
    • None
    • None
    • Server (S)
    • None
    • Zabbix v1.8.x

      Need to fix numeric field overflow error when used custom miltiplier for the item.

      When using custom multiplier for the item with type "numeric" sometimes can appear "numeric field overflow" error in the zabbix log file:

      3286:20100102:155134.118 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: numeric field overflow
      DETAIL: A field with precision 16, scale 4 must round to an absolute value less than 10^12.
      [insert into history (itemid,clock,value) values (503490,1262436691,100000000000000.000000);

      Seems that this problem appears because Zabbix is checking these values before applying custom multiplier.

      Also there is problem with "trends" table:

      20100104:203307.681 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: numeric field overflow
      DETAIL: A field with precision 16, scale 4 must round to an absolute value less than 10^12.
      [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (18440,1262624400,395,13287.000000,24934.210738,42752.800000);

            Unassigned Unassigned
            igor Igor Danoshaites (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: