SOLVED: Greyhole disabled; mysql tables corrupted?

[gstreet]

Progress. I think I have managed to fix it.

Searched around a bit on Repairing mySQL. Ref: https://dev.mysql.com/doc/refman/5.0/en ... check.html

First step was to check table that was giving me errors:

Code: Select all

gstreet@gstreet-MicroServer:/$ sudo myisamchk var/lib/mysql/greyhole/settings Checking MyISAM file: var/lib/mysql/greyhole/settings Data records: 9 Deleted blocks: 0 myisamchk: warning: Table is marked as crashed and last repair failed - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links MyISAM-table 'var/lib/mysql/greyhole/settings' is usable but should be fixed

Then I tried to repair it - no good

Code: Select all

gstreet@gstreet-MicroServer:/$ sudo myisamchk --safe-recover var/lib/mysql/greyhole/settings - recovering (with keycache) MyISAM-table 'var/lib/mysql/greyhole/settings' Data records: 9 myisamchk: error: Can't create new tempfile: 'var/lib/mysql/greyhole/settings.TMD' MyISAM-table 'var/lib/mysql/greyhole/settings' is not fixed because of errors Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag

So I decided to get brave and force it

Code: Select all

gstreet@gstreet-MicroServer:/$ sudo myisamchk --safe-recover -f var/lib/mysql/greyhole/settings - recovering (with keycache) MyISAM-table 'var/lib/mysql/greyhole/settings' Data records: 9

Looked like it worked? Decided to test to look at greyhole stats which had been giving me an error

Code: Select all

gstreet@gstreet-MicroServer:/$ greyhole --stats Greyhole Statistics =================== Storage Pool Total - Used = Free + Trash = Possible /var/hda/files/drives/drive1/gh: 1834G - 853G = 888G + 0G = 888G /var/hda/files/drives/drive2/gh: 1834G - 858G = 883G + 0G = 883G /var/hda/files/drives/drive3/gh: 1834G - 917G = 824G + 0G = 824G /var/hda/files/drives/drive4/gh: 1834G - 861G = 880G + 0G = 880G ========================================== Total: 7335G - 3489G = 3474G + 1G = 3475G

Eureka! Looks like it is working. Running a sudo greyhole -fsck now. Then I'll reboot and monitor. If I still have problems, I'll update this thread but I am going to mark it solved for now.

Thanks for taking the time to try to help me, Bigfoot.

[bigfoot65]

Happy to help.

Is this something that might be useful to document in the wiki? If so, could you please add it?