1 Reply Latest reply on Dec 11, 2013 4:36 AM by wdfink

DSCONFIG

johnrajuawpl Dec 11, 2013 2:17 AM

Getting below error frequently on JBoss AS 7.1.1. MAX connection pool for all 6 datasources set to 1000.

Is there a way to resolve this issue.

at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:137)

at sun.reflect.GeneratedMethodAccessor32.invoke(Unknown Source) [:1.7.0_45]

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) [rt.jar:1.7.0_45]

at java.lang.reflect.Method.invoke(Unknown Source) [rt.jar:1.7.0_45]

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319) [spring-aop-3.1.2.RELEASE.jar:3.1.2.RELEASE]

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196) [spring-aop-3.1.2.RELEASE.jar:3.1.2.RELEASE]

at com.sun.proxy.$Proxy55.getConnection(Unknown Source)

at com.awpl.dsui.db.DSDataBaseHelper.getConnection(DSDataBaseHelper.java:43) [ds-extension-toolkit-6.3.0-SNAPSHOT.jar:]

at com.awpl.ds.configuration.DatabaseServiceImpl.getActionVerb(DatabaseServiceImpl.java:2558) [ds-configservice-6.3.0-20131113.140812-3.jar:]

at com.awpl.dsui.userexits.utils.UserExitUtils.executePostDecision(UserExitUtils.java:790) [ds-extension-toolkit-6.3.0-SNAPSHOT.jar:]

at com.awpl.dsia.actions.SubmitAction.execute(SubmitAction.java:311) [classes:]

at com.awpl.dsia.actions.SubmitAction$$FastClassByCGLIB$$32d8a757.invoke(<generated>) [cglib-2.2.2.jar:]

at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) [cglib-2.2.2.jar:]

at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689) [spring-aop-3.1.2.RELEASE.jar:3.1.2.RELEASE]

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop-3.1.2.RELEASE.jar:3.1.2.RELEASE]

at com.awpl.dsui.audit.interceptor.DecisionAuditInterceptor.invoke(DecisionAuditInterceptor.java:138) [ds-processaudit-6.3.0-20131113.140915-3.jar:]

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.1.2.RELEASE.jar:3.1.2.RELEASE]

at com.awpl.dsia.service.RemoveSessionAttributesInterceptor.invoke(RemoveSessionAttributesInterceptor.java:82) [classes:]

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.1.2.RELEASE.jar:3.1.2.RELEASE]

at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622) [spring-aop-3.1.2.RELEASE.jar:3.1.2.RELEASE]

at com.awpl.dsia.actions.SubmitAction$$EnhancerByCGLIB$$f6817afa.execute(<generated>) [cglib-2.2.2.jar:]

at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:113) [spring-struts-3.1.1.RELEASE.jar:3.1.1.RELEASE]

at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) [struts-core-1.3.10.jar:1.3.10]

at com.awpl.dsia.requestprocessor.DSRequestProcessorWithForceLogin.processActionPerform(DSRequestProcessorWithForceLogin.java:240) [classes:]

at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) [struts-core-1.3.10.jar:1.3.10]

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) [struts-core-1.3.10.jar:1.3.10]

at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) [struts-core-1.3.10.jar:1.3.10]

at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

at com.awpl.ds.context.servlet.DSContextFilter.doFilterInternal(DSContextFilter.java:67) [dsfl-context-web-6.2.0.jar:6.2.0]

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) [spring-web-3.1.2.RELEASE.jar:3.1.2.RELEASE]

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.13.Final.jar:]

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

at com.awpl.dsui.filters.DSURIFilter.doFilter(DSURIFilter.java:56) [classes:]

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.13.Final.jar:]

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]

at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]

at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0_45]

Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/jdbc/DSCONFIG

at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:390)

at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:302)

at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:464)

at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:129)

... 48 more

Caused by: javax.resource.ResourceException: IJ000655: No managed connections available within configured blocking timeout (30000 [ms])

at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:377)

at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:397)

at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:365)

at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:329)

... 51 more

1. Re: IJ000453: Unable to get managed connection for java:/jdbc/DSCONFIG

wdfink Dec 11, 2013 4:36 AM (in response to johnrajuawpl)

You might check the number of "connection in use" in the management console (or via cli).
In such cases the problem is a connection leak and increase the connections will move the problem to a later point but not solve it.

You can activate the CCM (use-ccm) for the datasources and add the tracking inside the jca subsystem (add cached-connection-manager and set debug=true).
You will see stacktraces if the connection is not closed proper to find the related code in your application, also the connection is closed for you.
Actions