系统集成中间件WAS

WAS提示:DSRA9110E: Connection is closed和Statement is closed问题

软件名称:websphereV6.1 网络部署版软件版本:Name                     IBM WebSphere Application Server - NDVersion                ...显示全部
软件名称:websphereV6.1 网络部署版
软件版本:
Name                     IBM WebSphere Application Server - ND
Version                  6.1.0.25
ID                         ND
Build Level              cf250922.06
Build Date               6/1/09
环境平台:
1)操作系统:AIX 5.3  64位
2)java版本:java version "1.5.0"
Java(TM) 2 Runtime Environment, Standard Edition (build pap64dev-20060511 (SR2))
IBM J9 VM (build 2.3, J2RE 1.5.0 IBM J9 2.3 AIX ppc64-64 j9vmap6423-20060504 (JI
T enabled)
J9VM - 20060501_06428_BHdSMr
JIT  - 20060428_1800_r8
GC   - 20060501_AA)
JCL  - 20060511a
3)6台机器配置:CPU16核 3.5Ghz 32GB内存
问题描述:
WAS提示:DSRA9110E: Connection is closed和DSRA9110E: Statement is closed。问题比较急,请各位专家指点。
webcontainer:线程非活动超时3500毫秒,
数据库连接池:连接超时180秒,非使用的超时1800秒,时效超时0秒。
WAS架构是:两台IHS做HA集群,4台应用服务器。DM安装在其中一台应用服务器上,服务总共是14个。
1服务器:DM+1Node+4个服务
2服务器:1Node+4个服务
3服务器:1Node+3个服务
4服务器:1Node+3个服务
具体信息:
2010-08-09 08:39:02 ERROR Transaction - Do release the connection from data source exception
com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is closed.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.runtimeXIfNotClosed(WSJdbcConnection.java:2657)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.setAutoCommit(WSJdbcConnection.java:2741)
at com.ecc.emp.jdbc.ConnectionHolder.releaseConnection(ConnectionHolder.java:64)
at com.ecc.emp.transaction.TransactionSynchronizer.removeTransaction(TransactionSynchronizer.java:155)
at com.ecc.emp.transaction.EMPTransactionManager.commit(EMPTransactionManager.java:131)
at com.ecc.emp.transaction.EMPTransactionManager.commit(EMPTransactionManager.java:144)
at com.yucheng.cmis.ad.mvc.ADRequestController.executeEMPLogic(Unknown Source)
at com.ecc.emp.web.servlet.mvc.EMPRequestController.executeTheFlow(EMPRequestController.java:487)
at com.ecc.emp.web.servlet.mvc.EMPRequestController.doRequest(EMPRequestController.java:307)
at com.ecc.emp.web.servlet.EMPRequestServlet.service(EMPRequestServlet.java:427)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1146)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1087)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)
at com.yucheng.cmis.wfi.ContextFilter.doFilter(ContextFilter.java:29)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ecc.emp.web.jsptags.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:44)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:837)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:680)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:588)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:481)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3507)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:269)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:815)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1466)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:122)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:196)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:751)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:881)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)


2010-08-26 17:39:24 ERROR EMPJDBC - Failed to SELECT records in tableModel [PrdRateStd] due to SQLException !
com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed.
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.runtimeXIfNotClosed(WSJdbcStatement.java:1664)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeQuery(WSJdbcStatement.java:911)
at com.ecc.emp.dbmodel.service.TableModelDAO.queryByCondition(TableModelDAO.java:730)
at com.ecc.emp.dbmodel.service.TableModelDAO.queryList(TableModelDAO.java:1483)
at com.ecc.emp.dbmodel.service.TableModelDAO.queryList(TableModelDAO.java:1473)
at com.yucheng.cmis.prd.prdbasicinfo.agent.PrdBasicinfoAgent.getBasicRateByTerm(PrdBasicinfoAgent.java:1544)
at com.yucheng.cmis.prd.prdbasicinfo.component.PrdBasicinfoComponet.getBasicRateByTerm(PrdBasicinfoComponet.java:674)
at com.yucheng.cmis.prdinterface.Prd4IqpInstance.getBasicRateByTerm(Prd4IqpInstance.java:343)
at com.yucheng.cmis.ctr.cont.imp.CtrContImpl.interfaceOfProcessWithLoanAppUnual(CtrContImpl.java:229)
at sun.reflect.GeneratedMethodAccessor206.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:86)
at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:230)
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:912)
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:756)
at org.codehaus.groovy.runtime.InvokerHelper.invokePojoMethod(InvokerHelper.java:738)
at org.codehaus.groovy.runtime.InvokerHelper.invokeMethod(InvokerHelper.java:726)
at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeMethodN(ScriptBytecodeAdapter.java:170)
at Script120.run(Script120.groovy:8)
at com.sun.script.groovy.GroovyScriptEngine.eval(GroovyScriptEngine.java:243)
at com.sun.script.groovy.GroovyScriptEngine.eval(GroovyScriptEngine.java:81)
at javax.script.AbstractScriptEngine.eval(AbstractScriptEngine.java:247)
at com.yucheng.cmis.wfi.event.handler.DymanicEmpHandler$1.process(DymanicEmpHandler.java:215)
at com.yucheng.cmis.wfi.CMISComponentFactoryBean$EMPRunner.run(CMISComponentFactoryBean.java:139)
at com.yucheng.cmis.wfi.event.handler.DymanicEmpHandler.afterEvent(DymanicEmpHandler.java:165)
at com.yuchengtech.cmis.bpm.provider.eventhandler.BizLogicEventHandler$1.handle(BizLogicEventHandler.java:124)
at com.yuchengtech.cmis.bpm.provider.eventhandler.BizLogicEventHandler$HandlerRunner.execute(BizLogicEventHandler.java:68)
at com.yuchengtech.cmis.bpm.provider.eventhandler.BizLogicEventHandler.afterEvent(BizLogicEventHandler.java:121)
at com.yuchengtech.cmis.bpm.core.WFIEventDispatcher.dispathEvent(WFIEventDispatcher.java:366)
at com.yuchengtech.cmis.bpm.core.WFIEventDispatcher.dispathCompleteProc(WFIEventDispatcher.java:55)
at com.yuchengtech.cmis.bpm.core.WFIEventDispatcher$$FastClassByCGLIB$$59da0af5.invoke()
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:113)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
at com.yuchengtech.cmis.bpm.core.WFIEventDispatcher$$EnhancerByCGLIB$$32792fc1.dispathCompleteProc()
at sun.reflect.GeneratedMethodAccessor187.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy2.completeProc(Unknown Source)
at com.yuchengtech.cmis.bpm.core.WFIActionImpl.submit(WFIActionImpl.java:256)
at sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy3.submit(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at com.yuchengtech.cmis.bpm.core.WFIProxyImpl.involkAction(WFIProxyImpl.java:62)
at com.yuchengtech.cmis.bpm.core.WFIControllerImpl.process(WFIControllerImpl.java:95)
at sun.reflect.GeneratedMethodAccessor92.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy6.process(Unknown Source)
at com.yucheng.cmis.wfi.WFIServlet.service(WFIServlet.java:245)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1146)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1087)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)
at com.ecc.emp.web.jsptags.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:44)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:837)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:680)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:588)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:481)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3507)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:269)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:815)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1466)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:122)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:196)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:751)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:881)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)

附件:

附件图标native_stderr.rar (66.09 KB)

收起
参与16

查看其它 15 个回答guansnow的回答

guansnowguansnow系统分析师科大讯飞
回复 15# zhwsh


    大神们不是说了嘛~~最好升级一下
系统集成 · 2014-10-21
浏览3930

回答者

guansnow
系统分析师科大讯飞
擅长领域: 中间件服务器前置系统

guansnow 最近回答过的问题

回答状态

  • 发布时间:2014-10-21
  • 关注会员:0 人
  • 回答浏览:3930
  • X社区推广