|
|
版本： 通达OA2013 增强版最新
在使用新建工作时,默认进新建工作的任务视图中，此时流程无法加载，过一会儿会连续弹出两个空白对话框，所有电脑都是同样的反应；php_error.log报错：
[31-Dec-2016 11:08:11] PHP Fatal error: Out of memory (allocated 32768000) (tried to allocate 35 bytes) in D:\MYOA\webroot\inc\workflow\inc\workflow.cache.php on line 203
[31-Dec-2016 11:08:11] PHP Fatal error: Out of memory (allocated 20971520) (tried to allocate 2 bytes) in D:\MYOA\webroot\inc\workflow\inc\workflow.cache.php on line 56
[31-Dec-2016 11:08:27] PHP Fatal error: Out of memory (allocated 49807360) (tried to allocate 8 bytes) in D:\MYOA\webroot\inc\cache\cache_files.php on line 28
[31-Dec-2016 11:08:58] PHP Fatal error: Out of memory (allocated 44302336) (tried to allocate 51 bytes) in D:\MYOA\webroot\inc\cache\cache_files.php on line 28
[31-Dec-2016 11:08:58] PHP Fatal error: Out of memory (allocated 174850048) (tried to allocate 40 bytes) in D:\MYOA\webroot\inc\cache\cache_files.php on line 28
[31-Dec-2016 11:08:58] PHP Fatal error: Out of memory (allocated 786432) (tried to allocate 134618 bytes) in D:\MYOA\webroot\inc\td_core.php on line 12
[31-Dec-2016 11:10:05] PHP Fatal error: Out of memory (allocated 4980736) (tried to allocate 374829 bytes) in D:\MYOA\webroot\inc\utility_file.php on line 308934968
[31-Dec-2016 11:10:05] PHP Fatal error: Out of memory (allocated 4194304) (tried to allocate 258859 bytes) in D:\MYOA\webroot\inc\phpqrcode.php on line 1968131008
[31-Dec-2016 11:10:05] PHP Fatal error: Out of memory (allocated 6553600) (tried to allocate 15 bytes) in D:\MYOA\webroot\inc\workflow\monitor\myworklistdb.class.php on line -1926799624
[31-Dec-2016 11:10:05] PHP Fatal error: Out of memory (allocated 5505024) (tried to allocate 7104 bytes) in D:\MYOA\webroot\inc\phpqrcode.php on line 118227075
[31-Dec-2016 11:10:05] PHP Fatal error: Out of memory (allocated 4456448) (tried to allocate 35 bytes) in D:\MYOA\webroot\inc\phpqrcode.php on line 0
[31-Dec-2016 11:10:07] PHP Fatal error: Out of memory (allocated 29622272) (tried to allocate 256 bytes) in D:\MYOA\webroot\inc\cache\cache_files.php on line 28
[31-Dec-2016 11:10:07] PHP Fatal error: Out of memory (allocated 164626432) (tried to allocate 44 bytes) in D:\MYOA\webroot\inc\cache\cache_files.php on line 28
[31-Dec-2016 11:12:33] PHP Warning: session_destroy() [<a href='function.session-destroy'>function.session-destroy</a>]: Session object destruction failed in D:\MYOA\webroot\inc\auth.inc.php on line 28
[31-Dec-2016 11:14:02] PHP Fatal error: Out of memory (allocated 786432) (tried to allocate 316704 bytes) in D:\MYOA\webroot\inc\utility_all.php on line 0
[31-Dec-2016 11:14:02] PHP Fatal error: Out of memory (allocated 82575360) (tried to allocate 44 bytes) in D:\MYOA\webroot\inc\cache\cache_files.php on line 28
[31-Dec-2016 11:14:02] PHP Fatal error: Out of memory (allocated 71303168) (tried to allocate 49 bytes) in D:\MYOA\webroot\inc\cache\cache_files.php on line 28
[31-Dec-2016 11:14:02] PHP Fatal error: Out of memory (allocated 62914560) (tried to allocate 16 bytes) in D:\MYOA\webroot\inc\cache\cache_files.php on line 28
[31-Dec-2016 11:14:02] PHP Fatal error: Out of memory (allocated 156499968) (tried to allocate 43 bytes) in D:\MYOA\webroot\inc\cache\cache_files.php on line 28
[31-Dec-2016 11:14:02] PHP Fatal error: Out of memory (allocated 133169152) (tried to allocate 45 bytes) in D:\MYOA\webroot\inc\cache\cache_files.php on line 28
[31-Dec-2016 11:15:06] PHP Fatal error: Out of memory (allocated 786432) (tried to allocate 374829 bytes) in D:\MYOA\webroot\inc\utility_file.php on line 0
[31-Dec-2016 11:15:06] PHP Fatal error: Out of memory (allocated 3932160) (tried to allocate 3552 bytes) in D:\MYOA\webroot\inc\simple_html_dom.php on line 913730418
[31-Dec-2016 11:15:06] PHP Fatal error: Out of memory (allocated 4456448) (tried to allocate 23520 bytes) in D:\MYOA\webroot\inc\utility_cache.php on line 101449947
[31-Dec-2016 11:15:06] PHP Fatal error: Out of memory (allocated 65273856) (tried to allocate 45 bytes) in D:\MYOA\webroot\inc\cache\cache_files.php on line 28
[31-Dec-2016 11:15:06] PHP Fatal error: Out of memory (allocated 33030144) (tried to allocate 50 bytes) in D:\MYOA\webroot\inc\cache\cache_files.php on line 28
[31-Dec-2016 11:16:08] PHP Fatal error: Out of memory (allocated 3932160) (tried to allocate 172704 bytes) in D:\MYOA\webroot\inc\td_core.php on line -1802766426
[31-Dec-2016 11:16:08] PHP Fatal error: Out of memory (allocated 84148224) (tried to allocate 45 bytes) in D:\MYOA\webroot\inc\workflow\inc\workflow.cache.php on line 290
[31-Dec-2016 11:16:08] PHP Fatal error: Out of memory (allocated 4980736) (tried to allocate 258859 bytes) in D:\MYOA\webroot\inc\phpqrcode.php on line 1551134575
[31-Dec-2016 11:16:08] PHP Fatal error: Out of memory (allocated 524288) (tried to allocate 578496 bytes) in D:\MYOA\webroot\inc\js_lang.php on line -1802766426
[31-Dec-2016 11:16:14] PHP Fatal error: Out of memory (allocated 69992448) (tried to allocate 16 bytes) in D:\MYOA\webroot\inc\cache\cache_files.php on line 28
[31-Dec-2016 11:16:14] PHP Fatal error: Out of memory (allocated 75759616) (tried to allocate 50 bytes) in D:\MYOA\webroot\inc\cache\cache_files.php on line 28
[31-Dec-2016 11:16:14] PHP Fatal error: Out of memory (allocated 86507520) (tried to allocate 47 bytes) in D:\MYOA\webroot\inc\cache\cache_files.php on line 28
slow.log：
D:\MYOA\mysql5\bin\mysqld.exe, Version: 5.5.25-enterprise-commercial-advanced-log (MySQL Enterprise Server - Advanced Edition (Commercial)). started with:
TCP Port: 3336, Named Pipe: (null)
Time Id Command Argument
# Time: 161226 4:01:10
# User@Host: root[root] @ [127.0.0.1]
# Query_time: 56.703125 Lock_time: 0.000000 Rows_sent: 10429 Rows_examined: 43871
use td_oa;
SET timestamp=1482696070;
SELECT * from USER,USER_PRIV where DEPT_ID=0 and USER.USER_PRIV=USER_PRIV.USER_PRIV order by PRIV_NO,USER_NO,USER_NAME;
# Time: 161226 4:01:43
# User@Host: root[root] @ [127.0.0.1]
# Query_time: 71.359375 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 976198
SET timestamp=1482696103;
SELECT COUNT(FLOW_RUN_LOG.`LOG_ID`) as total_number FROM FLOW_RUN_LOG LEFT JOIN FLOW_RUN ON FLOW_RUN.RUN_ID=FLOW_RUN_LOG.RUN_ID WHERE 1 AND ( FLOW_RUN.BEGIN_USER = '杨祥吉' OR FLOW_RUN.FLOW_ID IN (294,295,18,35,43,81,95,1322,74,88,93,1190,1192,1783,1191,160,1321,1318,3315,196,200,1286,202,1278,208,214,3314,4265,1775,1774,248,249,250,251,3317,3318,254,255,256,257,268,269,275,1255,1254,299,303,360,309,311,312,313,314,317,316,318,320,321,323,324,325,326,327,329,330,331,332,333,336,337,338,339,347,349,456,353,356,363,1249,367,1272,372,373,376,377,380,381,382,385,386,388,389,451,393,397,398,400,401,402,405,406,407,409,410,413,414,417,418,420,421,422,,) OR FLOW_RUN.RUN_ID IN ( SELECT FLOW_RUN_PRCS.RUN_ID FROM FLOW_RUN_PRCS WHERE FLOW_RUN_PRCS.USER_ID = '杨祥吉' ) OR FIND_IN_SET('杨祥吉',FLOW_RUN.FOCUS_USER) OR FIND_IN_SET('杨祥吉',FLOW_RUN.VIEW_USER));
# Time: 161226 4:12:40
# User@Host: root[root] @ [127.0.0.1]
# Query_time: 25.875000 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 106267
SET timestamp=1482696760;
SELECT COUNT(FLOW_RUN.RUN_ID) as TOTAL_NUMBER FROM FLOW_RUN WHERE FLOW_RUN.DEL_FLAG = 0 AND FLOW_RUN.BEGIN_TIME <= '2016-12-26 23:59:59' AND FLOW_RUN.RUN_ID IN ( SELECT FLOW_RUN_PRCS.RUN_ID FROM FLOW_RUN_PRCS WHERE FLOW_RUN_PRCS.USER_ID = '杨祥吉' );
D:\MYOA\mysql5\bin\mysqld.exe, Version: 5.5.25-enterprise-commercial-advanced-log (MySQL Enterprise Server - Advanced Edition (Commercial)). started with:
TCP Port: 3336, Named Pipe: (null)
Time Id Command Argument
# Time: 161226 7:28:04
# User@Host: root[root] @ [127.0.0.1]
# Query_time: 24.640625 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 974446
use td_oa;
SET timestamp=1482708484;
select
A.RUN_ID,
A.PRCS_ID,
A.FLOW_PRCS,
A.CREATE_TIME,
A.PRCS_TIME,
A.DELIVER_TIME,
A.PRCS_FLAG,
A.USER_ID,
A.TIME_OUT as TIME_OUT_RUN,
A.ID AS PRCS_KEY_ID,
B.FLOW_ID,
B.RUN_NAME
from
FLOW_RUN_PRCS A
inner join FLOW_RUN B on A.RUN_ID=B.RUN_ID
where A.TIME_OUT_FLAG = '1' and B.DEL_FLAG != '1' and A.PRCS_FLAG in('1','2') and A.USER_ID = '丁宝洋'
ORDER BY A.RUN_ID DESC limit 0,15;
PS:新建工作时，使用列表视图，可以正常加载流程
|
|
发表于 2017-1-6 15:57:33
发表于 2017-1-6 17:35:24
楼主