Page 1 of 1
DB Connect Error [nagiosxi] error
Posted: Tue May 06, 2014 1:56 pm
by Mrphantom
Last week our Nagios XI server crashed. After the crash I have been unable to restart this server. I believe that the issue may be that the root partition is full and can no longer function but I am not sure. I can not start the mysqld service at this time. Here is a print out of the the df and the attempt to start the service. Please let me know if you need anything else.
[root@nagiosxi ~]# df -i
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/mapper/VolGroup00-LogVol00 632736 168040 464696 27% /
[root@nagiosxi ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00 9.5G 9.5G 0 100% /
[root@nagiosxi ~]# service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting mysqld: [FAILED]
[root@nagiosxi ~]#
Re: DB Connect Error [nagiosxi] error
Posted: Tue May 06, 2014 2:13 pm
by Mrphantom
here is the fdisk -l printout
[root@nagiosxi ~]# fdisk -l
Disk /dev/sda: 21.5 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00024a62
Device Boot Start End Blocks Id System
/dev/sda1 * 1 13 102400 83 Linux
Partition 1 does not end on cylinder boundary.
/dev/sda2 13 1306 10382336 8e Linux LVM
Disk /dev/mapper/VolGroup00-LogVol01: 268 MB, 268435456 bytes
255 heads, 63 sectors/track, 32 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000
Disk /dev/mapper/VolGroup00-LogVol00: 10.4 GB, 10359930880 bytes
255 heads, 63 sectors/track, 1259 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000
Re: DB Connect Error [nagiosxi] error
Posted: Tue May 06, 2014 4:16 pm
by abrist
Most often, mysqld's failure to start can be attributed to crashed tables. Lets check:
Code: Select all
tail -100 /var/log/mysqld.log | grep crashed
Repair them with:
Code: Select all
/usr/local/nagiosxi/scripts/repairmysql.sh nagios
/usr/local/nagiosxi/scripts/repairmysql.sh nagiosql
service mysqld restart
Re: DB Connect Error [nagiosxi] error
Posted: Wed May 07, 2014 9:02 am
by Mrphantom
Thank you for your reply. The issue has been resolved. I added more disk space to the LVM via VSphere and then created a new sda3. I then took that and used it to increase the sda /root an additional 10gb. The mysqld service is now able to start and all monitoring has once again commenced.
Re: DB Connect Error [nagiosxi] error
Posted: Wed May 07, 2014 9:09 am
by tmcdonald
Good to hear. Locking this up now.