-
Incident report
-
Resolution: Fixed
-
Minor
-
2.0.8
-
Debian Wheezy (7.2)
PostgreSQL 9.1.9
In postgresql log file every 15 minutes I get an error:
ERROR: invalid input syntax for integer: "1.3832431E9" at character 305
STATEMENT: SELECT DISTINCT t.*,h.name AS hostname,h.host,h.hostid FROM triggers t,functions f,items i,hosts h WHERE NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND t.lastchange>'1.3832431E9' AND t.lastchange<'1383244013' AND t.value='1' AND t.status='0' AND t.flags IN ('0','4') AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND h.hostid=i.hostid AND t.triggerid BETWEEN 000000000000000 AND 099999999999999