Database issues [Products documentation]

products:promonitor:6.7:troubleshooting:server:database

Book Creator

Add this page to your book

Book Creator

Remove this page from your book

Manage book (0 page(s))

Table of Contents

Database issues
- Too big database
  - How to fix

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 Pro.Monitor service, and wait that its process is terminated
Move, rename or delete the uiweb folder, containing the DB files.
Restart Pro.Monitor 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.7/troubleshooting/server/database.txt · Last modified: 2019/02/04 11:02 (external edit)