I have a mysql database server on an EC2 instance with 3 drives in a Raid 0 array. This morning the server crashed and after inspecting the logs, I noticed a Structure Needs Cleaning error(i.e. System Error Code 117). With that I attempted to run an xfs_check on the effected drive but the following is what returned:
xfs_repair: /dev/md0 contains a mounted filesystem fatal error -- couldn't initialize XFS library
I have all the necessary tools/packages installed, so I checked the syslog and it returned this:
Filesystem "md0": XFS internal error xfs_da_do_buf(2) at line 2112 of file /build/buildd/linux-ec2-2.6.32/fs/xfs/xfs_da_btree.c. Caller 0xffffffff81261bb5
After attempting a xfs_repair I still see the same output as above and same syslog entry.
As the issue is only in one database directory, is there a way to either fix the issues mentioned or have the mysql ignore the database directory so as to continue in operation (i.e. manually delete the database while leaving lib directory intact). Any suggestions would be helpful.