IJ000453: Unable to get managed connection for
gamvi01 Nov 26, 2012 6:42 PMHi
Lately we are seeing this behaviour after moving to jboss 7 where after the jboss has been running for sometime we see Unable to get managed connection for error. Detailed stack trace posted below.
I debugged to see if the connections are getting closed from our side and i observed all of the connections seems to get closed properly. Please let us know the things we can debug or look at to get it resolved.
Configuration for CHORUS-H2-ALERTS-DS
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<datasource jndi-name="jboss/datasources/CHORUS-H2-ALERTS-DS" enabled="true" use-java-context="true" pool-name="CHORUS-H2-ALERTS-DS">
<connection-url>jdbc:h2:${jboss.home.dir}/../database/h2${/}alerts;DB_CLOSE_ON_EXIT=FALSE;LOCK_TIMEOUT=10000;CACHE_SIZE=131072;CACHE_TYPE=SOFT_LRU;MVCC=TRUE</connection-url>
<driver>h2</driver>
<security>
<user-name>sa</user-name>
<password></password>
</security>
</datasource>
</datasources>
ava.lang.Exception,com.ca.mfui.client.UserSessionException
14:41:36,995 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) com.google.inject.ProvisionException: Guice provision errors:
14:41:36,996 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73)
14:41:36,997 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) 1) Error in custom provider, java.lang.RuntimeException: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/CHORUS-H2-ALERTS-DS
14:41:36,999 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) while locating com.ca.chorus.server.startup.h2.H2AlertsConnectionProvider
14:41:37,001 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) while locating java.sql.Connection annotated with @com.google.inject.name.Named(value=h2-alerts)
14:41:37,002 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) for parameter 1 at com.ca.mfui.services.profile.impl.H2ProfileServiceImpl.<init>(H2ProfileServiceImpl.java:122)
14:41:37,004 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) while locating com.ca.mfui.services.profile.impl.H2ProfileServiceImpl
14:41:37,005 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) while locating com.ca.mfui.services.profile.ProfileService
14:41:37,007 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73)
14:41:37,007 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) 1 error
14:41:37,008 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:987)
14:41:37,009 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.internal.InjectorImpl.getInstance(InjectorImpl.java:1013)
14:41:37,011 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.ca.mfui.server.ServiceFactory.getProfileService(ServiceFactory.java:120)
14:41:37,012 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.ca.mfui.server.ServiceFactory.doesUserExist(ServiceFactory.java:567)
14:41:37,014 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.ca.mfui.server.LoginServiceImpl.doesUserExist(LoginServiceImpl.java:265)
14:41:37,015 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.ca.mfui.server.LoginServiceImpl.authServer(LoginServiceImpl.java:383)
14:41:37,016 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at sun.reflect.GeneratedMethodAccessor288.invoke(Unknown Source)
14:41:37,017 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
14:41:37,019 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at java.lang.reflect.Method.invoke(Method.java:613)
14:41:37,020 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet.processCall(ChorusGWTServlet.java:255)
14:41:37,021 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)
14:41:37,023 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
14:41:37,025 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
14:41:37,026 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
14:41:37,028 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)
14:41:37,029 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)
14:41:37,032 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
14:41:37,033 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)
14:41:37,035 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
14:41:37,037 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
14:41:37,038 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
14:41:37,040 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
14:41:37,042 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
14:41:37,044 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
14:41:37,046 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:40)
14:41:37,047 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:35)
14:41:37,049 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.ca.chorus.server.transaction.TransactionRunner.invoke(TransactionRunner.java:23)
14:41:37,051 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$de0560e8.CGLIB$invoke$0(<generated>)
14:41:37,053 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$de0560e8$$FastClassByGuice$$c6c70e1d.invoke(<generated>)
14:41:37,055 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
14:41:37,056 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
14:41:37,058 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:71)
14:41:37,060 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:88)
14:41:37,061 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.ca.chorus.server.transaction.TransactionalMethodInterceptor.invoke(TransactionalMethodInterceptor.java:31)
14:41:37,063 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
14:41:37,065 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)
14:41:37,067 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$de0560e8.invoke(<generated>)
14:41:37,068 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.ca.mfui.chorusR2.servlet.TransactionFilter.doFilter(TransactionFilter.java:34)
14:41:37,070 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)
14:41:37,072 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
14:41:37,073 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
14:41:37,075 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
14:41:37,076 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)
14:41:37,078 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)
14:41:37,080 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
14:41:37,081 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
14:41:37,083 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
14:41:37,085 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
14:41:37,087 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)
14:41:37,089 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
14:41:37,091 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
14:41:37,093 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
14:41:37,095 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)
14:41:37,097 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)
14:41:37,099 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671)
14:41:37,101 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)
14:41:37,103 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at java.lang.Thread.run(Thread.java:769)
14:41:37,104 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) Caused by: java.lang.RuntimeException: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/CHORUS-H2-ALERTS-DS
14:41:37,107 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.ca.chorus.db.AConnectionProvider.get(AConnectionProvider.java:137)
14:41:37,108 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.ca.chorus.db.AConnectionProvider.get(AConnectionProvider.java:13)
14:41:37,110 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.internal.BoundProviderFactory.get(BoundProviderFactory.java:55)
14:41:37,111 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.internal.SingleParameterInjector.inject(SingleParameterInjector.java:38)
14:41:37,113 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.internal.SingleParameterInjector.getAll(SingleParameterInjector.java:62)
14:41:37,114 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:84)
14:41:37,116 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:254)
14:41:37,118 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.internal.FactoryProxy.get(FactoryProxy.java:54)
14:41:37,119 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.java:978)
14:41:37,121 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1024)
14:41:37,122 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:974)
14:41:37,124 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) ... 56 more
14:41:37,124 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/CHORUS-H2-ALERTS-DS
14:41:37,127 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:137)
14:41:37,128 INFO [stdout] (http--0_0_0_0_0_0_0_0-9304-73) at com.ca.chorus.db.AConnectionProvider.getConnection(AConnectionProvider.java:35)
14:41:37,130 INFO [stdout] (