[ZBX-10415] Cannot update host availability after upgrade to 3.0.0 Created: 2016 Feb 19 Updated: 2017 May 30 Resolved: 2016 Feb 19 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Proxy (P), Server (S) |
| Affects Version/s: | 3.0.0 |
| Fix Version/s: | 3.0.1rc1, 3.2.0alpha1 |
| Type: | Incident report | Priority: | Blocker |
| Reporter: | Anton Alekseev | Assignee: | Unassigned |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | patch, server, upgrade | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
Oracle Linux 6.5 |
||
| Attachments: |
zabbix-3.0.0.patch
|
||||||||||||
| Issue Links: |
|
||||||||||||
| Description |
|
I use Zabbix with Oracle DB 11.2.0.4. After upgrade from 2.4 to 3.0 the Zabbix Server started spamming messages like this into log: 15177:20160219:104721.042 [Z3005] query failed: [-1] ORA-00911: invalid character [update hosts set disable_until=1455857301 where hostid=10896 ;] It is caused by SQL query, which is formed in function "zbx_sql_add_host_availability" and ended by semicolon, and can be fixed by applying the following patch: --- zabbix-3.0.0.old/src/libs/zbxdbhigh/db.c 2016-02-15 18:25:54.000000000 +0600 +++ zabbix-3.0.0/src/libs/zbxdbhigh/db.c 2016-02-19 11:50:14.934039842 +0600 @@ -2654,7 +2654,7 @@ } } - zbx_snprintf_alloc(sql, sql_alloc, sql_offset, " where hostid=" ZBX_FS_UI64 "\n;", ha->hostid); + zbx_snprintf_alloc(sql, sql_alloc, sql_offset, " where hostid=" ZBX_FS_UI64 "\n", ha->hostid); return SUCCEED; } |
| Comments |
| Comment by Alexei Vladishev [ 2016 Feb 19 ] |
|
Thanks for reporting this issue, it will be fixed asap. |
| Comment by Andris Zeila [ 2016 Feb 19 ] |
|
Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-10415 |
| Comment by Andris Zeila [ 2016 Feb 19 ] |
|
Style fixes reviewed, thanks. |
| Comment by Andris Zeila [ 2016 Feb 19 ] |
|
Released in:
|