5 Replies Latest reply on Sep 23, 2011 9:24 AM by wdfink

    Unable to get managed connection

    bhadre198307

      We are getting the below exception on one of the jboss node.

      same we are able to connect to database using other 5 nodes successfully no issue.

       

      Caused by: org.jboss.util.NestedSQLException: Unable to get managed connection for jdbc/ytlcXportal; -

      nested throwable: (javax.resource.ResourceException: Unable to get managed connection for jdbc/ytlcXportal)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataS

      ourceConnectionProvider.java:81)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:162)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1576)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.loader.Loader.doQuery(Loader.java:695)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:258)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.loader.Loader.loadEntity(Loader.java:1886)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:71)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:65)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3063)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:434)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:415)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:165)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:223)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:126)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:907)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.impl.SessionImpl.get(SessionImpl.java:844)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.impl.SessionImpl.get(SessionImpl.java:837)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.springframework.orm.hibernate3.HibernateTemplate$1.doInHibernate(HibernateTemplate.java:519)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) ... 48 more

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) Caused by: javax.resource.ResourceException: Unable to get managed connection for jdbc/ytlcXportal

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:441)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:424)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)

      2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) ... 69 more

      2011-09-15 23:48:04,213 ERROR [STDERR] (ajp--8209-97) Caused by: javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] )

      2011-09-15 23:48:04,213 ERROR [STDERR] (ajp--8209-97) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:311)

      2011-09-15 23:48:04,213 ERROR [STDERR] (ajp--8209-97) at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:690)

      2011-09-15 23:48:04,213 ERROR [STDERR] (ajp--8209-97) at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)

      2011-09-15 23:48:04,213 ERROR [STDERR] (ajp--8209-97) ... 73 more

       

      Our Jboss setup is like 6 nodes are in single cluster each machine having 2 nodes.

      We are not seeing the error after the server restart.

      Can anybody tell me how to fix this issues.

       

       

      Thanks,

      Bhadre Gowda

        • 1. Re: Unable to get managed connection
          mp911de

          Hi Bhadre,

           

          the Exception says:

           

          2011-09-15 23:48:04,213 ERROR [STDERR] (ajp--8209-97) Caused by: javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] )

           

          (perhaps you have some more of the exception to see the full stack-trace)

           

          The message says, that the configured pool cannot provide any connection within the configured timeout of 3sec (3000msec). Either your pool is too low or your connections are not free'd (closed) after usage. The thread is some No. 97 which indicates some load, perhaps increasing the pool size (within your -ds.xml, change or add the tag max-pool-size)

           

          Best regards,

          Mark

          • 2. Re: Unable to get managed connection
            bhadre198307

            Mark thanks for your reply.

             

            Max pool size is 200

            <max-pool-size>200</max-pool-size

             

            If its reached to maximum connection how come other nodes are able to connect.

             

            5000 is the maximum connections from database side.

             

            Here i have attached some more log

             

            ERROR [STDERR] (ajp-10.25.112.11-8209-97) org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncat
            egorized SQLException for SQL [???]; SQL state [null]; error code [0]; Unable to get managed connection for jdbc/ytlcXportal; - nested throwable: (javax.resource.Resour
            ceException: Unable to get managed connection for jdbc/ytlcXportal); nested exception is org.jboss.util.NestedSQLException: Unable to get managed connection for jdbc/yt
            lcXportal; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for jdbc/ytlcXportal)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFal
            lbackSQLExceptionTranslator.java:83)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFal
            lbackSQLExceptionTranslator.java:80)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFal
            lbackSQLExceptionTranslator.java:80)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAcce
            ssor.java:424)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(Hibernat
            eAccessor.java:410)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTempla
            te.java:374)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:512)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:506)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at com.ytlc.service.dao.hibernate.ConfigurationDAOImpl.getConfigurationConfig(Unknown Source)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at com.ytlc.ext.obrm.client.impl.SelfcareOBRMClientServiceImpl.getFacadeInstance(Unknown Source)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at com.ytlc.ext.obrm.client.impl.SelfcareOBRMClientServiceImpl.getDataUsageSummary(Unknown Sourc
            e)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at com.ytlc.service.component.impl.UserMyAccountServiceImpl.getPlanData(Unknown Source)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at com.ytlc.common.service.impl.MyAccountServiceImpl.getUserSummary(Unknown Source)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at com.ytlc.web.selfcare.controller.SelfCareController.populateData(Unknown Source)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at com.ytlc.web.selfcare.controller.SelfCareController.authenticateUser(Unknown Source)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at sun.reflect.GeneratedMethodAccessor492.invoke(Unknown Source)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at java.lang.reflect.Method.invoke(Method.java:597)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at com.ytlc.web.selfcare.controller.ApplicationFilter.doFilter(Unknown Source)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:183)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.jboss.modcluster.catalina.CatalinaContext$RequestListenerValve.event(CatalinaContext.java:285)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.jboss.modcluster.catalina.CatalinaContext$RequestListenerValve.invoke(CatalinaContext.java:261)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:95)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.jboss.web.tomcat.service.sso.ClusteredSingleSignOn.invoke(ClusteredSingleSignOn.java:672)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:436)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:384)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:451)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at java.lang.Thread.run(Thread.java:662)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97) Caused by: org.jboss.util.NestedSQLException: Unable to get managed connection for jdbc/ytlcXportal; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for jdbc/ytlcXportal)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:162)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1576)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.hibernate.loader.Loader.doQuery(Loader.java:695)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:258)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.hibernate.loader.Loader.loadEntity(Loader.java:1886)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:71)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:65)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3063)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:434)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:415)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:165)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:223)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:126)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:907)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.hibernate.impl.SessionImpl.get(SessionImpl.java:844)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.hibernate.impl.SessionImpl.get(SessionImpl.java:837)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.springframework.orm.hibernate3.HibernateTemplate$1.doInHibernate(HibernateTemplate.java:519)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       ... 48 more
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97) Caused by: javax.resource.ResourceException: Unable to get managed connection for jdbc/ytlcXportal
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:441)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:424)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
            2011-09-15 23:48:04,212 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       ... 69 more
            2011-09-15 23:48:04,213 ERROR [STDERR] (ajp-10.25.112.11-8209-97) Caused by: javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] )
            2011-09-15 23:48:04,213 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:311)
            2011-09-15 23:48:04,213 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:690)
            2011-09-15 23:48:04,213 ERROR [STDERR] (ajp-10.25.112.11-8209-97)       at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)

            • 3. Re: Unable to get managed connection
              mp911de

              Sometimes the load cannot be distributed evenly thru the single cluster nodes, so it may happen, that one node gets more load than the other ones. Please be aware, that the connection pool is specified by node, not for the whole cluster.

              • 4. Re: Unable to get managed connection
                bhadre198307

                Thanks mark...

                 

                Our got resloved after Development team closed the connections.

                • 5. Re: Unable to get managed connection
                  wdfink

                  What you might do is to check the connection close from JBoss. See the datasource configuring wiki for that.

                  It cost a bit but it will help to find connection leaks of applications because a warning will be written to the logfile.

                   

                  Also Statement and ResultSet can be monitored in this way because the physical connection is not closed (just pooled) and you might get an 'out of curser' problem if the application does not close it correctly.

                   

                  In a high performance environment you should deactivate it after you are sure the applicatin works correct