mysql表修复

来源:互联网 发布:摄影布光 知乎 编辑:程序博客网 时间:2024/06/11 18:47

查看报错日志:

     org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute query; uncategorized SQLException for SQL []; SQL state [HY000]; error code [145]; Table './confluence/INDEXQUEUEENTRIES' is marked as crashed and should be repaired; nested exception is java.sql.SQLException: Table './confluence/INDEXQUEUEENTRIES' is marked as crashed and should be repaired]


解决方法:修复表


 ./myisamchk -c -r /usr/local/mysql/var/confluence/INDEXQUEUEENTRIES.MYI