which is more than the configured time (StuckThreadMaxTime) of "600" seconds. St
一个导出数据的功能把数据导出到excel中weblogic 报
####<2013-12-11 上午09时36分46秒 CST> <Error> <WebLogicServer> <localhost> <AdminServer> <[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1386725806626> <BEA-000337> <[STUCK] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "621" seconds working on the request "weblogic.servlet.internal.ServletRequestImpl@1fbdc5a[
GET /survey/manager/export.jsp?sid=21&questionnaireid=36&action=DEM0 HTTP/1.1
Accept: text/html, application/xhtml+xml, */*
Referer: http://192.168.248.107/survey/manager/countlist.jsp?sid=21&cid=0
Accept-Language: zh-CN
User-Agent: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)
Accept-Encoding: gzip, deflate
Cookie: WEBUSER_ID=webuser_id1372038678508r2219; Hm_lvt_c0f83d11c5318938a003c0a00dcded64=1385519329,1386040962,1386645361,1386668444; djytheatretype=%E8%88%9E%E8%B9%88_2012.10.21%2C%E8%88%9E%E8%B9%88_2013.11.02%2C%E6%AD%8C%E5%89%A7_2013.10.20%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E6%88%8F%E5%89%A7_2013.09.14%2C%E6%88%8F%E5%89%A7_2013.08.31%2C%E6%88%8F%E5%89%A7_2013.08.31%2C%E6%88%8F%E5%89%A7_2013.09.14%2C%E8%88%9E%E8%B9%88_2013.08.31%2C%E6%88%8F%E5%89%A7_2013.08.31%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E6%AD%8C%E5%89%A7_2013.10.20%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E9%9F%B3%E4%B9%90_2013.09.05%2C%E9%9F%B3%E4%B9%90_2013.08.31%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E9%9F%B3%E4%B9%90_2013.09.18%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2013.12.01%2C%E9%9F%B3%E4%B9%90_2013.09.30%2C%E9%9F%B3%E4%B9%90_2013.09.30%2C%E9%9F%B3%E4%B9%90_2013.09.30%2C%E9%9F%B3%E4%B9%90_2013.10.07%2C%E9%9F%B3%E4%B9%90_2013.10.07%2C%E9%9F%B3%E4%B9%90_2013.10.07%2C%E9%9F%B3%E4%B9%90_2013.10.07%2C%E9%9F%B3%E4%B9%90_2013.10.07%2C%E6%88%8F%E6%9B%B2_2013.10.07%2C_%2C%E9%9F%B3%E4%B9%90_2013.11.10%2C%E6%88%8F%E6%9B%B2_2014.03.12%2C%E6%88%8F%E6%9B%B2_2014.03.12%2C%E8%88%9E%E8%B9%88_2014.01.08%2C%E6%AD%8C%E5%89%A7_2014.03.17%2C%E6%88%8F%E5%89%A7_2014.02.03%2C%E9%9F%B3%E4%B9%90_2014.03.09%2C%E9%9F%B3%E4%B9%90_2014.01.09%2C%E8%88%9E%E8%B9%88_2014.02.04%2C%E6%AD%8C%E5%89%A7_2013.12.01%2C_2014.10.02%2C%E8%88%9E%E8%B9%88_2013.12.10%2C%E9%9F%B3%E4%B9%90_2014.03.05%2C%E9%9F%B3%E4%B9%90_2013.12.30%2C%E9%9F%B3%E4%B9%90_2013.12.30%2C%E8%88%9E%E8%B9%88_2013.12.27; looyu_id=9c9cea7ffe15c4ac10d621c1b6e95a5103_46802%3A92; JSESSIONID=cwn0Sn8CZrLp3T1LFBlRTY4DQGBcZnkkZCT4fPWvhdhPn2tkcQfY!-1639107784
Connection: Keep-Alive
Proxy-Client-IP: 192.168.23.109
X-Forwarded-For: 192.168.23.109
X-WebLogic-KeepAliveSecs: 30
X-WebLogic-Force-JVMID: -1639107784
]", which is more than the configured time (StuckThreadMaxTime) of "600" seconds. Stack trace:
java.net.SocketInputStream.socketRead0(Native Method)
java.net.SocketInputStream.read(SocketInputStream.java:129)
oracle.net.ns.Packet.receive(Packet.java:293)
oracle.net.ns.DataPacket.receive(DataPacket.java:92)
oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:174)
oracle.net.ns.NetInputStream.read(NetInputStream.java:119)
oracle.net.ns.NetInputStream.read(NetInputStream.java:94)
oracle.net.ns.NetInputStream.read(NetInputStream.java:79)
oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122)
oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:78)
oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1040)
oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1016)
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:589)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953)
oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:9273)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9373)
oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:211)
weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:210)
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:34)
org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2204)
org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2118)
org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2374)
org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:84)
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:951)
org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:109)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1086)
org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
ehm.db.DataHelper.getQuery(DataHelper.java:237)
ehm.db.DataHelper.getList(DataHelper.java:122)
ehm.web.survey.app.Export.getAnswer(Export.java:102)
ehm.web.survey.app.Export.getAnswer1(Export.java:317)
ehm.web.survey.app.Export.getReportnew(Export.java:262)
ehm.web.survey.app.Export.getPage(Export.java:72)
jsp_servlet._survey._manager.__export._jspService(__export.java:76)
weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.doIt(WebAppServletContext.java:3683)
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3650)
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2268)
weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174)
weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1446)
weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
> 请大侠们指教该如何解决! --------------------编程问答-------------------- --------------------编程问答-------------------- 请求超时?把数据量调小一下试试
补充:Java , Web 开发