mysql问题--mysqld-nt.exe错误

chuting1 2012-11-02 04:34:00

用SQL语句
alter table cardbm add szarea varbinary(10) default '081';

执行数据库表更新时，提示mysqld-nt.exe 应用程序错误 0x0056022e指令引用的0x00000000内存，该内存不能为read。

同时mysql服务终止。

mysql数据库是正常的，用select * from cardbm 时正常。

...全文

443 14 打赏收藏转发到动态举报

写回复

用AI写文章

14 条回复

切换为时间正序

请发表友善的回复…

发表回复

chuting1 2012-11-07

打赏
举报

UP一下下 UP一下

chuting1 2012-11-06

打赏
举报

里面就一个库，16张表

chuting1 2012-11-06

打赏
举报

ibdata1文件大小为157M多点

ACMAIN_CHM 2012-11-06

打赏
举报

检查一下ibdata 文件的大小是多少？

WWWWA 2012-11-05

打赏
举报

Your database may be corrupt.
对，估计是非正常退出造成的

WWWWA 2012-11-05

打赏
举报

Your database may be corrupt.
对，估计是非正常退出造成的

chuting1 2012-11-05

打赏
举报

你的意思是，把数据库备份后，重新建库导入数据

WWWWA 2012-11-05

打赏
举报

从提示上看，数据库有问题了，用MYSQLDUMP备份再导入

chuting1 2012-11-05

打赏
举报

引用 3 楼 ACMAIN_CHM 的回复:

你的文件所有磁盘是否还有足够的剩余空间？

这和磁盘空间有关系吗，我的数据库文件保存在D盘的，空间还有30多G，C盘也是这样，毕竟是服务器

chuting1 2012-11-05

打赏
举报

数据库引擎是INNODB 错误日志： 121103 8:55:35 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... 121103 8:55:35 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 627956017. InnoDB: Doing recovery: scanned up to log sequence number 0 627956017 121103 8:55:35 InnoDB: Error: page 5 log sequence number 0 627971007 InnoDB: is in the future! Current system log sequence number 0 627956017. InnoDB: Your database may be corrupt. 121103 8:55:35 InnoDB: Error: page 6 log sequence number 0 627977075 InnoDB: is in the future! Current system log sequence number 0 627956017. InnoDB: Your database may be corrupt. 121103 8:55:35 InnoDB: Error: page 6755 log sequence number 0 627995894 InnoDB: is in the future! Current system log sequence number 0 627956017. InnoDB: Your database may be corrupt. 121103 8:55:35 InnoDB: Error: page 51 log sequence number 0 627978468 InnoDB: is in the future! Current system log sequence number 0 627956017. InnoDB: Your database may be corrupt. 121103 8:55:35 InnoDB: Error: page 0 log sequence number 0 627976313 InnoDB: is in the future! Current system log sequence number 0 627956017. InnoDB: Your database may be corrupt. 121103 8:55:35 InnoDB: Flushing modified pages from the buffer pool... 121103 8:55:35 InnoDB: Started; log sequence number 0 627956017 D:\MySQL\MySQL Server 4.1\bin\mysqld-nt: ready for connections. Version: '4.1.18-nt' socket: '' port: 3306 MySQL Community Edition (GPL)