[ZBX-10424] SQL command not properly ended Created: 2016 Feb 20  Updated: 2017 May 30  Resolved: 2016 Feb 20

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 3.0.0
Fix Version/s: None

Type: Incident report Priority: Major
Reporter: Mark Mercado Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

OracleLinux 7.2 with an Oracle 12.1.0.2 database

Issue Links:
Duplicate
duplicates ZBX-10415 Cannot update host availability after... Closed

 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

 Comments   
Comment by Alexei Vladishev [ 2016 Feb 20 ]

It's a duplicate of ZBX-10415. The problem already was fixed in 3.0.1rc1.

Generated at Tue May 20 07:25:35 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.