My Zabbix server failed.
I changed scheme
After that I loosed some hosts
Code:
5364:20080818:164715 Query::insert into history (clock,itemid,value) values (1219056435,21971,302748341749300.687500) 5364:20080818:164715 Query failed:PGRES_FATAL_ERROR:ERROR: numeric field overflow DETAIL: A field with precision 16, scale 4 must round to an absolute value less than 10^12. 5364:20080818:164715 Query::select num,value_min,value_avg,value_max from trends where itemid=21971 and clock=1219053600 5364:20080818:164715 Query failed:PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block 5345:20080818:164715 One child process died. Exiting ... 5345:20080818:164717 ZABBIX Server stopped
Code:
ALTER TABLE history ALTER COLUMN value TYPE numeric(25,8);