MySQL Forums
Forum List  »  InnoDB

how to recover the lost innodb table due to inode full
Posted by: Justin Xu
Date: May 13, 2013 04:34AM

Hi ,
the OS is solaris , today the file system inode was full , so the Mysql error happened. and one table's ibd file lost .
The error log is below.

130513 15:43:00 [ERROR] /data1/local/mysql-5.5.27-solaris10-x86_64/bin/mysqld: Sort aborted: Can't create/write to file '/usr/local/mysql5527/data/MYjsl9bl' (Errcode: 28)
130513 15:43:01 InnoDB: cannot calculate statistics for table mydb55/bustab_201305
InnoDB: because the .ibd file is missing. For help, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html

130513 15:43:01 InnoDB: Error:
InnoDB: MySQL is trying to use a table handle but the .ibd file for
InnoDB: table mydb55/bustab_201305 does not exist.
InnoDB: Have you deleted the .ibd file from the database directory under
InnoDB: the MySQL datadir, or have you used DISCARD TABLESPACE?
InnoDB: Look from
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
InnoDB: how you can resolve the problem.
130513 15:43:01 [ERROR] /data1/local/mysql-5.5.27-solaris10-x86_64/bin/mysqld: Got error -1 from storage engine
130513 15:43:01 [ERROR] /data1/local/mysql-5.5.27-solaris10-x86_64/bin/mysqld: Sort aborted: Got error -1 from storage engine
130513 15:43:13 [ERROR] /data1/local/mysql-5.5.27-solaris10-x86_64/bin/mysqld: Sort aborted: Can't create/write to file '/usr/local/mysql5527/data/MYksl9bl' (Errcode: 28)
130513 15:43:13 [ERROR] /data1/local/mysql-5.5.27-solaris10-x86_64/bin/mysqld: Sort aborted: Can't create/write to file '/usr/local/mysql5527/data/MYlsl9bl' (Errcode: 28)

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
how to recover the lost innodb table due to inode full
3066
May 13, 2013 04:34AM


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.