Unknown error from mysql probe - Interval processing raised an error

Document ID : KB000034394
Last Modified Date : 21/02/2019
Show Technical Document Details
Issue:
I keep getting "FWTool MySQL. Interval processing raised an error" however when I open the probe there are no alarms?
 
Resolution:
Interval processing raised an error alarm is generated when the probe is at loglevel 3.

When we set the probe to loglevel 5 and restart it, the error does not return.

There is absolutely nothing in the log related to this alarm.

As per the code, the main reason seems for this alarm is when probe is not able to fetch data from the server. There are several reasons for which this error may occur:

1. If connection is not correct (means connection is not ok) and profile is created and activated of that connection with at least one or more checkpoints.

2. If this query (show variables) fails to retrieve data which means probe failed to get system data for profile.

3. If this query (show global status) fails to retrieve data which means probe failed to get status data for profile.

4. If this query (show slave status) fails to retrieve data which means probe failed to get slave status data for profile.

So this is a transient error and can be ignored or you can EXCLUDE it (delete) via a nas pre-processing rule by using a message filter like: /.* Interval processing raised an error.*/