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

query failed when host became available

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 3.0.0
    • None
    • Server (S)
    • None
    • Zabbix 3.0.0
      Oracle 11g

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: