Need Assistance - SQL Database Error After Update

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
Brooks
Posts: 36
Joined: Thu Dec 10, 2015 2:29 pm

Need Assistance - SQL Database Error After Update

Post by Brooks »

Hello,

Attempted to do a backup operation as I always do before doing the latest update using the following command:
/usr/local/nagiosxi/scripts/backup_xi.sh

During this backup process I encountered a SQL error (that I did not write down - assuming if I proceeded with the update the issue would resolve itself). The problem I have now is that I cannot login to the nagiox VM over the web. I get the following error:

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


- I tried the command a few times with no success. When I try to run the repair command I get the an error stating the database is locked. I tried restoring from a VM snapshot, but because of the way vmware handles Linux (limitations with Linux(versus windows) I could not restore the nagios VM to a good state.

I'm at a loss what to do. I do not plan on spending over $4000 to get phone support, so i'm hopeful someone here will have a resolution.

Thanks in advance,
Bob
Last edited by Brooks on Fri Mar 30, 2018 4:57 am, edited 1 time in total.
Brooks
Posts: 36
Joined: Thu Dec 10, 2015 2:29 pm

Re: Need Assistance - SQL Database Error After Update

Post by Brooks »

I also have run out of space after running the backup script. The file system is at 100%. I will have to do some digging to determine where the space is getting used. Any articles or suggestions (nagios logs that could be using some space??) where I could free up space would be great.

Thanks
Brooks
Posts: 36
Joined: Thu Dec 10, 2015 2:29 pm

Re: Need Assistance - SQL Database Error After Update

Post by Brooks »

Problem solved. This issue had to do with the filesystem at 100% full, which I did not realize at the time of posting. Just needed to increase the size of the VM partition.

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

Re: Need Assistance - SQL Database Error After Update

Post by scottwilkerson »

Glad you were able to resolve it so quickly
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
Locked