[1.3.8] Errors if nodeid > 0 (PostgreSQL)

[NOB]

Hi,

I am trying to use distributed monitoring.
Using a nodeid of 1, the following errors are shown
during deletion of an item from a template:

# pg_query() [function.pg-query]: Query failed: ERROR: integer out of range[/usr/local/www/data/zabbix/include/db.inc.php:355]
# Error in query [insert into housekeeper (housekeeperid,tablename,field,value) values (100000000000002, 'trends','itemid',100000000018576)] [ERROR: integer out of range]
# pg_query() [function.pg-query]: Query failed: ERROR: integer out of range[/usr/local/www/data/zabbix/include/db.inc.php:355]
# Error in query [insert into housekeeper (housekeeperid,tablename,field,value) values (100000000000003,'history_log','itemid',100000000018576)] [ERROR: integer out of range]
# pg_query() [function.pg-query]: Query failed: ERROR: integer out of range[/usr/local/www/data/zabbix/include/db.inc.php:355]
# Error in query [insert into housekeeper (housekeeperid,tablename,field,value) values (100000000000004,'history_uint','itemid',100000000018576)] [ERROR: integer out of range]
# pg_query() [function.pg-query]: Query failed: ERROR: integer out of range[/usr/local/www/data/zabbix/include/db.inc.php:355]
# Error in query [insert into housekeeper (housekeeperid,tablename,field,value) values (100000000000005,'history_str','itemid',100000000018576)] [ERROR: integer out of range]
# pg_query() [function.pg-query]: Query failed: ERROR: integer out of range[/usr/local/www/data/zabbix/include/db.inc.php:355]
# Error in query [insert into housekeeper (housekeeperid,tablename,field,value) values (100000000000006,'history','itemid',100000000018576)] [ERROR: integer out of range]

Regards,

Norbert.

[NOB]

Hi,

this statement should fix the problem for PostgreSQL 8.x.

ALTER TABLE housekeeper ALTER VALUE TYPE bigint;

HTH,

Norbert.

[Alexei]

Thanks for reporting this! Fixed.