Page 1 of 1

Error Trying to Repair Corrupt Table

Posted: Tue Aug 12, 2014 12:36 pm
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

Re: Error Trying to Repair Corrupt Table

Posted: Tue Aug 12, 2014 5:20 pm
by abrist
First, try our repair script:

Code: Select all

/usr/local/nagiosxi/scripts/repairmysql.sh nagios
[email protected] wrote: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.

Re: Error Trying to Repair Corrupt Table

Posted: Wed Aug 13, 2014 10:24 am
Script runs and fails with segmentation fault. See attached screen grab.

Joe

Re: Error Trying to Repair Corrupt Table

Posted: Wed Aug 13, 2014 4:59 pm
by 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.