-
Type:
Problem report
-
Resolution: Cannot Reproduce
-
Priority:
Critical
-
None
-
Affects Version/s: 4.0.19
-
Component/s: Frontend (F)
-
None
Zabbix frontend created a trigger on a host level, which references as inherited from itself (triggerid=templateid).
Also it created other triggers (for other host) which reference on the first host's trigger as it's inherited from template.
According to audit log, it was one action as all entries have the same timestamp.
What that was - hard to say. Some changes on template level.
Later, after some days (not sure why) the wrong record in database caused this SQL repeated (by server?) very frequently:
(mysql general log, turned on runtime for a few seconds)
65102943 Query select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=100100045377781 65102937 Query select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=100100045377781 65102943 Query select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=100100045377781 65102937 Query select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=100100045377781 65102943 Query select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=100100045377781 65102937 Query select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=100100045377781 65102943 Query select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=100100045377781 65102937 Query select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=100100045377781 65102943 Query select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=100100045377781 65102937 Query select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=100100045377781 65102937 Query select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=100100045377781 65102943 Query select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=100100045377781 .....
note the triggerid=100100045377781 is the very first wrong trigger created.
You can see it on this picture.
It's in DB:
mysql> select * from triggers where triggerid=templateid \G
*************************** 1. row ***************************
triggerid: 100100045377781
expression: {100100091970725}<>1
description: TR***AY - API Gateway - Healtcheck Failed
url:
status: 0
value: 0
priority: 4
lastchange: 0
comments:
error:
templateid: 100100045377781
type: 0
state: 0
flags: 0
recovery_mode: 0
recovery_expression:
correlation_mode: 0
correlation_tag:
manual_close: 0
1 row in set (3.37 sec)
I tried different activity scenarios in frontend to reproduce it, but could not so far.
Used frontend version 4.0.14
