Error Trying to Repair Corrupt Table

[[email protected]]

When attempting an upgrade I received the following error...

Error: Got error 28 from storage engine when trying to dump tablespaces

Got error 144 Table ./nagios/nagios_notifications is marked as crashed.......

Tied to run myisamchk -r -f nagios_<corrupted_table> on the affected table but get a segmentation fault after the 2nd index repair runs.

Tried to run echo "use nagios;repair table nagios_notifications use_frm;" | mysql -pnagiosxi with no success.

Ideas?

Thanks,

Joe

[abrist]

First, try our repair script:

Code: Select all

/usr/local/nagiosxi/scripts/repairmysql.sh nagios

Tied to run myisamchk -r -f nagios_<corrupted_table> on the affected table but get a segmentation fault after the 2nd index repair runs.

When a repair fails, it should not segfault. Try our script and report back.

[[email protected]]

Script runs and fails with segmentation fault. See attached screen grab.

Joe

[abrist]

Well, the table may need to be truncated if all else fails. If you are a current customer, please send an email to [email protected] to open a ticket.