We have about 10 maps and approximately 2300 devices.
This worked fine for years. Since a couple of weeks, we are getting every day tons of notifications from dozen of devices (not always the same, not always from specific map).
We tried to export/import database on another RB1100AHx4, but unfortunately the problem isn't solved.
We also tried this:
Code: Select all
Use sqlite3 dude.db
sqlite> DELETE FROM outages;
sqlite> DELETE FROM chart_values_raw;
sqlite> DELETE FROM chart_values_10min;
sqlite> DELETE FROM chart_values_2hour;
sqlite> DELETE FROM chart_values_1day;
sqlite> pragma integrity_check;
sqlite> vacuum;
sqlite> reindex;
p.s. We had the same issues with Dude 6.x., we hoped that upgrading to 7 would solve.
EDIT: db file is about 509 MB.
Any suggestion?
Thank you very much!