MySQL论坛

 找回密码
 注册
搜索
热搜: 活动 交友 discuz
查看: 2158|回复: 0

[其他] InnoDB: File operation call: 'read' returned OS error 0.

[复制链接]

该用户从未签到

发表于 2013-5-3 10:57:58 | 显示全部楼层 |阅读模式
2013-05-03 08:16:26 3700 [Note] Plugin 'FEDERATED' is disabled.
2013-05-03 08:16:26 3700 [Warning] option 'innodb-autoextend-increment': unsigned value 67108864 adjusted to 1000
2013-05-03 08:16:27 8f8 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2013-05-03 08:16:27 3700 [Note] InnoDB: The InnoDB memory heap is disabled
2013-05-03 08:16:27 3700 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-05-03 08:16:27 3700 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-05-03 08:16:27 3700 [Note] InnoDB: Not using CPU crc32 instructions
2013-05-03 08:16:27 3700 [Note] InnoDB: Initializing buffer pool, size = 46.0M
2013-05-03 08:16:27 3700 [Note] InnoDB: Completed initialization of buffer pool
2013-05-03 08:16:27 3700 [Note] InnoDB: Highest supported file format is Barracuda.
2013-05-03 08:16:27 3700 [Note] InnoDB: Log scan progressed past the checkpoint lsn 230116767
2013-05-03 08:16:27 3700 [Note] InnoDB: Database was not shutdown normally!
2013-05-03 08:16:27 3700 [Note] InnoDB: Starting crash recovery.
2013-05-03 08:16:27 3700 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-05-03 08:16:27 8f8  InnoDB: File operation call: 'read' returned OS error 0.
2013-05-03 08:16:27 8f8  InnoDB: Cannot continue operation.




早上数据库报这个错误。。帮我看看是怎么个回事,啃爹啊。昨天还好好的。。


我继续看了上面的日志;
------------
Trx id counter 458335
Purge done for trx's n:o < 458334 undo n:o < 0 state: running but idle
History list length 2151
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 68670, OS thread handle 0x85c, query id 203361942 192.168.4.17 todojam2013 creating table
CREATE TABLE tmpSendSms (
FnBltPTMsgMTRecorderID int
)
---TRANSACTION 458334, ACTIVE 526 sec creating table
MySQL thread id 68670, OS thread handle 0x85c, query id 203361942 192.168.4.17 todojam2013 creating table
CREATE TABLE tmpSendSms (
FnBltPTMsgMTRecorderID int
)
--------

我尝试把tmpSendSms这张表删除,再重新启动mysql服务,mysql启动了。我猜想,my.ini 默认表配置是:default-storage-engine=INNODB;创建的tmpSendSms表则用的是innodb引擎,导致问题出现。大家帮我看看为什么会出现这样问题,是不是my.ini中需要对innodb进行什么配置。
您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|小黑屋|手机版|Archiver|中文MySQL ( 京ICP 备06008873号 )

GMT+8, 2017-3-26 15:38 , Processed in 0.081061 second(s), 23 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表