Not able to drop or recreate table in Percona MySQL versions 5.1.63

MySQL & MariaDB Other MySQL® Questions
1

There is a .ibd file corresponding to this table in datadir with out .frm file. We are using 5.1.63 Percona Server (GPL) version.

I have tried the solution given in [URL=“MySQL :: MySQL 8.0 Reference Manual :: 15.21.4 Troubleshooting InnoDB Data Dictionary Operations”]http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting-datadict.html[/URL=“http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting-datadict.html”]. But the problem still exists.

We are seeing the below error messages from error log.

innodb parameters used are listed below.

INNODB Parameters defined in my.cnf

If anyone of you have experienced similar issues, can you please share the solution?

2

Hi,

Have you tried with last option suggested in that document?