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

    • Incident report
    • Resolution: Fixed
    • Major
    • 1.8
    • 1.6
    • Server (S)
    • None
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: