DB errors after 100% full filesystem - Repair w/no errors

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
awilson
Posts: 224
Joined: Mon Mar 21, 2016 1:20 pm

DB errors after 100% full filesystem - Repair w/no errors

Post by awilson »

Hi. Our Nagios XI server filled all of the space in the filesystem where it is installed. It happens to be the / filesystem. The host seems to be operating properly, but we are not able to log into the Nagios XI gui. Nagios is monitoring and issuing alerts. We ran the repair_databases.sh script twice with the same results below.

We receive the following message:
Databse Error
A database connection error has been detected, please follow the repair prompt below. If the issue persists, please contact Nagios support.
Run the following from the CLI as root to attempt to repair the DB:

/usr/local/nagiosxi/scripts/repair_databases.sh


That are the next steps to recover the system? Thanks. Alan

===============
REPAIR COMPLETE
===============
Stopping ndo2db: done.
Starting ndo2db: done.
Running configuration check...
Stopping nagios:. done.
Starting nagios: done.

=======================
nagios database repair succeeded
nagiosql database repair succeeded
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: DB errors after 100% full filesystem - Repair w/no error

Post by scottwilkerson »

If this is an older upgrded install you likely just need to restart postgresql now that you have enough space on the server

Code: Select all

service postgresql restart
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
awilson
Posts: 224
Joined: Mon Mar 21, 2016 1:20 pm

Re: DB errors after 100% full filesystem - Repair w/no error

Post by awilson »

Thank you!

Alan
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: DB errors after 100% full filesystem - Repair w/no error

Post by scottwilkerson »

awilson wrote:Thank you!

Alan
Glad to be of assistance.
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
Locked