-
761 Database Maintenance
Hi all,
when i try to execute the db mantenace script i get the following message. It seems db maintenance is not working. What could be the cause?
[root@pandora ~]# /usr/share/pandora_server/util/pandora_db.pl /etc/pandora/pandora_server.conf
Pandora FMS DB Tool v7.0NG.761 Build 220427
This program is Free Software, licensed under the terms of GPL License v2
You can download latest versions and documentation at official web
DB Tool now initialized and running (PURGE=183 days, COMPACT=182 days, STEP=1) .
[*] Pandora FMS Enterprise module not available.
[*] Another instance of DB Tool seems to be running.
-
3 Replies
-
Hi linspec9078,
When the pandora_db script is launched, it adds a lock to the database so that another pandora_db script is not launched at the same time and when it finishes, it deletes this lock from the database.
For the problem that you have it could be due to 2 things:
1º The script has finished erroneously or before time having written the lock but without deleting it, so until the lock is not eliminated it won’t be able to be launched again.
To remove the lock you have to launch the following SQL query:
UPDATE tconfig SET value=0 WHERE token='pandora_lock_pandora';
(If your database has another name, it is possible that the token is different).
2º There is another pandora_db process active in the system, in this case you should kill the process and check point 1.
Best regards,
VÃc.
-
-
