Page 1 of 1

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

Posted: Tue Jun 12, 2018 11:44 am
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

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

Posted: Tue Jun 12, 2018 2:41 pm
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

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

Posted: Tue Jun 12, 2018 3:02 pm
by awilson
Thank you!

Alan

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

Posted: Tue Jun 12, 2018 3:33 pm
by scottwilkerson
awilson wrote:Thank you!

Alan
Glad to be of assistance.