Pandora FMS Community

761 Database Maintenance

linspec9078 · 27 oct 2022, 9:58 · 4 mensajes · 91 visitas

  1. Inicio del debate

    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.

  2. 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.

  3. Thank you vic.

    Checking the db i confirm the lock is set to 1 and there aren't other pandora_db processes in the system.

    Before to reset the lock, there is some log where is possibile to check why the script did not finisched?

  4. Hi linspec9078,

    Sorry but the pandora_db script does not report to any log.

    Best regards,

    Víctor.

Entra en tu cuenta para publicar.