Endless alerts problem - ghost (deleted) devices

Help
1

Hi,

Raspberry Pi (used to host LibreNMS) was occasianlly powered off and now I have endless alerts (Device down, no ICMP response) from ghost devices (on Telegram), which seem to be related to DB inconsistency or frozen cache data. 2 devices are deleted some time ago, and 1 still present in the list but alerting is set to off.

Manually upgraded to latest version with dayly.sh, rebooted Raspberry Pi, no changes.
Setting → Validate config → Database is OK.
Changed Settings → Alerting → Interval (minutes) to 360.

Yet I’m still getting alerts about these 3 devices.

How to fix this? May be manually purge some data from mysql DB?
Thanks in advance for any help.

2

You can clear all alerts out (genuine ones will just re-alert) by doing truncate alerts;

3 
MariaDB [librenms]> TRUNCATE alerts;
Query OK, 0 rows affected (0.091 sec)

Did it, unfortunately still getting these alerts.

4

Then it’s not LibreNMS sending them anymore. You might have a back log in your mail server, check your setup to see what that might be and if the mail queue needs emptying.