Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-7263

Errors in postgresql log due to bad syntax (invalid input syntax for integer: "1.3832467E9")

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Minor Minor
    • 2.2.1rc1, 2.3.0
    • 2.0.8
    • Frontend (F)
    • 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

            Unassigned Unassigned
            daftu Dawid Mos
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: