0 Replies Latest reply on Nov 27, 2012 3:25 PM by Vineela Gampa

    IJ000453: Unable to get managed connection for

    Vineela Gampa Novice

      Hi

       

      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.

       

      we were hoping that the configuration specified in https://community.jboss.org/wiki/DetectingAndClosingLeakedConnectionsInJBoss71 helps but it doesnt. Can you let us know how can we make use of jboss letting us know when connections are not getting closed ?

       

      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] (