A database connection error has been detected, we are attemp

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
shawnashley
Posts: 13
Joined: Mon Dec 02, 2013 8:10 am

A database connection error has been detected, we are attemp

Post by shawnashley »

A database connection error has been detected, we are attempting to repair the server, if the repair does not resolve the issue, please contact Nagios support.

I have tried unsuccessfully to repair the database. I believe I may be out of disk space. any help would be greatly appreciated.
tmcdonald
Posts: 9117
Joined: Mon Sep 23, 2013 8:40 am

Re: A database connection error has been detected, we are at

Post by tmcdonald »

Let's confirm the disk space:

Code: Select all

df -h
Former Nagios employee
shawnashley
Posts: 13
Joined: Mon Dec 02, 2013 8:10 am

Re: A database connection error has been detected, we are at

Post by shawnashley »

/dev/mapper/VolGroup-lv_root 7.5g 7.g 137m 99%

I deleted some old backups and upgrade files and was able to get the server up and running again. It is a virtual machine and I added another 10gb to the VM. I do not have enough disk space to run a backup.
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: A database connection error has been detected, we are at

Post by slansing »

I would recommend using snapshots in that case, as your main source of backing up the system.
shawnashley
Posts: 13
Joined: Mon Dec 02, 2013 8:10 am

Re: A database connection error has been detected, we are at

Post by shawnashley »

but I cannot restore the snap shot as it will put the machine back to the state it is now, not enough disk space.

Can I extend that partition without destroying the data?
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: A database connection error has been detected, we are at

Post by slansing »

Well, lets at least get you to a better position, what is the output of:

Code: Select all

for i in G M K; do du -ah | grep [0-9]$i | sort -nr -k 1; done | head -n 11
You may want to clear out some old logs in /var/, you can follow this to resize:

http://assets.nagios.com/downloads/nagi ... M_Disk.pdf
shawnashley
Posts: 13
Joined: Mon Dec 02, 2013 8:10 am

Re: A database connection error has been detected, we are at

Post by shawnashley »

4.0k
shawnashley
Posts: 13
Joined: Mon Dec 02, 2013 8:10 am

Re: A database connection error has been detected, we are at

Post by shawnashley »

I just cleared old log files and now have 2.7gb free. I should be able to get a backup now.
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: A database connection error has been detected, we are at

Post by slansing »

Great, I'd grab a snapshot if it is in current, working condition as well, and move that backup off of the system before you attempt to expand the disk via the above guide. Let us know how it goes or if you have any questions at all!
Locked