[ZBX-14832] auto registration ERROR Created: 2018 Sep 11  Updated: 2018 Sep 11  Resolved: 2018 Sep 11

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

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

centos6.7 mysql5.6 php7.1

Issue Links:
Duplicate
is duplicated by ZBX-14614 Trigger dependency linked to template... Closed

 Description   

Steps to reproduce:

  1. Create automatic registration, automatic template association
  1. The client sends metadata
  1. zabbix-server.log  report an error

Result:
183775:20180911:142900.495 [Z3005] query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL 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=10315 and]
183775:20180911:142900.496 cannot send list of active checks to "172.16.66.55": host [172.16.66.55] not found

 Comments   
Comment by Alexey Pustovalov [ 2018 Sep 11 ]

Thank you! The issue is known. Closed as duplicate.

Generated at Sat Apr 27 02:18:10 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.