Email Alert - LibreNms keeps sending email even if no alert triggers

We have LibreNMS 24.6.0-33-g0a184d180 - Mon Jul 01 2024 02:37:27

For months all works perfectly. Suddenly (we didn’t change any settings) librenms send a lot of email alert even if no alarms triggered.

In the webui we have zero current alarms and we still receive email alerts for almost any device.

Is it a bug? Is there a way to clear ALL email alarms?

More details:

MariaDB [librenms]> SELECT * FROM alerts where state = 2;
Empty set (0.001 sec)

If I enable the “Device up/down” alert, it sends me an alert for any device !!! (some thousand emails)

Share your rule so we can see if anything is wrong with it.

I stopped the php service

systemctl stop php8.1-fpm

But I still receive emails with timestamp of some days ago. Maybe LibreNMS sent so many emails and the email server sends them a little at a time?

The rule is:

I suspect something was corrputed and LibreNMS sent a flood of email.

Is it possible to delete all pending email alert?
Can I delete the alerts table?

delete from alerts

If the emails are coming from days ago I suspect they are stuck in your mail queue which then depends on your setup.

Sorry, we finally discovered the (crazy!) reason.
Someone cloned the LibreNms installation in another environment so all these emails come from the cloned installation :(:(: