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

SQL command not properly ended

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 3.0.0
    • None
    • Server (S)
    • None
    • OracleLinux 7.2 with an Oracle 12.1.0.2 database

    Description

      Seeing these messages in zabbix_server.log:

      17847:20160220:002807.340 [Z3005] query failed: [-1] ORA-00933: SQL command not properly ended [update hosts set errors_from=1455946087,disable_until=1455946102 where hostid=10084
      17849:20160220:002822.439 [Z3005] query failed: [-1] ORA-00933: SQL command not properly ended [update hosts set disable_until=1455946117 where hostid=10084
      17849:20160220:002837.444 [Z3005] query failed: [-1] ORA-00933: SQL command not properly ended [update hosts set disable_until=1455946132 where hostid=10084
      17849:20160220:002852.449 [Z3005] query failed: [-1] ORA-00933: SQL command not properly ended [update hosts set available=2,error='Received empty response from Zabbix Agent at [127.0.0.1]. Assuming that agent dropped connection because of access permissions.',disable_until=1455946192 where hostid=10084
      17846:20160220:002902.353 [Z3005] query failed: [-1] ORA-00933: SQL command not properly ended [update hosts set available=1 where hostid=10105
      17849:20160220:002952.690 [Z3005] query failed: [-1] ORA-00933: SQL command not properly ended [update hosts set available=1,error='',errors_from=0,disable_until=0 where hostid=10084
      17847:20160220:003014.403 [Z3005] query failed: [-1] ORA-00933: SQL command not properly ended [update hosts set available=1 where hostid=10106
      17844:20160220:003102.480 [Z3005] query failed: [-1] ORA-00933: SQL command not properly ended [update hosts set available=1 where hostid=10107
      17848:20160220:003103.496 [Z3005] query failed: [-1] ORA-00933: SQL command not properly ended [update hosts set available=1 where hostid=10108
      17846:20160220:003117.506 [Z3005] query failed: [-1] ORA-00933: SQL command not properly ended [update hosts set available=1 where hostid=10109
      24637:20160220:014425.397 [Z3005] query failed: [-1] ORA-00933: SQL command not properly ended [update hosts set available=1 where hostid=10084
      24641:20160220:014425.397 [Z3005] query failed: [-1] ORA-00933: SQL command not properly ended [update hosts set available=1 where hostid=10109
      24640:20160220:014425.398 [Z3005] query failed: [-1] ORA-00933: SQL command not properly ended [update hosts set available=1 where hostid=10108
      24638:20160220:014425.398 [Z3005] query failed: [-1] ORA-00933: SQL command not properly ended [update hosts set available=1 where hostid=10106
      24641:20160220:014433.418 [Z3005] query failed: [-1] ORA-00933: SQL command not properly ended [update hosts set available=1 where hostid=10105
      24639:20160220:014455.474 [Z3005] query failed: [-1] ORA-00933: SQL command not properly ended [update hosts set available=1 where hostid=10107
      24639:20160220:021009.287 [Z3005] query failed: [-1] ORA-00933: SQL command not properly ended [update hosts set errors_from=1455952209,disable_until=1455952224 where hostid=10106
      24642:20160220:021024.619 [Z3005] query failed: [-1] ORA-00933: SQL command not properly ended [update hosts set errors_from=0,disable_until=0 where hostid=10106

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              mamercad Mark Mercado
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: