Unknown error from mysql probe - Interval processing raised an error

book

Article ID: 34394

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

I keep getting "FWTool MySQL. Interval processing raised an error" however when I open the probe there are no alarms?
 

Environment

Release:
Component: UIMMSQ

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.*/