Not the answer you need?
Register and ask your own question!

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

cdhanekucdhaneku EntrantCurrent User Role Participant
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 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?

Comments

  • niljoshiniljoshi MySQL Sage Inactive User Role Leader
    Hi,

    Have you tried with last option suggested in that document?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.