-
Incident report
-
Resolution: Duplicate
-
Major
-
None
-
3.0.0
-
None
-
OracleLinux 7.2 with an Oracle 12.1.0.2 database
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
- duplicates
-
ZBX-10415 Cannot update host availability after upgrade to 3.0.0
- Closed