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

Postgresql schema incorrect. Causes: PGRES_FATAL_ERROR:ERROR: bigint out of range

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.6
    • Fix Version/s: 1.8
    • Component/s: Server (S)
    • Labels:
      None
    • Environment:
      Redhat 5.3
      Postgresql 8.1

      Description

      Found this error in Zabbix release 1.6.5:
      PGRES_FATAL_ERROR:ERROR: bigint out of range

      Using Postgresql 8.1

      Tables affected: trends_uint, history_uint

      Excerpt from schema source file: zabbix-1.6.5/create/schema/postgresql.sql:

      : Line 180
      CREATE TABLE history_uint (
              itemid bigint DEFAULT '0' NOT NULL,
              clock integer DEFAULT '0' NOT NULL,
              value bigint DEFAULT '0' NOT NULL
      ) with OIDS;
      
      : Line 276
      CREATE TABLE trends_uint (
              itemid bigint DEFAULT '0' NOT NULL,
              clock integer DEFAULT '0' NOT NULL,
              num integer DEFAULT '0' NOT NULL,
              value_min bigint DEFAULT '0' NOT NULL,
              value_avg bigint DEFAULT '0' NOT NULL,
              value_max bigint DEFAULT '0' NOT NULL,
              PRIMARY KEY (itemid,clock)
      ) with OIDS;
      
      patch:
      ALTER TABLE history_uint ALTER "value" TYPE numeric;
      ALTER TABLE trends_uint ALTER "value_min" TYPE numeric,
      ALTER "value_avg" TYPE numeric,
      ALTER "value_max" TYPE numeric; 
      

        Attachments

          Activity

            People

            Assignee:
            sasha Alexander Vladishev
            Reporter:
            dturner Daniel Turner
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: