MySQL Forums
Forum List  »  General

Re: MySQL/innodb database malfunctioning
Posted by: Keith Larson
Date: June 16, 2014 09:51PM

Check permissions on the .ibd file.
Did you move the file ?

If you set the lower_case_table_names back does it work?

The related info of log is below

2014-06-15 11:03:38 1be4 InnoDB: Error: table 'minecraft/users'
2014-06-15 11:03:47 8324 [ERROR] InnoDB: Failed to find tablespace for table '"minecraft"."users"' in the cache. Attempting to load the tablespace with space id 1.
2014-06-15 11:03:47 8324 [ERROR] InnoDB: Could not find a valid tablespace file for 'minecraft/users'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2014-06-15 11:03:47 8324 [Warning] InnoDB: Orphan table encountered during DROP DATABASE. This is possible if 'minecraft/users.frm' was lost.
2014-06-15 11:03:47 8324 [Warning] InnoDB: Missing minecraft/users.ibd file for table minecraft/users.
2014-06-15 11:10:30 1d90 InnoDB: Error: table 'minecraft/users'
2014-06-15 11:11:51 7212 [ERROR] InnoDB: Cannot create file '.\minecraft\users.ibd'
2014-06-15 11:11:51 7212 [ERROR] InnoDB: The file '.\minecraft\users.ibd' already exists though the corresponding table did not exist in the InnoDB data dictionary. Have you moved InnoDB .ibd files around without using the SQL commands DISCARD TABLESPACE and IMPORT TABLESPACE, or did mysqld crash in the middle of CREATE TABLE? You can resolve the problem by removing the file '.\minecraft\users.ibd' under the 'datadir' of MySQL.
2014-06-15 11:11:51 7212 [ERROR] InnoDB: Cannot create file '.\minecraft\users.ibd'
2014-06-15 11:11:51 7212 [ERROR] InnoDB: The file '.\minecraft\users.ibd' already exists though the corresponding table did not exist in the InnoDB data dictionary. Have you moved InnoDB .ibd files around without using the SQL commands DISCARD TABLESPACE and IMPORT TABLESPACE, or did mysqld crash in the middle of CREATE TABLE? You can resolve the problem by removing the file '.\minecraft\users.ibd' under the 'datadir' of MySQL.
2014-06-15 11:11:51 7212 [ERROR] InnoDB: Cannot create file '.\minecraft\users.ibd'
2014-06-15 11:11:51 7212 [ERROR] InnoDB: The file '.\minecraft\users.ibd' already exists though the corresponding table did not exist in the InnoDB data dictionary. Have you moved InnoDB .ibd files around without using the SQL commands DISCARD TABLESPACE and IMPORT TABLESPACE, or did mysqld crash in the middle of CREATE TABLE? You can resolve the problem by removing the file '.\minecraft\users.ibd' under the 'datadir' of MySQL.
2014-06-15 11:11:51 7212 [ERROR] InnoDB: Cannot create file '.\minecraft\users.ibd'
2014-06-15 11:11:51 7212 [ERROR] InnoDB: The file '.\minecraft\users.ibd' already exists though the corresponding table did not exist in the InnoDB data dictionary. Have you moved InnoDB .ibd files around without using the SQL commands DISCARD TABLESPACE and IMPORT TABLESPACE, or did mysqld crash in the middle of CREATE TABLE? You can resolve the problem by removing the file '.\minecraft\users.ibd' under the 'datadir' of MySQL.
2014-06-15 11:11:51 7212 [ERROR] InnoDB: Cannot create file '.\minecraft\users.ibd'
2014-06-15 11:11:51 7212 [ERROR] InnoDB: The file '.\minecraft\users.ibd' already exists though the corresponding table did not exist in the InnoDB data dictionary. Have you moved InnoDB .ibd files around without using the SQL commands DISCARD TABLESPACE and IMPORT TABLESPACE, or did mysqld crash in the middle of CREATE TABLE? You can resolve the problem by removing the file '.\minecraft\users.ibd' under the 'datadir' of MySQL.
2014-06-15 11:11:51 7212 [ERROR] InnoDB: Cannot create file '.\minecraft\users.ibd'
2014-06-15 11:11:51 7212 [ERROR] InnoDB: The file '.\minecraft\users.ibd' already exists though the corresponding table did not exist in the InnoDB data dictionary. Have you moved InnoDB .ibd files around without using the SQL commands DISCARD TABLESPACE and IMPORT TABLESPACE, or did mysqld crash in the middle of CREATE TABLE? You can resolve the problem by removing the file '.\minecraft\users.ibd' under the 'datadir' of MySQL.
2014-06-15 11:14:53 7212 [ERROR] InnoDB: Failed to find tablespace for table '"minecraft"."users"' in the cache. Attempting to load the tablespace with space id 1.
2014-06-15 11:14:53 7212 [ERROR] InnoDB: Could not find a valid tablespace file for 'minecraft/users'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2014-06-15 11:14:53 7212 [Warning] InnoDB: Orphan table encountered during DROP DATABASE. This is possible if 'minecraft/users.frm' was lost.
2014-06-15 11:14:53 7212 [Warning] InnoDB: Missing minecraft/users.ibd file for table minecraft/users.

Just trying to help....

http://anothermysqldba.blogspot.com

Options: ReplyQuote


Subject
Written By
Posted
Re: MySQL/innodb database malfunctioning
June 16, 2014 09:51PM


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.