错误信息:
120129 14:17:23 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120129 14:17:23 InnoDB: Database was not shut down normally!InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Error: tried to read 16384 bytes at offset 0 11403264.
InnoDB: Was only able to read -1.
120129 14:13:44 InnoDB: Operating system error number 5 in a file operation.
InnoDB: Error number 5 means 'Input/output error'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html
InnoDB: File operation call: 'read'.
InnoDB: Cannot continue operation.
120129 14:17:23 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120129 14:17:23 InnoDB: Database was not shut down normally!InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Error: tried to read 16384 bytes at offset 0 11403264.
InnoDB: Was only able to read -1.
120129 14:13:44 InnoDB: Operating system error number 5 in a file operation.
InnoDB: Error number 5 means 'Input/output error'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html
InnoDB: File operation call: 'read'.
InnoDB: Cannot continue operation.
解决方案 »
- mysql如何自动定时备份,如何增量双机同步数据。
- 求教!!id int primary key auto_increment是什么意思?
- MYSQL语法排错!
- 在MYSQL 中,如何判断一个varchar字段内容的长度。比如sqlserver中的len(字段名)?
- 紧急求助:Mysql查询ResultSet为空的问题
- java.sql.SQLException: Column 'gp_id' not found.
- group by 的缺点
- windows下如何实现mysql的自动备份?
- 为什么在mysql中select不能给字段重新命名??
- mysql 查询
- mysql_row[]取值转换问题,急!
- MYSQL5.1这段sql执行死机
最怕文件损坏,ibdata文件还存在,磁盘未满,能正常读写。
这个是导致该问题的唯一原因吗?
貌似是fopen的时候返回-1了。文件还能正常读写?