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

query failed when host became available

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 3.0.0
    • Server (S)
    • None
    • 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.

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

              Created:
              Updated:
              Resolved: