Page 2 of 2
Re: MySQL Fails to repair
Posted: Wed Oct 16, 2013 7:40 am
by isadmin
trying to add system profile fails...profile.zip is 22 MG.....when i attached it the page is reset?
Re: MySQL Fails to repair
Posted: Wed Oct 16, 2013 9:57 am
by abrist
There is a maximum attachment size.
Try repairing the table manually:
Code: Select all
cd /var/lib/mysql/nagios/ ; myisamchk -r -q nagios_logentries.MYI
If it fails, try:
Code: Select all
cd /var/lib/mysql/nagios/ ; myisamchk -r nagios_logentries.MYI
Re: MySQL Fails to repair
Posted: Wed Oct 16, 2013 10:50 am
by isadmin
both options failed and I even tried the --force option...
Re: MySQL Fails to repair
Posted: Wed Oct 16, 2013 10:57 am
by abrist
If the following does not work, we may have to truncate the table or restore a backup:
Code: Select all
mysql -pnagiosxi -e 'use nagios; repair table nagios_logentries use_frm;'
Re: MySQL Fails to repair
Posted: Wed Oct 16, 2013 12:17 pm
by isadmin
I may have got it fixed....
I ran
cd /var/lib/mysql/nagios/ ; myisamchk --safe-recover --force nagios_logentries.MYI
and it took awhile but MYSQL has started and I am seeing no current errors....I will monitor and repost after awhile....
Re: MySQL Fails to repair
Posted: Wed Oct 16, 2013 1:24 pm
by isadmin
Im getting this in the MYSQL log...I have already expanded the virtual appliance by 5 G once.....
Disk is full writing './nagios/nagios_logentries.TMD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
16G 15G 8.0K 100% /
tmpfs 2.4G 0 2.4G 0% /dev/shm
/dev/sda1 97M 80M 13M 87% /boot
Re: MySQL Fails to repair
Posted: Wed Oct 16, 2013 2:44 pm
by lmiltchev
It seems like you've run out of disk space. You will have to take care of this issue first.
Re: MySQL Fails to repair
Posted: Thu Oct 17, 2013 10:35 am
by isadmin
Extended to 50G and rerunning repair script again
Re: MySQL Fails to repair
Posted: Thu Oct 17, 2013 10:39 am
by isadmin
repair completed successfully! Thanks guys!
Re: MySQL Fails to repair
Posted: Thu Oct 17, 2013 10:45 am
by slansing
Excellent!