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

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.0.8
    • Fix Version/s: 2.2.1rc1, 2.3.0
    • Component/s: Frontend (F)
    • Labels:
    • Environment:
      Debian Wheezy (7.2)
      PostgreSQL 9.1.9

      Description

      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

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: