禅道使用
3416

操作较多,运行四五天后出现保存不了,重启服务后正常,是怎么回事呢?已解决 悬赏5积分

提问者古游 答案数1 阅读数3730 发表时间2016-03-30 09:34:01

我们操作的比较多,但也不是不停录入的那种,录入的文本内容比较多,5个用户。

运行四、五天左右就开始有些任务保存不了,有些也更新不了,但有些又可以。

我们主要操作的是项目模块,测试模块的好像没有遇到过这个问题。

重启服务后,运行正常,服务器没有任何其它发布的程序,只有禅道一个服务,禅道里面也没有任何的插件。

问一下这会是什么问题呢?谢谢。

禅道版本:8.1.3

安装包类型:源码包

操作系统:Windows 7

客户端浏览器:Chrome

设置备注
内容
答案列表
2016-03-30 09:34:19
找一下日志 zentao/tmp/log/php开头的今天的文件,看有什么错误记录。
😸
2016/03/30


17:11:48 PDO::exec(): in lib\dao\dao.class.php on line 527 when visiting task-create-18

17:11:48 PDO::exec(): MySQL server has gone away in lib\dao\dao.class.php on line 527 when visiting task-create-18

17:11:48 PDO::exec(): Error reading result set's header in lib\dao\dao.class.php on line 527 when visiting task-create-18

17:11:48 ERROR: SQLSTATE[HY000]: General error: 2006 MySQL server has gone awayThe sql is: INSERT INTO `zt_task` SET `module` = '1319',`assignedTo` = '',`type` = 'discuss',`name` = '候选人面试流程图',`desc` = '',`pri` = '0',`estimate` = '0',`estStarted` = '0000-00-00',`deadline` = '0000-00-00',`mailto` = '',`project` = '18',`left` = '0',`story` = '0',`status` = 'wait',`openedBy` = 'Yuangq',`openedDate` = '2016-03-28 17:11:46',`statusCustom` = '1' in lib\dao\dao.class.php on line 531, last called by module\task\model.php on line 56 through function exec.
in framework\router.class.php on line 1576 when visiting task-create-18

17:13:07 PDO::exec(): in lib\dao\dao.class.php on line 527 when visiting task-create-18

17:13:07 PDO::exec(): MySQL server has gone away in lib\dao\dao.class.php on line 527 when visiting task-create-18

17:13:07 PDO::exec(): Error reading result set's header in lib\dao\dao.class.php on line 527 when visiting task-create-18

17:13:07 ERROR: SQLSTATE[HY000]: General error: 2006 MySQL server has gone awayThe sql is: INSERT INTO `zt_task` SET `module` = '1319',`assignedTo` = '',`type` = 'discuss',`name` = '候选人面试流程图',`desc` = '',`pri` = '0',`estimate` = '0',`estStarted` = '0000-00-00',`deadline` = '0000-00-00',`mailto` = '',`project` = '18',`left` = '0',`story` = '0',`status` = 'wait',`openedBy` = 'Yuangq',`openedDate` = '2016-03-28 17:13:05',`statusCustom` = '1' in lib\dao\dao.class.php on line 531, last called by module\task\model.php on line 56 through function exec.
in framework\router.class.php on line 1576 when visiting task-create-18


日志记录的是这些,请问是什么问题呢?
2016/03/30
提示mysql服务已经停止,找一下mysql的日志,看有什么记录。
😸
2016/05/04
3月31日升级了系统到8.1.3,现在已经用了1个多月,中间还是出现了这个问题,重启服务又好了,到今天已经重启3次了,日志上面,看不懂是什么问题,麻烦帮我看看是怎么回事呢?谢谢。

16:45:30 task 4 executed,
command: moduleName=svn&methodName=run.
return : .
output : 2016-05-04 16:45:30 begin repo 1
2016-05-04 16:45:30 start from revision 0
Some error occers:
The command is C:\xampp\silksvn\svn.exe --non-interactive --username --password --no-auth-cache log -r 0:HEAD -v --xml
the svn logs is

16:45:30 task 5 executed,
command: moduleName=git&methodName=run.
return : .
output : 2016-05-04 16:45:30 begin repo 1
You must set the git client file.

16:45:30 task 7 executed,
command: moduleName=mail&methodName=asyncSend.
return : .
output : OK

16:50:30 task 4 executed,
command: moduleName=svn&methodName=run.
return : .
output : 2016-05-04 16:50:30 begin repo 1
2016-05-04 16:50:30 start from revision 0
Some error occers:
The command is C:\xampp\silksvn\svn.exe --non-interactive --username --password --no-auth-cache log -r 0:HEAD -v --xml
the svn logs is

16:50:30 task 5 executed,
command: moduleName=git&methodName=run.
return : .
output : 2016-05-04 16:50:30 begin repo 1
You must set the git client file.

16:50:30 task 7 executed,
command: moduleName=mail&methodName=asyncSend.
return : .
output : OK

16:55:30 task 4 executed,
command: moduleName=svn&methodName=run.
return : .
output : 2016-05-04 16:55:30 begin repo 1
2016-05-04 16:55:30 start from revision 0
Some error occers:
The command is C:\xampp\silksvn\svn.exe --non-interactive --username --password --no-auth-cache log -r 0:HEAD -v --xml
the svn logs is

16:55:30 task 5 executed,
command: moduleName=git&methodName=run.
return : .
output : 2016-05-04 16:55:30 begin repo 1
You must set the git client file.

16:55:30 task 7 executed,
command: moduleName=mail&methodName=asyncSend.
return : .
output : OK

17:00:30 task 4 executed,
command: moduleName=svn&methodName=run.
return : .
output : 2016-05-04 17:00:30 begin repo 1
2016-05-04 17:00:30 start from revision 0
Some error occers:
The command is C:\xampp\silksvn\svn.exe --non-interactive --username --password --no-auth-cache log -r 0:HEAD -v --xml
the svn logs is

17:00:30 task 5 executed,
command: moduleName=git&methodName=run.
return : .
output : 2016-05-04 17:00:31 begin repo 1
You must set the git client file.

17:00:30 task 7 executed,
command: moduleName=mail&methodName=asyncSend.
return : .
output : OK

17:05:28 task 4 executed,
command: moduleName=svn&methodName=run.
return : .
output : 2016-05-04 17:05:28 begin repo 1
2016-05-04 17:05:28 start from revision 0
Some error occers:
The command is C:\xampp\silksvn\svn.exe --non-interactive --username --password --no-auth-cache log -r 0:HEAD -v --xml
the svn logs is

17:05:28 task 5 executed,
command: moduleName=git&methodName=run.
return : .
output : 2016-05-04 17:05:28 begin repo 1
You must set the git client file.

17:05:28 task 7 executed,
command: moduleName=mail&methodName=asyncSend.
return : .
output : OK

17:10:28 task 4 executed,
command: moduleName=svn&methodName=run.
return : .
output : 2016-05-04 17:10:28 begin repo 1
2016-05-04 17:10:28 start from revision 0
Some error occers:
The command is C:\xampp\silksvn\svn.exe --non-interactive --username --password --no-auth-cache log -r 0:HEAD -v --xml
the svn logs is

17:10:28 task 5 executed,
command: moduleName=git&methodName=run.
return : .
output : 2016-05-04 17:10:28 begin repo 1
You must set the git client file.

17:10:28 task 7 executed,
command: moduleName=mail&methodName=asyncSend.
return : .
output : OK

17:15:28 task 4 executed,
command: moduleName=svn&methodName=run.
return : .
output : 2016-05-04 17:15:28 begin repo 1
2016-05-04 17:15:28 start from revision 0
Some error occers:
The command is C:\xampp\silksvn\svn.exe --non-interactive --username --password --no-auth-cache log -r 0:HEAD -v --xml
the svn logs is

17:15:28 task 5 executed,
command: moduleName=git&methodName=run.
return : .
output : 2016-05-04 17:15:28 begin repo 1
You must set the git client file.

17:15:28 task 7 executed,
command: moduleName=mail&methodName=asyncSend.
return : .
output : OK

2016/05/04
这些都是php关于 svn 和git的报错,找找 mysql的日志,看看为什么停止服务。
😸
2016/05/06
这是mysql的日志,mysql_error.err


160428 10:29:26 [Note] Plugin 'FEDERATED' is disabled.
160428 10:29:26 [Note] Plugin 'InnoDB' is disabled.
160428 10:29:26 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
160428 10:29:26 [Note] - '0.0.0.0' resolves to '0.0.0.0';
160428 10:29:26 [Note] Server socket created on IP: '0.0.0.0'.
160428 10:29:26 [Note] Event Scheduler: Loaded 0 events
160428 10:29:26 [Note] mysqlzt: ready for connections.
Version: '5.5.32' socket: '' port: 3306 MySQL Community Server (GPL)
160428 10:29:43 [Warning] IP address '218.244.254.49' could not be resolved: 不知道这样的主机。
160428 12:00:03 [Warning] IP address '14.145.252.108' could not be resolved: 不知道这样的主机。
160428 12:00:03 [Warning] IP address '14.145.252.108' could not be resolved: 不知道这样的主机。
160428 12:00:03 [Warning] IP address '14.145.252.108' could not be resolved: 不知道这样的主机。
160428 12:00:03 [Warning] IP address '14.145.252.108' could not be resolved: 不知道这样的主机。
160428 20:42:07 [Warning] IP address '120.24.251.13' could not be resolved: 不知道这样的主机。
160429 3:35:00 [Warning] IP address '58.221.46.247' could not be resolved: 不知道这样的主机。
160429 7:15:56 [Warning] IP address '58.221.44.205' could not be resolved: 不知道这样的主机。
160429 9:39:37 [Warning] IP address '117.65.248.16' could not be resolved: 不知道这样的主机。
160429 10:27:25 [Warning] IP address '119.10.55.151' could not be resolved: 不知道这样的主机。
160429 10:44:37 [Warning] IP address '223.243.94.158' could not be resolved: 不知道这样的主机。
160429 15:41:10 [Warning] IP address '121.42.180.106' could not be resolved: 不知道这样的主机。
160430 2:16:39 [Warning] IP address '114.55.54.103' could not be resolved: 不知道这样的主机。
160430 2:16:39 [Warning] IP address '114.55.54.103' could not be resolved: 不知道这样的主机。
160430 13:45:08 [Warning] IP address '119.10.52.135' could not be resolved: 不知道这样的主机。
160430 20:53:08 [Warning] IP address '117.65.249.36' could not be resolved: 不知道这样的主机。
160430 22:08:12 [Warning] IP address '223.243.85.129' could not be resolved: 不知道这样的主机。
160501 0:45:03 [Warning] IP address '120.26.211.148' could not be resolved: 不知道这样的主机。
160501 9:01:46 [Warning] IP address '123.56.65.139' could not be resolved: 不知道这样的主机。
160502 4:04:34 [Warning] IP address '58.221.46.246' could not be resolved: 不知道这样的主机。
160502 5:56:13 [Warning] IP address '222.186.56.21' could not be resolved: 不知道这样的主机。
160502 8:39:12 [Warning] IP address '221.122.83.63' could not be resolved: 不知道这样的主机。
160502 16:24:10 [Warning] IP address '120.25.103.140' could not be resolved: 不知道这样的主机。
160502 23:19:01 [Warning] IP address '58.221.58.191' could not be resolved: 不知道这样的主机。
160503 9:53:47 [Warning] IP address '14.145.253.222' could not be resolved: 不知道这样的主机。
160503 20:31:14 [Warning] IP address '220.231.203.94' could not be resolved: 不知道这样的主机。
160504 11:59:52 [Warning] IP address '14.145.253.9' could not be resolved: 不知道这样的主机。
160504 11:59:52 [Warning] IP address '14.145.253.9' could not be resolved: 不知道这样的主机。
160504 11:59:53 [Warning] IP address '14.145.253.9' could not be resolved: 不知道这样的主机。
160504 11:59:54 [Warning] IP address '14.145.253.9' could not be resolved: 不知道这样的主机。
160504 11:59:55 [Warning] IP address '14.145.253.9' could not be resolved: 不知道这样的主机。
160504 11:59:57 [Warning] IP address '14.145.253.9' could not be resolved: 不知道这样的主机。
160504 17:00:45 [Note] mysqlzt: Normal shutdown

160504 17:00:45 [Note] Event Scheduler: Purging the queue. 0 events
160504 17:00:45 [Note] mysqlzt: Shutdown complete

160504 17:01:02 [Note] Plugin 'FEDERATED' is disabled.
160504 17:01:02 [Note] Plugin 'InnoDB' is disabled.
160504 17:01:02 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
160504 17:01:02 [Note] - '0.0.0.0' resolves to '0.0.0.0';
160504 17:01:02 [Note] Server socket created on IP: '0.0.0.0'.
160504 17:01:02 [Note] Event Scheduler: Loaded 0 events
160504 17:01:02 [Note] mysqlzt: ready for connections.
Version: '5.5.32' socket: '' port: 3306 MySQL Community Server (GPL)
160504 18:38:57 [Warning] IP address '218.244.254.49' could not be resolved: 不知道这样的主机。
160504 21:32:48 [Warning] IP address '121.41.31.49' could not be resolved: 不知道这样的主机。
160504 21:32:48 [Warning] IP address '121.41.31.49' could not be resolved: 不知道这样的主机。
160505 11:59:53 [Warning] IP address '14.145.253.9' could not be resolved: 不知道这样的主机。
160505 11:59:53 [Warning] IP address '14.145.253.9' could not be resolved: 不知道这样的主机。
160505 11:59:53 [Warning] IP address '14.145.253.9' could not be resolved: 不知道这样的主机。
160505 11:59:53 [Warning] IP address '14.145.253.9' could not be resolved: 不知道这样的主机。
160505 11:59:54 [Warning] IP address '14.145.253.9' could not be resolved: 不知道这样的主机。
160505 11:59:56 [Warning] IP address '14.145.253.9' could not be resolved: 不知道这样的主机。
160505 13:48:57 [Note] Hostname 'unassigned.psychz.net' does not resolve to '23.91.1.42'.
160505 13:48:57 [Note] Hostname 'unassigned.psychz.net' has the following IP addresses:
160505 13:48:57 [Note] - 199.15.112.8

160505 15:58:26 [Warning] IP address '112.124.112.135' could not be resolved: 不知道这样的主机。
160505 15:58:27 [Warning] IP address '112.124.112.135' could not be resolved: 不知道这样的主机。
160506 1:27:38 [Warning] IP address '58.221.72.223' could not be resolved: 不知道这样的主机。
160506 10:09:07 [Warning] IP address '42.96.173.217' could not be resolved: 不知道这样的主机。
160506 10:09:07 [Warning] IP address '42.96.173.217' could not be resolved: 不知道这样的主机。
160506 10:33:57 [Note] mysqlzt: Normal shutdown

160506 10:33:57 [Note] Event Scheduler: Purging the queue. 0 events
160506 10:33:57 [Note] mysqlzt: Shutdown complete

160506 10:34:59 [Note] Plugin 'FEDERATED' is disabled.
160506 10:34:59 [Note] Plugin 'InnoDB' is disabled.
160506 10:34:59 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
160506 10:34:59 [Note] - '0.0.0.0' resolves to '0.0.0.0';
160506 10:34:59 [Note] Server socket created on IP: '0.0.0.0'.
160506 10:35:00 [Note] Event Scheduler: Loaded 0 events
160506 10:35:00 [Note] mysqlzt: ready for connections.
Version: '5.5.32' socket: '' port: 3306 MySQL Community Server (GPL)
160506 10:38:56 [Warning] IP address '42.96.173.217' could not be resolved: 不知道这样的主机。
160506 10:38:56 [Warning] IP address '42.96.173.217' could not be resolved: 不知道这样的主机。
🍟
2016/05/06
你的机器上有很多个IP地址吗?你可以试着修改下mysql的配置文件,监听其中的一个ip地址试试。这个错误也很奇怪,我们还是第一次遇到。:)
或者你可以试着下载下xampp完整的安装包,然后安装下禅道源码试试。
🍟
2016/05/06
http://www.cnblogs.com/digdeep/p/4906423.html 网上搜索了下,参考下。
联系我们
联系人
魏中显/高级客户经理
电话(微信)
18561939726
QQ号码
1746749398
联系邮箱
weizhongxian@chandao.com
返回顶部
魏中显
高级客户经理
18561939726
1746749398
统一服务热线 4006-8899-23
我要提问提问有任何问题,您都可以在这里提问。 问题反馈反馈点击这里,让我们聆听您的建议与反馈。