已解决 禅道登录报错

一、开源版本点击登录报错信息如下:

  15:44:33 ERROR: SQLSTATE[HY000] [2002] Connection refused in framework/base/router.class.php on line 2173, last called by framework/base/router.class.php on line 2124 through function connectByPDO.
in framework/base/router.class.php on line 2224 when visiting 

二、linux后台提示报错

三、mysql_error.log  报错信息如下

2020-03-25 18:19:12 0 [Note] Using unique option prefix 'innodb-locks' is error-prone and can break in the future. Please use the full name 'innodb-locks-unsafe-for-binlog' instead.

2020-03-25 18:19:12 0 [Note] Using unique option prefix 'innodb-cmp' is error-prone and can break in the future. Please use the full name 'innodb-cmp-per-index-enabled' instead.

2020-03-25 18:19:12 0 [Note] Using unique option prefix 'innodb-cmp-per-index' is error-prone and can break in the future. Please use the full name 'innodb-cmp-per-index-enabled' instead.

2020-03-25 18:19:12 0 [Note] Plugin 'InnoDB' is disabled.

2020-03-25 18:19:12 0 [Note] Using unique option prefix 'innodb-sys-tables' is error-prone and can break in the future. Please use the full name 'innodb-sys-tablestats' instead.

2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.

2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_CMPMEM' is disabled.

2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.

2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.

2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.

2020-03-25 18:19:12 0 [Note] Using unique option prefix 'innodb-buffer-page' is error-prone and can break in the future. Please use the full name 'innodb-buffer-page-lru' instead.

2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.

2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.

2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.

2020-03-25 18:19:12 0 [Note] Plugin 'FEEDBACK' is disabled.

2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.

2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.

2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.

2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.

2020-03-25 18:19:12 0 [Note] Using unique option prefix 'innodb-sys-foreign' is error-prone and can break in the future. Please use the full name 'innodb-sys-foreign-cols' instead.

2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.

2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.

2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.

2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_TRX' is disabled.

2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.

2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.

2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_METRICS' is disabled.

2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.

2020-03-25 18:19:12 0 [Warning] /opt/zbox/run/mysql/mysqld: unknown variable 'loose-innodb-ft-inserted=0'

2020-03-25 18:19:12 0 [Note] Server socket created on IP: '0.0.0.0'.

2020-03-25 18:19:12 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1286: Unknown storage engine 'InnoDB'

2020-03-25 18:19:12 0 [Note] Reading of all Master_info entries succeded

2020-03-25 18:19:12 0 [Note] Added new Master_info '' to hash table

2020-03-25 18:19:12 0 [Note] /opt/zbox/run/mysql/mysqld: ready for connections.

Version: '10.3.13-MariaDB'  socket: '/opt/zbox/tmp/mysql/mysql.sock'  port: 3307  Source distribution

2020-03-25 18:23:19 16 [ERROR] mysqld: Table './zentao/zt_im_message' is marked as crashed and should be repaired

2020-03-25 18:23:19 16 [Warning] Checking table:   './zentao/zt_im_message'

2020-03-25 18:23:19 16 [ERROR] mysqld: Table './zentao/zt_im_messagestatus' is marked as crashed and should be repaired

2020-03-25 18:23:19 16 [Warning] Checking table:   './zentao/zt_im_messagestatus'

2020-03-25 18:26:50 21 [ERROR] mysqld: Table './zentao/zt_doccontent' is marked as crashed and should be repaired

2020-03-25 18:26:50 21 [Warning] Checking table:   './zentao/zt_doccontent'



禅道版本 12.2 Linux安装包
操作系统 CentOS
客户端浏览器 Chrome

提问者: 依诚 悬赏:5 日期: 2020-04-07 15:48:23 答案:1 点击:1883

获取技术支持

QQ: 电话:
设置备注
答案列表
2020/04/07

目前点击登录按钮报错是由于mysql服务没有正常启动。目前报错日志中的最新日期是3月25日,请确认一下服务器的时间是否正确,以及是否有今天4月7日的报错日志。

目前3月25日的报错日志显示,数据库中的zt_im_message,zt_im_messagestatus,zt_doccontent这3张表被损坏,需要修复一下。可以使用浏览器访问这个网址:禅道服务器IP:apache端口/zentao/checktable.php,按页面提示修复数据库表试一下。

如果服务器有日期更新的报错日志,或者访问网页修复表后仍然无法成功启动数据库,可以添加页面上方QQ,邀请进群,方便进一步排查问题。


2020/04/07
目前日志文件没有最新的信息,最近才发现这个问题~
2020/04/08
禅道服务器IP:apache端口/zentao/checktable.php, 这个文件没有提示怎么修复数据库呀?请问有案例么?
2020/04/08
可以添加一下页面上方的QQ,邀请进群,方便截图进一步排查问题。