3.2.1版试任务提交引起apache崩溃问题

回帖

回帖数 10

阅读数 3370

发表时间 2012-08-21 12:02:27

💐

段誉

玄清 | 等级2道童

楼主

bug1:程序员开始任务-保存，系统失去响应，apache崩溃，日志显示[6716] EACCELERATOR: PHP crashed on opline 32 of query() at E:\ComsenzEXP\wwwroot\pms\lib\dao\dao.class.php:497，修改php.ini参数eaccelerator.enable="0"，问题依旧，不是每次重现。

bug2:程序员开始任务-保存，此时任务变为进行中，可选操作为：完成；程序员完成任务-保存，此时任务变为已完成，可选操作为：开始、关闭、激活；建议此状态取消开始操作，因为逻辑上已完成任务重新开始应该是激活操作。

2012-08-21 12:02:43 段誉最后编辑

回帖

10个回复

🍟

春哥

幽灵 | 等级7春哥

沙发

eaccelerator不是很稳定，建议卸载。

2012-08-21 12:42:12 王春生回帖

回帖

💐

段誉

玄清 | 等级2道童

板凳

日志里查到崩溃之前执行到这句，很奇怪t2.version和t2.status字段哪里冒出来的？

ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't2.version' in 'where clause'<p>

The sql is: SELECT * FROM `zt_task` wHeRe project = '65' AND deleted = '0' AND t2.version > storyVersion AND t2.status = 'active' AND `zt_task`.company = '1' oRdEr bY statusCustom,id desc</p>

in E:\\ComsenzEXP\\wwwroot\\pms\\lib\\dao\\dao.class.php on line 502,

request:/pms/www/index.php, last called by \pms\\lib\\dao\\dao.class.php on 604 through function query., referer: /pms/www/index.php?m=project&f=task&t=html&projectID=65

2012-08-21 15:36:15 段誉回帖

回帖

💐

段誉

玄清 | 等级2道童

bug统计时也引起了系统崩溃，日志显示SQL语句出错，错误是WHERE 1 = 1AND `project`中1和and之间无空格，应该是程序拼装sql少了空格吧

具体日志如下。

ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`project`IN ('65','66','67','68','69','108','109','138','153','165','169','171',' at line 1<p>The sql is: SELECT COUNT(*) AS recTotal FROM `zt_bug` WHERE 1 = 1AND `project`IN ('65','66','67','68','69','108','109','138','153','165','169','171','174','178','181','185','186','192','193','199','203','206','7','14','120','134','1','3','8','10','42','43','44','55','102','104','105','110','111','112','123','126','127','129','131','142','145','150','154','156','162','164','167','172','0') AND deleted = '0' AND `zt_bug`.company = '1' </p>

2012-08-21 17:41:21 段誉最后编辑 2012-08-21 17:41:21 段誉回帖

回帖

🍟

春哥

幽灵 | 等级7春哥

很奇怪的。如果有错的话，应该早就发现了才对。是每次都重现吗？你试试把那个加速器卸载。

2012-08-22 08:08:16 王春生回帖

回帖

💐

段誉

玄清 | 等级2道童

把加速器卸载了，今天用下来没有再因此崩溃过。