Hi.
I'm having a trouble with ZABBIX Server 1.4.5 + PostgreSQL 8.3 + FreeBSD 7.0
DB and Server is on different hosts.
Here is log from DB host:
I'm having a trouble with ZABBIX Server 1.4.5 + PostgreSQL 8.3 + FreeBSD 7.0
DB and Server is on different hosts.
Here is log from DB host:
Code:
postgres[878]: [4-1] ERROR: numeric field overflow postgres[878]: [4-2] DETAIL: A field with precision 24, scale 6 must round to an absolute value less than 10^18. postgres[878]: [4-3] STATEMENT: insert into trends (clock,itemid,num,value_min,value_avg,value_max) values postgres[878]: [4-4] (1212620400,19763,1,9223372036854775808.000000,9223372036854775808.000000,9223372036854775808.000000) postgres[878]: [5-1] ERROR: current transaction is aborted, commands ignored until end of transaction block postgres[878]: [5-2] STATEMENT: update items set nextcheck=1212623963,prevvalue=lastvalue,lastvalue='9223372036854775807',lastclock=1212623956 where postgres[878]: [5-3] itemid=19763 postgres[878]: [6-1] ERROR: current transaction is aborted, commands ignored until end of transaction block postgres[878]: [6-2] STATEMENT: select distinct function,parameter,itemid,lastvalue from functions where itemid=19763

Comment