table did not exist in the InnoDB data dictionary

mo80

• March 10, 2022 23:21

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

  • March 11, 2022 07:42

  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

  0
• 

  cPanelWilliam

  • March 11, 2022 17:22

  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:

  0

Please sign in to leave a comment.