It was announced in ZBX-497 and ZBX-311 that problem of server with PostgreSQL crashing because of incorrect values is solved in 1.6.4. We upgraded immediately just to find out that the problem is stil there. Server is still crushing couple of times a day. Here's the error message:
21348:20090507:125550 [Z3005] Query failed: [0] 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.
[insert into history (clock,itemid,value) values (1241693750,37027,3839922229258555.500000)]
21348:20090507:125550 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block
[select num,value_min,value_avg,value_max from trends where itemid=37027 and clock=1241690400]
21302:20090507:125550 One child process died. Exiting ...
21302:20090507:125552 ZABBIX Server stopped. ZABBIX 1.6.4.