Getting alert spam instead only on as set

Hi,
i get repeating alerts (every 5min) instead of only 1 like configured for my storage fillrate warning alert. This is very anoying, because alert started at 4am and i recognized at 8am, so i’ve got nearly 100 messages for the same issue.

First Message:
"
Monitoring
Alert for device ============== - Storage Fillrate warning
Device Name: ==============
Severity: warning
Uptime: 3d 16h 54m 53s
Timestamp: 2019-03-28 06:30:15
Location: ==============

Server: ==============
Mount Point: /
Percent Utilized: 91
"

Second and above…
"
Alert for device ============== - Storage Fillrate warning got worse
Device Name: ==============
Severity: warning
Uptime: 3d 16h 59m 53s
Timestamp: 2019-03-28 06:33:01
Location: ==============

Server: ==============
Mount Point: /
Percent Utilized: 90
"

storage_perc_warn is set to 90

The configuration looks like:

SQL Syntax for Alert looks like here:
SELECT * FROM devices,storage WHERE (devices.device_id = ? AND devices.device_id = storage.device_id) AND storage.storage_perc >= storage.storage_perc_warn

i activated “override SQL” to get storage_perc_warn Column handled.

Severity: warning
max alerts: 1
delay: 1m
interval: 5m
mute alerts: off
invert match: off
recovery alerts: on

For me it looks like a bug in alter handler
Hope someone can help me.
with regards

Hi,

Why you needed override SQL?

This is part of mine

You need to use `table.field` with the `

Not sure what is happening to you, as I only receive one alert with that.

Try not setting an interval if you only want one alert…

` seems to solve the Problem, so no SQL Override is needed

thanks