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

Mark Coates

• June 13, 2019 17:34

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

  • June 13, 2019 22:42

  Have you tried repairing the database?

  0
• 

  Mark Coates

  • June 13, 2019 22:52

  Just tried this and it says The storage engine for the table doesn't support repair

  0
• 

  GOT

  • June 13, 2019 23:21

  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.

  0
• 

  Mark Coates

  • June 14, 2019 07:23

  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

  0
• 

  cPanelLauren

  • June 14, 2019 15:35

  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:

  0
• 

  Mark Coates

  • June 16, 2019 21:49

  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 :)

  0
• 

  cPanelLauren

  • June 17, 2019 14:08

  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.

  0

Please sign in to leave a comment.