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

Timer creates huge query with thousends times more eventids that open problems

XMLWordPrintable

    • Team A
    • Sprint 79 (Aug 2021)
    • 1

      Installation with only 1984 open problems:

      select count(*) from problem where r_eventid is NULL;
      1984
      

      But after tags where started to be used on some triggers timer process becomes very busy.
      It's executing queries that list 137k eventid's:

      select e.eventid,e.objectid,er.r_eventid,t.tag,t.value from events e left join event_recovery er on e.eventid=er.eventid left join problem_tag t on e.eventid=t.eventid where (...);
      

      No maintenances with tags have been defined. Why does it need to list so many eventid's when there's only limited amount of open problems? Is problem_tag table at all required if no maintenances with tags are used?

            wiper Andris Zeila
            zux Edgars Melveris
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: