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

Auto registration bug

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 3.4.13
    • Server (S)
    • 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!

            Unassigned Unassigned
            t296917342 yuqiang zhou
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: