Unable to get managed connection
bhadre198307 Sep 17, 2011 8:33 PMWe 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