求大神告诉我这个错应该怎么解决！

0 0

求大神告诉我这个错应该怎么解决！5

<2013-7-6 上午06时23分51秒 CST> <Error> <WebLogicServer> <BEA-000337> <[STUCK] ExecuteThread: '9' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "653" seconds working on the request "weblogic.servlet.internal.ServletRequestImpl@1d437df[
POST *.do HTTP/1.0
Content-Type: text/xml; charset=utf-8
Accept: application/soap+xml, application/dime, multipart/related, text/*
User-Agent: Axis/1.4
Cache-Control: no-cache
Pragma: no-cache
SOAPAction: ""
Content-Length: 2400

]", 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)
com.ibm.db2.jcc.t4.ab.b(ab.java:195)
com.ibm.db2.jcc.t4.ab.c(ab.java:244)
com.ibm.db2.jcc.t4.ab.c(ab.java:355)
com.ibm.db2.jcc.t4.ab.v(ab.java:1140)
com.ibm.db2.jcc.t4.db.f(db.java:101)
com.ibm.db2.jcc.t4.t.f(t.java:87)
com.ibm.db2.jcc.t4.b.a(b.java:2549)
com.ibm.db2.jcc.a.uf.b(uf.java:54)
com.ibm.db2.jcc.a.xf.b(xf.java:191)
com.ibm.db2.jcc.a.p.l(p.java:550)
com.ibm.db2.jcc.a.p.h(p.java:307)
com.ibm.db2.jcc.t4.a.h(a.java:506)
com.ibm.db2.jcc.a.p.a(p.java:204)
com.ibm.db2.jcc.a.sl.e(sl.java:3187)
com.ibm.db2.jcc.a.sl.Ob(sl.java:569)
com.ibm.db2.jcc.a.sl.executeQuery(sl.java:543)
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
org.hibernate.loader.Loader.getResultSet(Loader.java:1808)
org.hibernate.loader.Loader.doQuery(Loader.java:697)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
org.hibernate.loader.Loader.doList(Loader.java:2228)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
org.hibernate.loader.Loader.list(Loader.java:2120)
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1596)
org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
org.springframework.orm.hibernate3.HibernateTemplate$35.doInHibernate(HibernateTemplate.java:979)
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367)
org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:969)
com.deliverik.framework.dao.hibernate.BaseHibernateDAOImpl.findByCriteria(SourceFile:584)
com.deliverik.infogovernor.svc.model.dao.WarningInfoDAOImpl.findByCond(WarningInfoDAOImpl.java:89)
com.deliverik.infogovernor.svc.bl.task.WarningInfoBLImpl.searchWarningInfo(WarningInfoBLImpl.java:84)
sun.reflect.GeneratedMethodAccessor292.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:299)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
$Proxy238.searchWarningInfo(Unknown Source)
*(*.java:1859)
sun.reflect.GeneratedMethodAccessor290.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3587)
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2200)
weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2106)
weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1428)
weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
>

问题补充：我想要知道怎么才能不让DB2再出这个错

目前发现好几个单表查询，都会出现这个问题。

Weblogic DB2

2013年7月08日 11:10

qw987412
25
0 0 1

1个答案按时间排序按投票排序

0 0

从字面意思来看是某一个请求时间太长，超过了服务器的超时时间600s，然后就超时了，在

com.deliverik.framework.dao.hibernate.BaseHibernateDAOImpl.findByCriteria(SourceFile:584) 
com.deliverik.infogovernor.svc.model.dao.WarningInfoDAOImpl.findByCond(WarningInfoDAOImpl.java:89) 
com.deliverik.infogovernor.svc.bl.task.WarningInfoBLImpl.searchWarningInfo(WarningInfoBLImpl.java:84)

，这些地方，仔细分析一下，看数据库那方面是否有持续时间比较长的查询

2013年7月08日 13:29