Symptoms
Changing a single control on the All Messages view (search text, endpoint, date range, page size or sort) fires the same query against the audit instance up to three times. On large audit databases the duplicate queries run concurrently for minutes, adding load to ServiceControl Audit and delaying the results the user is waiting for.
Who's affected
All ServicePulse users of the All Messages view; most noticeable with large audit stores where a single query already takes seconds.
Root cause
Two watchers each triggered a fetch: the controls watcher fetched after pushing the new query to the router, and the route watcher fetched again in response to that push. The controls watcher also watched the route, so it re-triggered itself once more.
Confirmed workarounds
None.
Original bug report
Found while investigating slow All Messages queries with a customer: the duplicate queries were visible running concurrently in the audit instance's database debug package.
Symptoms
Changing a single control on the All Messages view (search text, endpoint, date range, page size or sort) fires the same query against the audit instance up to three times. On large audit databases the duplicate queries run concurrently for minutes, adding load to ServiceControl Audit and delaying the results the user is waiting for.
Who's affected
All ServicePulse users of the All Messages view; most noticeable with large audit stores where a single query already takes seconds.
Root cause
Two watchers each triggered a fetch: the controls watcher fetched after pushing the new query to the router, and the route watcher fetched again in response to that push. The controls watcher also watched the route, so it re-triggered itself once more.
Confirmed workarounds
None.
Original bug report
Found while investigating slow All Messages queries with a customer: the duplicate queries were visible running concurrently in the audit instance's database debug package.