linux 服务器重启后,mysql数据库被损坏了,禅道内相应的内容账号信息都不存在了已解决 悬赏5积分
版本是11.6.1,我们重启了禅道部署的linux服务器后,原有账号提示都登录错误,然后用admin管理员账号登录后发现用户信息只有最开始的几个了,然后看了logs/mysql_error.log日志,发现了很多数据表都报错如下:
2021-12-20 7:21:57 20 [ERROR] mysqld: Table './zentao/zt_usergroup' is marked as crashed and should be repaired
2021-12-20 7:21:57 20 [Warning] Checking table: './zentao/zt_usergroup'
2021-12-20 7:21:57 20 [ERROR] mysqld: Table './zentao/zt_userview' is marked as crashed and should be repaired
2021-12-20 7:21:57 20 [Warning] Checking table: './zentao/zt_userview'
2021-12-20 7:21:58 20 [ERROR] mysqld: Table './zentao/zt_action' is marked as crashed and should be repaired
2021-12-20 7:21:58 20 [Warning] Checking table: './zentao/zt_action'
2021-12-20 7:21:58 22 [ERROR] mysqld: Table './zentao/zt_block' is marked as crashed and should be repaired
2021-12-20 7:21:58 22 [Warning] Checking table: './zentao/zt_block'
2021-12-20 7:21:58 22 [ERROR] mysqld: Table './zentao/zt_task' is marked as crashed and should be repaired
2021-12-20 7:21:58 22 [Warning] Checking table: './zentao/zt_task'
2021-12-20 7:21:58 22 [ERROR] mysqld: Table './zentao/zt_bug' is marked as crashed and should be repaired
2021-12-20 7:21:58 22 [Warning] Checking table: './zentao/zt_bug'
2021-12-20 7:21:58 22 [ERROR] mysqld: Table './zentao/zt_project' is marked as crashed and should be repaired
禅道版本:11.6.1
安装包类型:源码包
操作系统:CentOS
客户端浏览器:Chrome
🍟 您好,报错信息提示数据库表已受损,您可以尝试访问网页:http://禅道服务的ip: 端口/zentao/checktable.php网址,按照提示修复下数据库表再看下。
回复
|