MySQL Fails to repair

[isadmin]

trying to add system profile fails...profile.zip is 22 MG.....when i attached it the page is reset?

[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

[isadmin]

both options failed and I even tried the --force option...

[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;'

[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....

[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

[lmiltchev]

It seems like you've run out of disk space. You will have to take care of this issue first.

[isadmin]

Extended to 50G and rerunning repair script again

[isadmin]

repair completed successfully! Thanks guys!

[slansing]

Excellent!