Table in use The storage engine for the table doesn't support repair

[Mark Coates]

hi all,

I am currently running WHMCS on my VPS and today i have noticed that 2 of the databse tables are "in use"

I have rebooted the VPS and still the same. There is no backups of any other database/website work being done.

i am using cPanel 80.0.15 with centos 7.6

I have not tried any restore yet as there has been a lot of activity today in regards to the database and dont really want to loose this.

 

[GOT]

Have you tried repairing the database?

 

[Mark Coates]

Just tried this and it says

The storage engine for the table doesn't support repair

 

[GOT]

That would likely mean that they are innodb tables then, though this is pretty rare. Might have a look here

Recovering Innodb table Corruption

I would also look in your mysql log and see what it says about those tables in there.

The error log from you app indicates files may have been manually deleted which would be bad, there's no repairing that, you gotta restore the backup.

 

[Mark Coates]

Hi @GOT

sorry if i am being a pain but that link kinda went over my head a little, and where would the log be stored?

I have tried to repair the database again knowing it probably wouldn't work just too see if there was anything i missed and for the 2 tables in questions it said this (as attached)

hope this is more help

 

[cPanelLauren]

You can typically find the MySQL error logs at:

/var/lib/mysql/

If they're not present there the log location will be noted in /etc/my.cnf

tablespace issues are a form of innodb corruption, the following guide my be helpful:
Tutorial - InnoDB Corruption Repair Guide

 

[Mark Coates]

Thanks @cPanelLauren

none of this worked. i ended up reinstalling the app and copying manually all of the data from the old database to the new.

i did not copy any table settings or formatting just the content and all appears now to be working as it should

 

[cPanelLauren]

Hi @Mark Coates

I'm sorry the suggestions didn't work but I am glad to hear that you were able to find a resolution. Thanks for letting us know.