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

Problems Tab & Dashboard with Problem widget take long time for User and Admin Role

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Commercial support required
    • Icon: Trivial Trivial
    • None
    • None
    • None

      Hello, Am using zabbix Version 5.0.38 with MySQL 8.0.35.

      For last few days am seeing spikes in DB load Avg which is causing slowness in UI and sometimes wheel getting spinned up for large time then error contact zabbix administrator. When checked DB logs and process list there are few queries which is taking much time to execution which results in spike in DB load avg. Slowness is observed only for user and admin role not for super admin access.

      SELECT DISTINCT p.eventid,p.objectid,p.clock,p.ns,p.name,p.severity FROM problem p,functions f,items i,hosts_groups hg WHERE p.source='0' AND p.object='0' AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid IN (35,36,41) WHERE p.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<2 OR MIN(permission) IS NULL OR MIN(permission)=0) AND p.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hg.hostid AND hg.groupid IN (1245,1325,1548) AND p.severity IN (4,5) AND p.acknowledged=0 AND NOT EXISTS (SELECT NULL FROM event_suppress es WHERE es.eventid=p.eventid) AND (p.r_eventid IS NULL OR p.r_clock>1705458955) ORDER BY p.eventid DESC LIMIT 501

      Not sure what these queries are trying to look but I suspect these queries are from dashboard or problem tab which is causing spike in load avg.

      Attached screenshot and long running sessions for ref.

        1. Frontend issue.png
          111 kB
          Dhinesh Kumar
        2. long_running_sessions_2.txt
          27 kB
          Dhinesh Kumar

            edgar.akhmetshin Edgar Akhmetshin
            Dh1nesh Dhinesh Kumar
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: