Zabbix fails while executing this internal query:
SELECT DISTINCT t.triggerid FROM triggers t,functions f,items i WHERE i.hostid IN (10084,10559) AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND t.flags IN (0,4)
The query keeps trying to execute while consuming a lot of resources. This is likely an API or UI trying to execute it and keeps failing. Are there any reasons why this query can fail? Any logs that can be checked?
Thanks!
SELECT DISTINCT t.triggerid FROM triggers t,functions f,items i WHERE i.hostid IN (10084,10559) AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND t.flags IN (0,4)
The query keeps trying to execute while consuming a lot of resources. This is likely an API or UI trying to execute it and keeps failing. Are there any reasons why this query can fail? Any logs that can be checked?
Thanks!