-
Problem report
-
Resolution: Fixed
-
Major
-
5.0.13
-
None
-
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?