Table './tsar/cpu_1' is marked as crashed and should be repaired
来源:互联网 发布:三亚克洛伊婚纱照 知乎 编辑:程序博客网 时间:2024/05/22 12:22
今天由于服务器磁盘满了,导致设备上的服务挂掉了,之前是有短信告警的,就在前几天用完了短信,由于上级指示不再使用短信告警,只用邮件,怪我一般不看邮件(每次看都有几千条未读)
好了 在删除一些没用的文件腾出磁盘,重启mysql,服务。
在查看服务是出现了以下错误日志:
cpu.insertTsarData error=PreparedStatementCallback; uncategorized SQLException for SQL [insert into `cpu_1` values(?,?,?,?,?,?,?,?,?,?,?,?,?)]; SQL state [HY000]; error code [145]; Table './tsar/cpu_1' is marked as crashed and should be repaired; nested exception is java.sql.SQLException: Table './tsar/cpu_1' is marked as crashed and should be repaired看意思应该是表坏了,网上搜了一下,发现myisamchk可以解决
# myisamchk -c -r /var/lib/mysql/tsar/cpu_1.MYI tsar:库名
执行命令 修复成功。
重启服务 一切正常。
特此标记 装软件或者服务时 要看磁盘大小 装在合适的盘下。
0 0
- Table './tsar/cpu_1' is marked as crashed and should be repaired
- Table 'table_name' is marked as crashed and should be repaired
- Table 'xxxxxxx' is marked as crashed and should be repaired
- Table ‘xxx’ is marked as crashed and should be repaired ...
- linux Table is marked as crashed and should be repaired
- Table '.\tablename' is marked as crashed and should be repaired
- Table 'user_xxxxx' is marked as crashed and should be repaired
- Table is marked as crashed and should be repaired
- 修复 Table marked as crashed and should be repaired
- Table xxxis marked as crashed and should be repaired
- 表 is marked as crashed and should be repaired
- mysql错误:is marked as crashed and should be repaired
- is marked as crashed and should be repaired
- mysql错误is marked as crashed and should be repaired
- 解决“is marked as crashed and should be repaired”
- repair table `site_user`,#1194 – Table is marked as crashed and should be repaired错误修复
- Table 'this_' is marked as crashed and should be repaired (MYSQL数据错误解决)
- mysql:Table 'xxxxx' is marked as crashed and should be repaired
- 在localStorage中存储对象数组并读取
- ibatis传入表名查询
- js timestamp与datetime之间的相互转换
- hdu 4862 Jump 【最小费用最大流】好题
- iOS开发中,对请求数据出现<null>的一些简单处理
- Table './tsar/cpu_1' is marked as crashed and should be repaired
- 如何快速学习一门新技术
- 计算机常用英语词汇
- Windows下单机安装Spark开发环境
- 在lips追加拣配数量
- 开通博客
- 法院诉讼费标准是什么,如何收取诉讼费
- 关于iObjects动态图层硬件加速的性能对比
- Android 6.0 指纹识别功能详细分析