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

Mark Coates

Well-Known Member
Mar 13, 2019
96
12
8
Doncaster
cPanel Access Level
Root Administrator
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.
 

Attachments

GOT

Get Proactive!
PartnerNOC
Apr 8, 2003
1,542
207
343
Chesapeake, VA
cPanel Access Level
DataCenter Provider
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

Well-Known Member
Mar 13, 2019
96
12
8
Doncaster
cPanel Access Level
Root Administrator
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
 

Attachments