-
Incident report
-
Resolution: Duplicate
-
Major
-
None
-
3.4.13
-
None
-
my env is CentOS 7.5
当我重启zabbix-agent的时候,zabbix-server的日志中将出现下面的错误
When I restart zabbix-agent, there will be the following error in the zabbix-server log.
18496:20180906:065012.901 [Z3005] query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 [select t.triggerid,t.templateid from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and i.hostid=10259 and]
作为一个运维工程师,我认为这是源代码中 SQL 语句 问题
As an operation and maintenance engineer, I think this is the problem of SQL statement in source code.
我在新的环境中测试过3.4.12版本,发现并没有这个问题
I tested the 3.4.12 version in the new environment and found that there was no such problem.
通过有问题的SQL 语句,我追踪到了文件src/libs/zbxdbhigh/host.c中,第2361-2367的SQL语句
Through the problematic SQL statement, I traced the SQL statement 2361-2367 in the file src/libs/zbxdbhigh/host.c
但是我并不懂C语言代码,所以我不能做更多
But I don't understand the C language code, so I can't do more.
最后,祝福zabbix社区越来越好!
Finally, wish the ZABBIX community better and better!