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
Need Assistance - SQL Database Error After Update
Need Assistance - SQL Database Error After Update
Last edited by Brooks on Fri Mar 30, 2018 4:57 am, edited 1 time in total.
Re: Need Assistance - SQL Database Error After Update
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
Thanks
Re: Need Assistance - SQL Database Error After Update
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.
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
Glad you were able to resolve it so quickly