Database issues

Too big database

  • In some cases, the DB can grow too big because data retention is not configured properly or not working.
  • The impacts could be:
    • Server disk full
    • Slow UI response
    • Monitoring stopping

How to fix

  • You can recover from this situation if you have some backup snapshots, usually located in the snapshots folder
  • Stop Redpeaks service, and wait that its process is terminated
  • Move, rename or delete the uiweb folder, containing the DB files.
  • Restart Redpeaks server: A new empty database will be created
  • Log in using the admin user credentials configured during the installation.
  • Go in the snapshots menu and apply the latest snapshot
  • The server will have recovered its configuration.
  • Have a look in the Admin→System section and check data retention settings.
  • It is advised not to keep monitor jobs results more than a couple of days.
/home/clients/8c48b436badcd3a0bdaaba8c59a54bf1/wiki-web/data/pages/products/promonitor/6.8/troubleshooting/server/database.txt · Last modified: 2024/05/01 18:35 (external edit)