免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 3497 | 回复: 4

[服务应用] [ERROR] 1 client is using or hasn't closed the table properly [复制链接]

论坛徽章:
0
发表于 2012-12-07 09:08 |显示全部楼层
mysql服务器出现了load值过高,内存使用率也很高,查看下原因,mysql 错误日志报出了一大堆错误,但之后我也没去做任何处理,又恢复正常了,第二天又出现同一问题了,请大家来帮忙看下这问题。
121207  3:00:06 [ERROR] /app/mysql/bin/mysqld: Table './resource/t_driver_rom' is marked as crashed and should be repaired
121207  3:00:06 [Warning] Checking table:   './resource/t_driver_rom'
121207  3:00:06 [ERROR] 1 client is using or hasn't closed the table properly
121207  3:00:06 [ERROR] /app/mysql/bin/mysqld: Table './resource/t_driver_mobile_leak' is marked as crashed and should be repaired
121207  3:00:06 [Warning] Checking table:   './resource/t_driver_mobile_leak'
121207  3:00:06 [ERROR] 1 client is using or hasn't closed the table properly
121207  3:00:07 [ERROR] /app/mysql/bin/mysqld: Table './resource/t_android_info' is marked as crashed and should be repaired
121207  3:00:07 [Warning] Checking table:   './resource/t_android_info'
121207  3:00:07 [Warning] Recovering table: './resource/t_android_info'
121207  3:00:08 [ERROR] /app/mysql/bin/mysqld: Table './resource/SoftContent' is marked as crashed and should be repaired
121207  3:00:08 [Warning] Checking table:   './resource/SoftContent'
121207  3:00:08 [Warning] Recovering table: './resource/SoftContent'
121207  3:00:10 [ERROR] /app/mysql/bin/mysqld: Table './resource/SoftAdviser' is marked as crashed and should be repaired
121207  3:00:10 [Warning] Checking table:   './resource/SoftAdviser'
121207  3:00:10 [Warning] Recovering table: './resource/SoftAdviser'
121207  3:00:10 [ERROR] /app/mysql/bin/mysqld: Table './resource/GameInfo' is marked as crashed and should be repaired
121207  3:00:10 [Warning] Checking table:   './resource/GameInfo'
121207  3:00:10 [Warning] Recovering table: './resource/GameInfo'
121207  3:00:11 [ERROR] /app/mysql/bin/mysqld: Table './resource/GameAdapt' is marked as crashed and should be repaired
121207  3:00:11 [Warning] Checking table:   './resource/GameAdapt'
121207  3:00:13 [ERROR] /app/mysql/bin/mysqld: Table './resource/t_search_keyword' is marked as crashed and should be repaired
121207  3:00:13 [Warning] Checking table:   './resource/t_search_keyword'
121207  3:00:13 [ERROR] 1 client is using or hasn't closed the table properly
121207  3:00:13 [ERROR] /app/mysql/bin/mysqld: Table './resource/ArticleInfo' is marked as crashed and should be repaired
121207  3:00:13 [Warning] Checking table:   './resource/ArticleInfo'
121207  3:00:13 [ERROR] 1 client is using or hasn't closed the table properly
121207  3:00:14 [ERROR] /app/mysql/bin/mysqld: Table './resource/t_net_game_info' is marked as crashed and should be repaired
121207  3:00:14 [Warning] Checking table:   './resource/t_net_game_info'
121207  3:00:14 [ERROR] 1 client is using or hasn't closed the table properly
121207  3:00:14 [ERROR] /app/mysql/bin/mysqld: Table './resource/softcompanys' is marked as crashed and should be repaired
121207  3:00:14 [Warning] Checking table:   './resource/softcompanys'

论坛徽章:
381
CU十二周年纪念徽章
日期:2014-01-04 22:46:58CU大牛徽章
日期:2013-03-13 15:32:35CU大牛徽章
日期:2013-03-13 15:38:15CU大牛徽章
日期:2013-03-13 15:38:52CU大牛徽章
日期:2013-03-14 14:08:55CU大牛徽章
日期:2013-04-17 11:17:19CU大牛徽章
日期:2013-04-17 11:17:32CU大牛徽章
日期:2013-04-17 11:17:37CU大牛徽章
日期:2013-04-17 11:17:42CU大牛徽章
日期:2013-04-17 11:17:47CU大牛徽章
日期:2013-04-17 11:17:52CU大牛徽章
日期:2013-04-17 11:17:56
发表于 2012-12-07 09:16 |显示全部楼层
数据表有问题了,mysql应该有工具,你检查下吧

论坛徽章:
0
发表于 2012-12-07 10:34 |显示全部楼层
那工具是值什么?

论坛徽章:
381
CU十二周年纪念徽章
日期:2014-01-04 22:46:58CU大牛徽章
日期:2013-03-13 15:32:35CU大牛徽章
日期:2013-03-13 15:38:15CU大牛徽章
日期:2013-03-13 15:38:52CU大牛徽章
日期:2013-03-14 14:08:55CU大牛徽章
日期:2013-04-17 11:17:19CU大牛徽章
日期:2013-04-17 11:17:32CU大牛徽章
日期:2013-04-17 11:17:37CU大牛徽章
日期:2013-04-17 11:17:42CU大牛徽章
日期:2013-04-17 11:17:47CU大牛徽章
日期:2013-04-17 11:17:52CU大牛徽章
日期:2013-04-17 11:17:56
发表于 2012-12-07 11:19 |显示全部楼层
本帖最后由 chenyx 于 2012-12-07 11:23 编辑

不知道你的数据库引擎是 MyISAM还是innodb, MyISAM的话,可以用myisamchk来修复数据表

论坛徽章:
0
发表于 2012-12-10 09:01 |显示全部楼层
我的是myisam数据引擎的,我修复试试看,多谢你的指点。
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

DTCC2020中国数据库技术大会

【架构革新 高效可控】2020年12月21日-23日第十一届中国数据库技术大会将在北京隆重召开。

大会设置2大主会场,20+技术专场,将邀请超百位行业专家,重点围绕数据架构、AI与大数据、传统企业数据库实践和国产开源数据库等内容展开分享和探讨,为广大数据领域从业人士提供一场年度盛会和交流平台。

http://dtcc.it168.com


大会官网>>
  

北京盛拓优讯信息技术有限公司. 版权所有 16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122
中国互联网协会会员  联系我们:huangweiwei@it168.com
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP