After upgrade from 5.3.4 to 5.4.0, Database Backend error

[jwelch]

(RHEL 6)
The System Status shows a problem (red exclamination point) after upgrading from nagiox xi 5.3.4 to 5.4.0, but it may be just a cosmetic issue.
I don't see any other problems. Reports seem ok (we don't normally use the reports so I may be missing something).
Restarting nagios and ndo2db had so effect on the error indicator.

nagiosxi_system_status.png

[bosecorp]

have to check postgress or mysql

[rkennedy]

Thanks @bosecorp!

@jwelch - what is the output of service mysqld status and service postgres status?

[dwhitfield]

In addition to what @rkennedy said, can you post your upgrade.log for us to take a look at? Thanks!

[jwelch]

# service mysqld status
mysqld (pid 7522) is running...
#
# service postgres status
postgres: unrecognized service
#

[kcarlson]

Not OP but appear to be having a similar issue on CentOS 7. When I check services, mariadb is running but postgresql is not. Here is the output I receive on that.

Jan 03 09:51:20 systemd[1]: Starting PostgreSQL database server...
Jan 03 09:51:20 systemd[1]: postgresql.service: control process exited, code=exited status=1
Jan 03 09:51:20 systemd[1]: Failed to start PostgreSQL database server.
Jan 03 09:51:20 systemd[1]: Unit postgresql.service entered failed state.
Jan 03 09:51:20 systemd[1]: postgresql.service failed.

[dwhitfield]

Can both of you with the problem run /usr/local/nagiosxi/scripts/repair_databases.sh and report back if that fixes the issue? Thanks!

If you have a modified system (or run into additional issues), you'll want to take a look at https://support.nagios.com/kb/article.php?id=24.

[kcarlson]

I ran the script but did not appear to fix my issues. The script ran fine and outputted:
===============
REPAIR COMPLETE
===============

=======================
nagios database repair succeeded
nagiosql database repair succeeded
nagiosxi database repair succeeded

Still seeing issues with the "Database Backend" on the System Status tab. When I check postgresql it is still not able to run. Also checked my disk usage per the guide you linked to but do not see any issues with storage. If it would help I can send the output of repair_databases.sh.

Thanks!

[dwhitfield]

Can both of you PM me your Profile? That will help determine if there is actually a common issue or not.

You can download it by going to Admin > System Config > System Profile and click the Download Profile button towards the top. If for whatever reason you *cannot* download the profile, please put the output of View System Info (5.3.4+, Show Profile if older) in the thread (that will at least get us some info).

For both of you, after you PM the profile, please update this thread. Updating this thread is the only way for it to show back up on our dashboard.

[kcarlson]

I have PM'd you my profile.
Thanks!