ERROR: integer out of range

[echo]

Aug 21 11:20:30 zabbix postgres[82125]: [5-1] ERROR: integer out of range
Aug 21 11:20:30 zabbix postgres[82125]: [5-2] STATEMENT: select itemid,round(1285*(mod(clock+1525170,2678400))/(2678400),0) as i, sum(num) as count,avg(value_avg) as
Aug 21 11:20:30 zabbix postgres[82125]: [5-3] avg,min(value_min) as min, max(value_max) as max,max(clock) as clock from trends where itemid=18614 and clock>=1185006030 and
Aug 21 11:20:30 zabbix postgres[82125]: [5-4] clock<=1187684430 group by itemid,round(1285*(mod(clock+1525170,2678400))/(2678400),0)
Aug 21 11:21:11 zabbix postgres[82217]: [5-1] ERROR: integer out of range
Aug 21 11:21:11 zabbix postgres[82217]: [5-2] STATEMENT: select itemid,round(1285*(mod(clock+1525129,2678400))/(2678400),0) as i, sum(num) as count,avg(value_avg) as
Aug 21 11:21:11 zabbix postgres[82217]: [5-3] avg,min(value_min) as min, max(value_max) as max,max(clock) as clock from trends where itemid=18614 and clock>=1185006071 and
Aug 21 11:21:11 zabbix postgres[82217]: [5-4] clock<=1187684471 group by itemid,round(1285*(mod(clock+1525129,2678400))/(2678400),0)

Hi!

I get those errors on my log (/var/log/messages)
Any ideas why those come?

If I watch GRAPHS in month mode I don't see anything...


uname -a
FreeBSD 6.2-RELEASE-p5

sw:
php5-5.2.3
postgresql-client-8.2.4 PostgreSQL database (client)
postgresql-server-8.2.4_1 The most advanced open-source database available anywhere
zabbix-1.4.1_2,1 Application and network monitoring solution
zabbix-agent-1.4.1,1 Application and network monitoring solution

[barryp]

Easy to fix

This seems to be a PostgreSQL issue. I think the problem is that the 'clock' column of the 'trends' table is just a plain integer field. Changing it to 'bigint' on-the-fly with this command:

ALTER TABLE trends ALTER COLUMN clock TYPE bigint;

seems to fix it - I can see month and year graphs now.

Probably all the 'clock' columns in all the Zabbix tables should be set that way too - although I've only changed the one table myself so far.

[Aly]

related -> http://www.zabbix.com/forum/showthread.php?t=8750