Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

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

cdhanekucdhaneku EntrantCurrent User Role Beginner
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 Beginner
    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.