InnoDB:文件操作中的操作系统错误号23 [英] InnoDB: Operating system error number 23 in a file operation

问题描述

昨天，我的本地服务器硬盘崩溃，并在启动时使用了自动磁盘扫描程序.我当时不在办公室，所以我真的不知道发生了什么事.但是今天，当我们启动Server时，我们会得到

Yesterday, my local server HDD crashes and goes for automatic scandisk at start up. I was not in office so I really don't know what had happen. But today when we start Server we are getting

130523 10:49:36  InnoDB: Operating system error number 23 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'Windows aio'.

我尝试在C:上运行scandisk，它发现4条损坏的记录，但没有坏扇区或其他东西.数据库服务器大约有300个数据库，我不确定如何恢复它.有人建议删除日志文件并尝试设置

I try to run scandisk on C: and it found 4 corrupted records, but no bad sector or something. Database Server has around 300 Database, I Am not sure how to recover it. Someone suggest delete Log files and try to set

innodb_Force_recovery = 4 

我也尝试过，但是某些数据库不可用，当我尝试使用它们时使MySql崩溃.我不确定，因为重新加载300数据库不是一件容易的事.

I try that too, but some of database are unavailable and crash MySql when I try to use them. I am not sure as reloading 300 database is not an easy job.

如果这很重要，我将使用Windows 2008 Web Edition.

I am on Windows 2008 Web Edition if that matters.

推荐答案

听起来像是在Windows上:ENFILE错误基本上表明您有太多打开的文件.不太确定如何解决它:一般来说，它在512到2048之间在一个过程中.

Sounds like you're on Windows: the ENFILE error basically says you have too many open files. Not quite sure how exactly you get around it: in general it is somewhere between 512 and 2048 in a process.

建议可能将所有文件移出MySQL数据目录，并尝试一次一个地恢复它们.

Would suggest maybe moving all the files out of the MySQL data directory and trying to recover them one by one.

这篇关于InnoDB:文件操作中的操作系统错误号23的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！