Notifications

63 views

Description

Slow queries from job "Error Manager - Update Counters".

Release or Environment

All currently supported environments.

Cause

The "Error Manager - Update Counters" updates the values in "Discovery > Home" and "Discovery > Home > Schedules" (errors per schedule). It runs queries on automation_error_msg and updates automation_error_code_stats. The queries can take longer as the automation_error_msg table grows.

Resolution

  1. Lower the frequency of the "Error Manager - Update Counters" job to once every hour or even once every day (this will depend on how often these pages are used).

Article Information

Last Updated:2020-02-12 07:41:05
Published:2020-02-03