-
Type:
Incident report
-
Resolution: Fixed
-
Priority:
Major
-
None
-
Affects Version/s: 1.4.3
-
Component/s: Frontend (F)
-
None
-
Environment:Zabbix 1.4.3 & Any PostgreSQL
PostgreSQL don't support unsgined integer (32 and 64 bit), as result when zabbix operand with unix timestamp (field clock in thrends for example) it's can get overflow.
Solution:
Change all clock field in database from integer to bigint. For example:
alter table trends alter column clock type bigint;