MySQL Forums
Forum List  »  InnoDB

ERROR - Number of indexes inside innodb are different to number of indexes in the MySQL ???
Posted by: Aleksandar Petrovic
Date: August 11, 2011 04:57PM

Hi Guys,

First time poster, long time searcher of these forums :) I have an error I can't find anything about on the Internet, and more importantly, I have no idea what it means.

First up, my machine is a linux rhel5 VM x86_64 running mysql 5.5.14 (not rpm installed, tar install)

I keep seeing the following in the MySQL err log:

110812 2:27:07 [ERROR] Table mydb/tblCalc contains 3 indexes inside InnoDB, which is different from the number of indexes 2 defined in the MySQL
110812 2:27:28 [ERROR] Table mydb/tblCalc contains 4 indexes inside InnoDB, which is different from the number of indexes 3 defined in the MySQL
110812 2:27:28 [ERROR] Table mydb/tblCalc contains 4 indexes inside InnoDB, which is different from the number of indexes 3 defined in the MySQL
110812 2:27:53 [ERROR] Table mydb/tblCalc contains 5 indexes inside InnoDB, which is different from the number of indexes 4 defined in the MySQL
110812 2:27:53 [ERROR] Table mydb/tblCalc contains 5 indexes inside InnoDB, which is different from the number of indexes 4 defined in the MySQL
110812 2:28:17 [ERROR] Table mydb/tblCalc contains 6 indexes inside InnoDB, which is different from the number of indexes 5 defined in the MySQL
110812 2:28:17 [ERROR] Table mydb/tblCalc contains 6 indexes inside InnoDB, which is different from the number of indexes 5 defined in the MySQL

Regards,
Aleks

Options: ReplyQuote


Subject
Views
Written By
Posted
ERROR - Number of indexes inside innodb are different to number of indexes in the MySQL ???
13370
August 11, 2011 04:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.