-
Incident report
-
Resolution: Incomplete
-
Critical
-
None
-
2.2.0
-
zabbix_server --version
Zabbix server v2.2.0 (revision 40163) (12 November 2013)
Compilation time: Nov 12 2013 11:24:15
mysql Ver 5.5.28
PHP 5.3.3
Query generated by Monitoring -> Triggers with some filters stuck frontend for 20 min
Small investigation make clear that result from query return 293 rows in set (19 min 0.66 sec)
SELECT t.triggerid,t.lastchange FROM triggers t WHERE 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 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 h.maintenance_status=1) AND EXISTS (SELECT NULL FROM events e WHERE t.triggerid=e.objectid AND e.source=0 AND e.object=0 AND e.value=1 AND e.acknowledged=0) AND t.flags IN ('0','4') AND ((t.value=1) OR ((t.value=0) AND (t.lastchange>1385043768))) AND t.priority>='4' LIMIT 2002 OFFSET 0;