InnoDB: error in sec index entry update
来源:互联网 发布:淘宝商品拍摄价格 编辑:程序博客网 时间:2024/05/22 08:10
MySQL的.eer错误日志中报了个错误,如下:
InnoDB: error in sec index entry update in
InnoDB: index `***idx` of table `***db`.`***tbl`
InnoDB: tuple DATA TUPLE: 2 fields;
0: SQL NULL;
1: len 4; hex 003a4b99; asc :K ;;
InnoDB: record PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: SQL NULL;
1: len 4; hex 003a4174; asc :At;;
TRANSACTION 5B0D26, ACTIVE 0 sec, process no 13587, OS thread id 1239374144 updating or deleting
mysql tables in use 1, locked 1
6 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 3
MySQL thread id 9487, query id 43404284 192.168.1.1 ***user Updating
update ***tbl set ***column1=*** where ***column2=***
InnoDB: Submit a detailed bug report to http://bugs.mysql.com
对提示的***tbl表进行了检查:
mysql>check table ***tbl;
+-------------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------------------+-------+----------+----------+
| ***db.***tbl | check | error | Corrupt |
+-------------------------+-------+----------+----------+
发现原来是表损坏了,很奇怪,表才建了不久,就出现了损坏,而且之前进行过一次optimize对表优化,难道是这个引起的,原因实在是搞不明白了,只能重建表解决该问题:
alter table ***tbl engine=innodb;
注意啊,大表重建可能需要较长时间和双倍的空间。
参考:
http://bugs.mysql.com/bug.php?id=17937
http://bugs.mysql.com/bug.php?id=37364
- InnoDB: error in sec index entry update
- svn提示 update Error converting entry in directory
- B+Tree index structures in InnoDB
- Unknown column 's.score' in 'having clause' 0.00020 sec error
- 【原】Cannot find entry file index.ios.js [index.android.js] in any of the roots
- InnoDB: Error in opening ./ibdata1 问题重现
- <Chapter 2>Fast Index Creation in the InnoDB Storage Engine
- eclipse dynamic web error——tomcat server not start with in 45 sec
- svn: Error converting entry in directory ‘.’ to UTF-8
- Webpack错误解决(一):ERROR in Entry module not found
- Error:null value in entry: aaptFriendlyManifestOutputFile=null
- Error:null value in entry: incrementalFolder=null
- svn: Error converting entry in directory ‘.’ to UTF-8
- 解决Error:null value in entry: incrementalFolder=null
- Error:null value in entry: incrementalFolder=null
- Webpack错误解决(一):ERROR in Entry module not found
- 关于Error:null value in entry: aaptFriendlyManifestOutputFile=null
- ERROR in Entry module not found: Error: Can't resolve 'babel-loader' in.........
- zz搜索引擎重复网页发现技术分析
- OpenGL之gluLookAt函数
- 高级文件格式逆向分析
- Ubuntu zgegblog十个漂亮主题
- COM
- InnoDB: error in sec index entry update
- Struts 1 Validator框架学习笔记
- 忆龙2009:详解SSH的工作流程
- excel 星期和周计算
- 找程序员做老公的十大好处
- 虚拟机下linux上网设置指南
- InstallAnywhere的應用2009
- shell(一)
- 禁用文本框右键菜单