table did not exist in the InnoDB data dictionary

mo80

Member
Jan 26, 2022
8
1
3
US
cPanel Access Level
Root Administrator
On my cPanel, Many tables are shown as table doesn't exist in engine, Please assist me over that.
I try many things but not able to understand this, PFA.

Many websites has same engine error.

Error Log


2022-03-11 4:22:46 10832 [ERROR] InnoDB: Operating system error number 17 in a file operation.
2022-03-11 4:22:46 10832 [ERROR] InnoDB: Error number 17 means 'File exists'
2022-03-11 4:22:46 10832 [Note] InnoDB: Some operating system error numbers are described at Operating System Error Codes
2022-03-11 4:22:46 10832 [Note] InnoDB: The file './arcrockery_wp681/ahc_settings.ibd' already exists though thecorresponding table did not exist in the InnoDB data dictionary. You can resolve the problem by removing the file.
2022-03-11 4:22:46 10832 [ERROR] InnoDB: Cannot create file './arcrockery_wp681/ahc_settings.ibd'
2022-03-11 4:23:01 11485 [ERROR] InnoDB: Operating system error number 17 in a file operation.
2022-03-11 4:23:01 11485 [ERROR] InnoDB: Error number 17 means 'File exists'
2022-03-11 4:23:01 11485 [Note] InnoDB: Some operating system error numbers are described at Operating System Error Codes
2022-03-11 4:23:01 11485 [Note] InnoDB: The file './arcrockery_wp681/ahc_settings.ibd' already exists though thecorresponding table did not exist in the InnoDB data dictionary. You can resolve the problem by remo
 

hmaddy

Well-Known Member
May 6, 2020
268
30
28
Chennai
cPanel Access Level
Root Administrator
mv /var/lib/mysql/arcrockery_wp681/ahc_settings.ibd /var/lib/mysql/arcrockery_wp681/ahc_settings.ibd.bak
rm /var/lib/mysql/arcrockery_wp681/ahc_settings.ibd
 

cPanelWilliam

Administrator
Staff member
Mar 13, 2018
90
13
83
Houston
cPanel Access Level
Root Administrator
Hey there! I agree with @hmaddy , moving aside the /var/lib/mysql/arcrockery_wp681/ahc_settings.ibd file may allow you to work around the error, but I would recommend ensuring you have full MySQL database backups before performing any changes. If the issue still persists, you may need to perform InnoDB corruption repair. We have written the following article to guide you through the process that I'll include below:

InnoDB Corruption Repair Guide