Hi,
Yesterday, I think, my Pandora Self Monitoring Database Maintenance alert turned red. Its never done that before, and I've been running Pandora for years. I couldn't find much documentation on what the monitor is actually monitoring. I believe it means the database maintenance task failed?
I thought I'd try a reboot. The server has come back, but the maintenance task is still red, and I now have lots of notifications in the web console:
- Discovery Server not running
- Plugin Server not running
- Web Server not running
- Inventory Server not running
- etc.
The pandora error log shows the maintenance task stopped yesterday at 14:17, and never ran again, then I started getting server perl errors. At that time, I had run an apt upgrade for outstanding patches, one of these was libdbd-mysql-perl. Could this have caused a problem with the Pandora database?
I'm running Pandora on Ubuntu 22.04.5 LTS
Version v7.0NG.777 Andromeda - CommunityCurrent package 777MR version MR69BuildPC240612
Here is the version of libdbd-mysql-perl:
Preparing to unpack .../21-libdbd-mysql-perl_1%3a5.013-1.jammy_amd64.deb ...Unpacking libdbd-mysql-perl (1:5.013-1.jammy) over (4.050-5ubuntu0.22.04.1) ...
> sudo apt upgradeCalculating upgrade...",The following packages will be upgraded:", docker-ce docker-ce-cli docker-ce-rootless-extras google-chrome-stable", libapache2-mod-php8.3 libdbd-mysql-perl php8.3 php8.3-bz2 php8.3-cli", php8.3-common php8.3-curl php8.3-fpm php8.3-gd php8.3-intl php8.3-ldap", php8.3-mbstring php8.3-mysql php8.3-opcache php8.3-readline php8.3-snmp", php8.3-xml php8.3-zip ubuntu-drivers-common",23 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.",
> sudo tail /var/log/pandora/pandora_server.error2026-01-19 13:00:01 - pandora pandora_db: pandora_db maintenance tasks starts2026-01-19 13:17:01 - pandora pandora_db: pandora_db maintenance tasks ends2026-01-19 13:17:01 - pandora pandora_db: pandora_db maintenance tasks starts2026-01-19 14:00:01 - pandora pandora_db: pandora_db maintenance tasks ends2026-01-19 14:00:01 - pandora pandora_db: pandora_db maintenance tasks startsUse of uninitialized value in numeric eq (==) at /tmp/par-726f6f74/cache-8c58fe102a7f94ca5ff6fc4438c9d258f0502fb1/inc/lib/PandoraFMS/Core.pm line 7156.2026-01-19 14:17:01 - pandora pandora_db: pandora_db maintenance tasks ends2026-01-19 14:17:01 - pandora pandora_db: pandora_db maintenance tasks starts2026-01-19 16:54:03 - pandora Starting Pandora FMS Server. Error logging activated.Use of uninitialized value in numeric eq (==) at /tmp/par-726f6f74/cache-8c58fe102a7f94ca5ff6fc4438c9d258f0502fb1/inc/lib/PandoraFMS/Core.pm line 7156.Use of uninitialized value in numeric eq (==) at /tmp/par-726f6f74/cache-8c58fe102a7f94ca5ff6fc4438c9d258f0502fb1/inc/lib/PandoraFMS/Core.pm line 7156.Use of uninitialized value in numeric eq (==) at /tmp/par-726f6f74/cache-8c58fe102a7f94ca5ff6fc4438c9d258f0502fb1/inc/lib/PandoraFMS/Core.pm line 7156.Use of uninitialized value in numeric eq (==) at /tmp/par-726f6f74/cache-8c58fe102a7f94ca5ff6fc4438c9d258f0502fb1/inc/lib/PandoraFMS/Core.pm line 7156.Use of uninitialized value in numeric eq (==) at /tmp/par-726f6f74/cache-8c58fe102a7f94ca5ff6fc4438c9d258f0502fb1/inc/lib/PandoraFMS/Core.pm line 7156.Use of uninitialized value in numeric eq (==) at /tmp/par-726f6f74/cache-8c58fe102a7f94ca5ff6fc4438c9d258f0502fb1/inc/lib/PandoraFMS/Core.pm line 7156.
Thanks.
