-
Incident report
-
Resolution: Fixed
-
Major
-
1.6
-
None
-
Redhat 5.3
Postgresql 8.1
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;