MySQL中 Table '*****' is marked as crashed and should be repaired 错误解决

错误信息如下：

com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLException: Table 'beeeye_res' is marked as crashed and should be repaired
at com.jfinal.plugin.activerecord.DbPro.update(DbPro.java:313)
at com.jfinal.plugin.activerecord.Db.update(Db.java:213)
at com.lpdata.beeneedle.thrift.PolicyAuditHandle.osresAudit(PolicyAuditHandle.java:1626)
at com.lpdata.beeneedle.thrift.bean.PolicyAudit$Processor$osresAudit.getResult(PolicyAudit.java:3220)
at com.lpdata.beeneedle.thrift.bean.PolicyAudit$Processor$osresAudit.getResult(PolicyAudit.java:1)
at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
at org.apache.thrift.server.AbstractNonblockingServer$FrameBuffer.invoke(AbstractNonblockingServer.java:518)
at org.apache.thrift.server.Invocation.run(Invocation.java:18)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: Table 'beeeye_res' is marked as crashed and should be repaired
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:963)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009)
at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5098)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:2723)
at com.alibaba.druid.filter.FilterAdapter.preparedStatement_executeUpdate(FilterAdapter.java:1069)
at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeUpdate(FilterEventAdapter.java:491)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:2721)
at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeUpdate(PreparedStatementProxyImpl.java:158)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:253)
at com.jfinal.plugin.activerecord.DbPro.update(DbPro.java:294)
at com.jfinal.plugin.activerecord.DbPro.update(DbPro.java:311)

... 11 more

解决方法如下：

进入到MySQL安装的bin目录下：

1、myisamchk --recover --quick  ../data/database/tablename

2、myisamchk --recover  ../data/database/tablename

3、myisamchk --safe-recover  ../data/database/tablename

然后重启MySQL数据库就可以解决错误了

附MySQL重启方法：

1、使用 service 启动：service mysqld restart

2、使用 mysqld 脚本启动：/etc/inint.d/mysqld restart