使用一段时间后挂了已解决悬赏5积分

提问者大樟树答案数1 阅读数1036 发表时间2019-05-27 14:09:29

页面提示错误：

14:07:29 ERROR: SQLSTATE[HY000] [2002] Connection refused in /opt/zbox/app/zentao/framework/base/router.class.php on line 2164, last called by /opt/zbox/app/zentao/framework/base/router.class.php on line 2115 through function connectByPDO.
in /opt/zbox/app/zentao/framework/base/router.class.php on line 2215 when visiting

禅道版本：11.5.stable

安装包类型：源码包

操作系统：Ubuntu

客户端浏览器：Chrome

答案列表

🚢

王林 2019-05-27 15:08:32

ps -ef | grep mysql看下mysql服务还正常启动着吗？

/opt/zbox/logs下看下有mysql的日志吗？

有对mysql做过什么配置吗？

2条回复

🚌

大樟树 2019/05/27

mysql不能正常启动，mysql没改什么配置，用的默认配置，下面是查看mysql日志
ecuadmin@rd_ecu:/opt/zbox/logs$ cat mysql_error.log
2019-03-25 20:36:07 0 [Note] InnoDB: Using Linux native AIO
2019-03-25 20:36:07 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-03-25 20:36:07 0 [Note] InnoDB: Uses event mutexes
2019-03-25 20:36:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-03-25 20:36:07 0 [Note] InnoDB: Number of pools: 1
2019-03-25 20:36:07 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-03-25 20:36:07 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-03-25 20:36:07 0 [Note] InnoDB: Completed initialization of buffer pool
2019-03-25 20:36:07 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-03-25 20:36:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-03-25 20:36:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-03-25 20:36:07 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-03-25 20:36:07 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2019-03-25 20:36:07 0 [Note] InnoDB: 10.3.13 started; log sequence number 1630815; transaction id 21
2019-03-25 20:36:07 0 [Note] InnoDB: Loading buffer pool(s) from /opt/zbox/data/mysql/ib_buffer_pool
2019-03-25 20:36:07 0 [Note] InnoDB: Buffer pool(s) load completed at 190325 20:36:07
2019-03-25 20:36:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-03-25 20:36:07 0 [Note] Server socket created on IP: '127.0.0.1'.
2019-03-25 20:36:07 0 [Note] Reading of all Master_info entries succeded
2019-03-25 20:36:07 0 [Note] Added new Master_info '' to hash table
2019-03-25 20:36:07 0 [Note] /opt/zbox/run/mysql/mysqld: ready for connections.
Version: '10.3.13-MariaDB' socket: '/opt/zbox/tmp/mysql/mysql.sock' port: 3306 Source distribution
2019-03-25 20:36:11 0 [Note] /opt/zbox/run/mysql/mysqld (initiated by: unknown): Normal shutdown
2019-03-25 20:36:11 0 [Note] InnoDB: FTS optimize thread exiting.
2019-03-25 20:36:11 0 [Note] Event Scheduler: Purging the queue. 0 events
2019-03-25 20:36:11 0 [Note] InnoDB: Starting shutdown...
2019-03-25 20:36:11 0 [Note] InnoDB: Dumping buffer pool(s) to /opt/zbox/data/mysql/ib_buffer_pool
2019-03-25 20:36:11 0 [Note] InnoDB: Buffer pool(s) dump completed at 190325 20:36:11
2019-03-25 20:36:12 0 [Note] InnoDB: Shutdown completed; log sequence number 1630824; transaction id 22
2019-03-25 20:36:12 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-03-25 20:36:12 0 [Note] /opt/zbox/run/mysql/mysqld: Shutdown complete

🚢

王林 2019/05/28

把 /opt/zbox/data/mysql/ 下面的 ar* ib* mu* tc* 删除
然后再启动试一下呢

联系我们