Welcome to Pandora FMS Community!

Find answers, ask questions, and connect with our community around the world.

  • 761 Database Maintenance

    Posted by linspec9078 on October 27, 2022 at 09:58

    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?

    [[email protected] ~]# /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.

    vic replied 3 weeks, 2 days ago 2 Members · 3 Replies
  • 3 Replies
  • vic

    Administrator
    October 27, 2022 at 10:40
    906 Karma points
    Community awards: Bright ideas
    Community rank: Tentacle Master
    Like it
    Up
    0
    Down
    Drop it
    ::

    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.

    • linspec9078

      Member
      October 27, 2022 at 11:34
      217 Karma points
      Community rank: Tentacle rookie
      Like it
      Up
      0
      Down
      Drop it
      ::

      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?

  • vic

    Administrator
    November 15, 2022 at 11:24
    906 Karma points
    Community awards: Bright ideas
    Community rank: Tentacle Master
    Like it
    Up
    0
    Down
    Drop it
    ::

    Hi linspec9078,

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

    Best regards,

    Víctor.