5 Replies Latest reply on Nov 28, 2012 10:04 AM by Steven Hawkins

    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.

       

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