table did not exist in the InnoDB data dictionary

[mo80]

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]

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]

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