Level: Critical

Purpose: To notify about long running queries which can negatively affect database performance. Some of these queries might not finish executing for days.

Scenario: A query can be executed, usually by the user, which requires too many resources to process in a feasible amount of time. This also happens often for reports that use too wide of a date range, or in heavy reports that are usually scheduled.

Resolution: This watchdog will resolve itself most of the time and it is important to let it resolve if it happens within a few hours. A resolution will occur when the process that exists for the extended period of time disappears.

Manual Action Steps: Allow a few hours for the query to finish executing. If this does not happen:

show processlist;

- Look for the longest running query and investigate if the origin of the query, if it can be killed and if it needs changing.

To kill the process (get the process id from the process list):

kill <insert processid here>

Auto Clear: Yes