query failed when host became available

XMLWordPrintable

    • Type: Incident report
    • Resolution: Duplicate
    • Priority: Major
    • None
    • Affects Version/s: 3.0.0
    • Component/s: Server (S)
    • None
    • Environment:
      Zabbix 3.0.0
      Oracle 11g

      I run a test setup. Zabbix server and 5 zabbix agents (1x 2.2.6, 4x 3.0.0)

      Ever if a host became available the following lines can be found in log file:

      24310:20160225:112025.017 [Z3005] query failed: [-1] ORA-00911: invalid character [update hosts set available=1 where hostid=10110
;]
 24310:20160225:112025.017 enabling Zabbix agent checks on host "wzb-jira-1-test-01.admin.bnotk.de": host became available
 24310:20160225:112025.025 [Z3005] query failed: [-1] ORA-00911: invalid character [update hosts set available=1 where hostid=10108
;]
 24310:20160225:112025.026 enabling Zabbix agent checks on host "wzb-monitor-1-proxy-test-01.admin.bnotk.de": host became available
 24310:20160225:112025.040 [Z3005] query failed: [-1] ORA-00911: invalid character [update hosts set available=1 where hostid=10109
;]
 24310:20160225:112025.040 enabling Zabbix agent checks on host "wzb-versioning-1-test-01.admin.bnotk.de": host became available
 24310:20160225:112025.045 [Z3005] query failed: [-1] ORA-00911: invalid character [update hosts set available=1 where hostid=10112
;]
 24310:20160225:112025.047 enabling Zabbix agent checks on host "wzb-crowd-1-test-01.admin.bnotk.de": host became available

      If i run the update query direct in sql developer all works fine.

            Assignee:
            Unassigned
            Reporter:
            Christian Meissner
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: