5 Replies Latest reply: Sep 23, 2011 9:24 AM by Wolf-Dieter Fink RSS

Unable to get managed connection

bhadre Gowda Newbie

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
    Mark Paluch Master

    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
    bhadre Gowda Newbie

    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
    Mark Paluch Master

    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
    bhadre Gowda Newbie

    Thanks mark...

     

    Our got resloved after Development team closed the connections.

  • 5. Re: Unable to get managed connection
    Wolf-Dieter Fink Master

    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