[ZBX-14614] Trigger dependency linked to template instead of host with discovery action Created: 2018 Jul 16  Updated: 2024 Apr 10  Resolved: 2018 Sep 03

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 3.4.11
Fix Version/s: 3.0.21rc1, 3.0.22rc1, 3.4.13rc1, 3.4.14rc1, 4.0.0beta1, 4.0.0beta2, 4.0 (plan)

Type: Problem report Priority: Critical
Reporter: Kaspars Mednis Assignee: Michael Veksler
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File Actions.PNG     PNG File Triggers.PNG     PNG File template HTTP.PNG     PNG File template SSH.PNG    
Issue Links:
Causes
causes ZBX-14819 link zabbix agent windows template fa... Closed
causes ZBX-14900 Can not auto register agent to server Closed
causes ZBX-14799 Fail to link to templates under disco... Closed
Duplicate
duplicates ZBX-14832 auto registration ERROR Closed
is duplicated by ZBX-14819 link zabbix agent windows template fa... Closed
is duplicated by ZBX-14900 Can not auto register agent to server Closed
is duplicated by ZBX-14799 Fail to link to templates under disco... Closed
Team: Team A
Sprint: Sprint 39, Sprint 40, Sprint 41, Sprint 42
Story Points: 1

 Description   

Example how to reproduce:

Create 3 templates with one simple check rule for each template (Just by example, service types doesn't matter)

  • icmpping
  • net.tcp.service[http]
  • net.tcp.service[ssh]

Create 3 triggers, one for each template with service availability (ping,http,ssh)

SSH service availability trigger from the SSH Template and HTTP service availability trigger from the HTTP template both depends on PING service availability trigger from the Ping template

Create discovery rule with ping,ssh,http service checks
Create Discovery Actions

  • link HTTP and PING template if HTTP service is found
  • link SSH and PING template if SSH service is found

Expected:

For each host found, host is created, templates are linked and trigger dependencies are assigned to the correct host

Result:

Only one template is linked correctly, on the second template trigger dependency is set to the template, not to the host !!!

See attached screenshots.



 Comments   
Comment by Michael Veksler [ 2018 Jul 26 ]

Available for testing in svn://svn.zabbix.com/branches/dev/ZBX-14614-30

r83101.

Comment by Andris Zeila [ 2018 Aug 06 ]

To clarify what was broken - linking template pair A, C, where C cotains trigger dependant on trigger in A, to a host that already had template A linked.

Comment by Michael Veksler [ 2018 Aug 08 ]

Available in:

  • 3.0.21rc1 r83593
  • 3.4.13rc1 r83594
  • 4.0.0beta1 (trunk) r83595
Comment by Andris Zeila [ 2018 Sep 03 ]

Fixed bug when server tried to link templates with triggers having no dependencies.
Released in:

  • pre-3.0.22rc1 r84448
  • pre-3.4.14rc1 r84449
  • pre-4.0.0beta2 r84451
Comment by Tammy T [ 2018 Oct 02 ]

I updated to  3.4.14, Revision 84877,  and the problem was not solved. 

Comment by Vladislavs Sokurenko [ 2018 Oct 02 ]

Hello, thank you for looking into this, could you please be more specific which problem and please also try restarting Zabbix server after update, thanks !

Comment by Tammy T [ 2018 Oct 02 ]

The problem that I still have:

"[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=80772 and]"

 

This happens when in try to create an auto registration action linking a template. 

If I dont link any template, works fine.

 

Why I am commenting here: all the posts in foruns and issues points to here

 

I restarted after the update and the server and all my 4 proxies are in the latest version available in the Debian repo

 

No luck

 

Generated at Thu Apr 25 15:15:21 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.