Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-7424

After upgrade from 2.0.6 to 2.2 filtered triggers query stuck for 18+ min

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Incomplete
    • Icon: Critical Critical
    • None
    • 2.2.0
    • Frontend (F)
    • 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;

            Unassigned Unassigned
            alexo Alex Ousyskin
            Votes:
            2 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: