[ZBX-14900] Can not auto register agent to server Created: 2018 Sep 25  Updated: 2018 Sep 25  Resolved: 2018 Sep 25

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F), Server (S)
Affects Version/s: 4.0.0rc1
Fix Version/s: None

Type: Incident report Priority: Critical
Reporter: Minh Son Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Centos 7


Attachments: PNG File image-2018-09-25-09-42-20-050.png     PNG File image-2018-09-25-09-42-33-902.png    
Issue Links:
Causes
caused by ZBX-14614 Trigger dependency linked to template... Closed
Duplicate
duplicates ZBX-14614 Trigger dependency linked to template... Closed

 Description   

Steps to reproduce:

  1. Add auto registration rule. 
  2. Configure agent point Active Server to Zabbix IP
  3. Start agent but new hosts is not added to server

Result:
See screenshot...

See log file...

{code}


7480:20180924:180651.191 In lld_graphs_save()
7480:20180924:180651.191 End of lld_graphs_save()
7480:20180924:180651.191 In lld_graphs_get()
7480:20180924:180651.191 query [txnlev:0] [select g.graphid,g.name,g.width,g.height,g.yaxismin,g.yaxisma
x,g.show_work_period,g.show_triggers,g.graphtype,g.show_legend,g.show_3d,g.percent_left,g.percent_right,g.
ymin_type,g.ymin_itemid,g.ymax_type,g.ymax_itemid from graphs g,graph_discovery gd where g.graphid=gd.grap
hid and gd.parent_graphid=2153]
7287:20180924:180651.191 Sending [net.if.out[em3]]
7663:20180924:180651.191 [Z3005] query failed: [1064] You have an error in your SQL syntax; check the ma
nual 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.i
temid and i.hostid=10514 and]
7480:20180924:180651.191 End of lld_graphs_get()
7480:20180924:180651.191 In lld_gitems_get()
7480:20180924:180651.191 query [txnlev:0] [select gitemid,graphid,itemid,drawtype,sortorder,color,yaxiss
ide,calc_fnc,type from graphs_items where graphid=2153]
7550:20180924:180651.192 End of evaluate() value:0.007255
7550:20180924:180651.192 get_value_calculated() value:0.007255

{code}



 Comments   
Comment by Minh Son [ 2018 Sep 25 ]

seem the query

select t.triggerid,t.templateid from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.i
temid and i.hostid=10514 and

lacks some conditions.  

 

 

Comment by Vladislavs Sokurenko [ 2018 Sep 25 ]

Thank you for your report, which version are you using ?

Comment by Alexander Vladishev [ 2018 Sep 25 ]

Closed as duplicate of ZBX-14614.

Generated at Fri Apr 26 15:59:43 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.