Menu

#1238 [HHQ-1954] Hibernate not able to open mysql connection under

open
None
7
2012-10-09
2008-04-15
No

http://jira.hyperic.com/browse/HHQ-1954
Under heavy metric load (~77K/min) HQ starts to throw following errors in server load. Occurance of these error increases with a steady state 7K metrics/minute load. After few hours I see HQ inserting less then 1000K metrics/minute and agents starts seeing unable to send data queue size full errors.



Batch Aggregator:


workers=50


batch size=1,000


queue size=1,000,000



Max db pool size=375


Number of live agents = 353



2008-04-08 21:45:32,637 WARN [Thread-88986] [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null


2008-04-08 21:45:32,637 ERROR [Thread-88986] [org.hibernate.util.JDBCExceptionReporter] Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=pserv01.hyperic


.net/5925047, BranchQual=, localId=5925047]
; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=pse


rv01.hyperic.net/5925047, BranchQual=, localId=5925047]
)


2008-04-08 21:45:32,638 INFO [Thread-88986] [org.hibernate.event.def.DefaultLoadEventListener] Error performing load command


org.hibernate.exception.GenericJDBCException: Cannot open connection


        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)


        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)


        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)


        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)


        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)


        at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)


        at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)


        at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)


        at org.hibernate.loader.Loader.doQuery(Loader.java:673)


        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)


        at org.hibernate.loader.Loader.loadEntity(Loader.java:1860)


        at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)


        at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)


        at org.hibernate.loader.entity.BatchingEntityLoader.load(BatchingEntityLoader.java:82)


        at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3042)


        at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395)


        at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)


        at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)


        at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195)


        at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)


        at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)


        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)


        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)


        at org.hyperic.hq.dao.HibernateDAO.get(HibernateDAO.java:72)


        at org.hyperic.hq.measurement.server.session.DerivedMeasurementDAO.get(DerivedMeasurementDAO.java:60)


        at org.hyperic.hq.measurement.server.session.DerivedMeasurementManagerEJBImpl.getMeasurement(DerivedMeasurementManagerEJBImpl.java:603)


        at sun.reflect.GeneratedMethodAccessor478.invoke(Unknown Source)


        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


        at java.lang.reflect.Method.invoke(Unknown Source)


        at org.jboss.invocation.Invocation.performCall(Invocation.java:345)


        at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)


        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:149)


        at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:154)


        at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)


        at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)


        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)


        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)


        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)


        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)


        at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)


        at org.jboss.ejb.Container.invoke(Container.java:873)


        at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:415)


        at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:88)


        at $Proxy315.getMeasurement(Unknown Source)


        at org.hyperic.hq.measurement.server.session.ReportProcessorEJBImpl.handleMeasurementReport(ReportProcessorEJBImpl.java:174)


        at sun.reflect.GeneratedMethodAccessor554.invoke(Unknown Source)


        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


        at java.lang.reflect.Method.invoke(Unknown Source)


        at org.jboss.invocation.Invocation.performCall(Invocation.java:345)


        at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)


        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:149)


        at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:154)


        at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)


        at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)


        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)


        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)


        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)


        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)


        at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)


        at org.jboss.ejb.Container.invoke(Container.java:873)


        at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:415)


        at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:88)


        at $Proxy319.handleMeasurementReport(Unknown Source)


        at org.hyperic.hq.bizapp.server.session.LatherDispatcher.cmdMeasurementSendReport(LatherDispatcher.java:491)


        at org.hyperic.hq.bizapp.server.session.LatherDispatcher._dispatch(LatherDispatcher.java:750)


        at org.hyperic.hq.bizapp.server.session.LatherDispatcher.dispatch(LatherDispatcher.java:734)


        at com.hyperic.hq.bizapp.server.session.LatherDispatcher.dispatch(LatherDispatcher.java:148)


        at com.hyperic.hq.bizapp.server.session.EELatherBossEJBImpl.dispatchWithoutTx(EELatherBossEJBImpl.java:86)


        at com.hyperic.hq.bizapp.server.session.EELatherBossEJBImpl.dispatchWithTx(EELatherBossEJBImpl.java:74)


        at com.hyperic.hq.bizapp.server.session.EELatherBossEJBImpl.dispatch(EELatherBossEJBImpl.java:59)


        at sun.reflect.GeneratedMethodAccessor549.invoke(Unknown Source)


        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


        at java.lang.reflect.Method.invoke(Unknown Source)


        at org.jboss.invocation.Invocation.performCall(Invocation.java:345)


        at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)


        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:149)


        at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:154)


        at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)


        at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)


        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:300)


        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)


        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)


        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)


        at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)


        at org.jboss.ejb.Container.invoke(Container.java:873)


        at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:415)


        at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:88)


        at $Proxy329.dispatch(Unknown Source)


        at sun.reflect.GeneratedMethodAccessor548.invoke(Unknown Source)


        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


        at java.lang.reflect.Method.invoke(Unknown Source)


        at org.hyperic.lather.jboss.JBossLatherServlet$EJBCaller.doInvoke(JBossLatherServlet.java:318)


        at org.hyperic.lather.jboss.JBossLatherServlet$EJBCaller.run(JBossLatherServlet.java:354)


Caused by: org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=pserv01.hyperic.net/5925047, BranchQual=, localId=5925047


]
; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=pserv01.hyperic.net/5925047, BranchQual=, loc


alId=5925047]
)


        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94)


        at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:66)


        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)


        ... 112 more


Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=pserv01.hyperic.net/5925047, BranchQual=, localId=5925047]


        at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:331)


        at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:462)


        at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:894)


        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)


        ... 114 more


2008-04-08 21:45:32,645 ERROR [Thread-88986] [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackLocalException in method: public abstract org.hyperic.hq.measurement.server


.session.DerivedMeasurement org.hyperic.hq.measurement.shared.DerivedMeasurementManagerLocal.getMeasurement(java.lang.Integer), causedBy:


org.hibernate.exception.GenericJDBCException: Cannot open connection


        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)


        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)


        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)


        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)


        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)


        at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)


        at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)


        at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)


        at org.hibernate.loader.Loader.doQuery(Loader.java:673)


        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)


        at org.hibernate.loader.Loader.loadEntity(Loader.java:1860)


        at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)


        at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)


        at org.hibernate.loader.entity.BatchingEntityLoader.load(BatchingEntityLoader.java:82)


        at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3042)


        at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395)


        at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)


        at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)


        at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195)


        at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)


        at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)


        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)


        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)


        at org.hyperic.hq.dao.HibernateDAO.get(HibernateDAO.java:72)


        at org.hyperic.hq.measurement.server.session.DerivedMeasurementDAO.get(DerivedMeasurementDAO.java:60)


        at org.hyperic.hq.measurement.server.session.DerivedMeasurementManagerEJBImpl.getMeasurement(DerivedMeasurementManagerEJBImpl.java:603)


        at sun.reflect.GeneratedMethodAccessor478.invoke(Unknown Source)


        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


        at java.lang.reflect.Method.invoke(Unknown Source)


        at org.jboss.invocation.Invocation.performCall(Invocation.java:345)


        at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)


        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:149)


        at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:154)


        at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)


        at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)


        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)


        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)


        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)


        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)


        at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)


        at org.jboss.ejb.Container.invoke(Container.java:873)


        at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:415)


        at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:88)


        at $Proxy315.getMeasurement(Unknown Source)


        at org.hyperic.hq.measurement.server.session.ReportProcessorEJBImpl.handleMeasurementReport(ReportProcessorEJBImpl.java:174)


        at sun.reflect.GeneratedMethodAccessor554.invoke(Unknown Source)


        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


        at java.lang.reflect.Method.invoke(Unknown Source)


        at org.jboss.invocation.Invocation.performCall(Invocation.java:345)


        at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)


        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:149)


        at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:154)


        at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)


        at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)


        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)


        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)


        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)


        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)


        at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)


        at org.jboss.ejb.Container.invoke(Container.java:873)


        at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:415)


        at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:88)


        at $Proxy319.handleMeasurementReport(Unknown Source)


        at org.hyperic.hq.bizapp.server.session.LatherDispatcher.cmdMeasurementSendReport(LatherDispatcher.java:491)


        at org.hyperic.hq.bizapp.server.session.LatherDispatcher._dispatch(LatherDispatcher.java:750)


        at org.hyperic.hq.bizapp.server.session.LatherDispatcher.dispatch(LatherDispatcher.java:734)


        at com.hyperic.hq.bizapp.server.session.LatherDispatcher.dispatch(LatherDispatcher.java:148)


        at com.hyperic.hq.bizapp.server.session.EELatherBossEJBImpl.dispatchWithoutTx(EELatherBossEJBImpl.java:86)


        at com.hyperic.hq.bizapp.server.session.EELatherBossEJBImpl.dispatchWithTx(EELatherBossEJBImpl.java:74)


        at com.hyperic.hq.bizapp.server.session.EELatherBossEJBImpl.dispatch(EELatherBossEJBImpl.java:59)


        at sun.reflect.GeneratedMethodAccessor549.invoke(Unknown Source)


        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


        at java.lang.reflect.Method.invoke(Unknown Source)


        at org.jboss.invocation.Invocation.performCall(Invocation.java:345)


        at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)


        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:149)


        at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:154)


        at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)


        at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)


        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:300)


        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)


        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)


        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)


        at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)


        at org.jboss.ejb.Container.invoke(Container.java:873)


        at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:415)


        at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:88)


        at $Proxy329.dispatch(Unknown Source)


        at sun.reflect.GeneratedMethodAccessor548.invoke(Unknown Source)


        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


        at java.lang.reflect.Method.invoke(Unknown Source)


        at org.hyperic.lather.jboss.JBossLatherServlet$EJBCaller.doInvoke(JBossLatherServlet.java:318)


        at org.hyperic.lather.jboss.JBossLatherServlet$EJBCaller.run(JBossLatherServlet.java:354)


Caused by: org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=pserv01.hyperic.net/5925047, BranchQual=, localId=5925047


]
; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=pserv01.hyperic.net/5925047, BranchQual=, loc


alId=5925047]
)


        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94)


        at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:66)


        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)


        ... 112 more


Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=pserv01.hyperic.net/5925047, BranchQual=, localId=5925047]


        at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:331)


        at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:462)


        at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:894)


        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)


        ... 114 more


2008-04-08 21:45:32,647 WARN [Thread-88986] [org.hyperic.hq.application.HQApp] Method ran a long time.


Class: org.hyperic.hq.measurement.shared.ReportProcessorLocal


Method: handleMeasurementReport


RunTime: 900173



2008-04-08 21:45:32,653 ERROR [Thread-88986] [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackLocalException in method: public abstract void org.hyperic.hq.measurement.s


hared.ReportProcessorLocal.handleMeasurementReport(org.hyperic.hq.measurement.data.MeasurementReport) throws org.hyperic.hq.measurement.server.session.DataInserterException, caused


By:


org.hibernate.exception.GenericJDBCException: Cannot open connection


        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)


        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)


        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)


        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)


        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)


        at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)


        at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)


        at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)


        at org.hibernate.loader.Loader.doQuery(Loader.java:673)


        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)


        at org.hibernate.loader.Loader.loadEntity(Loader.java:1860)


        at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)


        at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)


        at org.hibernate.loader.entity.BatchingEntityLoader.load(BatchingEntityLoader.java:82)


        at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3042)


        at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395)


        at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)


        at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)


        at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195)


        at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)


        at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)


        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)


        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)


        at org.hyperic.hq.dao.HibernateDAO.get(HibernateDAO.java:72)


        at org.hyperic.hq.measurement.server.session.DerivedMeasurementDAO.get(DerivedMeasurementDAO.java:60)


        at org.hyperic.hq.measurement.server.session.DerivedMeasurementManagerEJBImpl.getMeasurement(DerivedMeasurementManagerEJBImpl.java:603)


        at sun.reflect.GeneratedMethodAccessor478.invoke(Unknown Source)


        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


        at java.lang.reflect.Method.invoke(Unknown Source)


        at org.jboss.invocation.Invocation.performCall(Invocation.java:345)


        at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)


        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:149)


        at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:154)


        at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)


        at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)


        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)


        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)


        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)


        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)


        at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)


        at org.jboss.ejb.Container.invoke(Container.java:873)


        at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:415)


        at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:88)


        at $Proxy315.getMeasurement(Unknown Source)


        at org.hyperic.hq.measurement.server.session.ReportProcessorEJBImpl.handleMeasurementReport(ReportProcessorEJBImpl.java:174)


        at sun.reflect.GeneratedMethodAccessor554.invoke(Unknown Source)


        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


        at java.lang.reflect.Method.invoke(Unknown Source)


        at org.jboss.invocation.Invocation.performCall(Invocation.java:345)


        at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)


        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:149)


        at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:154)


        at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)


        at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)


        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)


        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)


        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)


        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)


        at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)


        at org.jboss.ejb.Container.invoke(Container.java:873)


        at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:415)


        at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:88)


        at $Proxy319.handleMeasurementReport(Unknown Source)


        at org.hyperic.hq.bizapp.server.session.LatherDispatcher.cmdMeasurementSendReport(LatherDispatcher.java:491)


        at org.hyperic.hq.bizapp.server.session.LatherDispatcher._dispatch(LatherDispatcher.java:750)


        at org.hyperic.hq.bizapp.server.session.LatherDispatcher.dispatch(LatherDispatcher.java:734)


        at com.hyperic.hq.bizapp.server.session.LatherDispatcher.dispatch(LatherDispatcher.java:148)


        at com.hyperic.hq.bizapp.server.session.EELatherBossEJBImpl.dispatchWithoutTx(EELatherBossEJBImpl.java:86)


        at com.hyperic.hq.bizapp.server.session.EELatherBossEJBImpl.dispatchWithTx(EELatherBossEJBImpl.java:74)


        at com.hyperic.hq.bizapp.server.session.EELatherBossEJBImpl.dispatch(EELatherBossEJBImpl.java:59)


        at sun.reflect.GeneratedMethodAccessor549.invoke(Unknown Source)


        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


        at java.lang.reflect.Method.invoke(Unknown Source)


        at org.jboss.invocation.Invocation.performCall(Invocation.java:345)


        at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)


        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:149)


        at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:154)


        at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)


        at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)


        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:300)


        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)


        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)


        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)


        at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)


        at org.jboss.ejb.Container.invoke(Container.java:873)


        at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:415)


        at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:88)


        at $Proxy329.dispatch(Unknown Source)


        at sun.reflect.GeneratedMethodAccessor548.invoke(Unknown Source)


        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


        at java.lang.reflect.Method.invoke(Unknown Source)


        at org.hyperic.lather.jboss.JBossLatherServlet$EJBCaller.doInvoke(JBossLatherServlet.java:318)


        at org.hyperic.lather.jboss.JBossLatherServlet$EJBCaller.run(JBossLatherServlet.java:354)


Caused by: org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=pserv01.hyperic.net/5925047, BranchQual=, localId=5925047


]
; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=pserv01.hyperic.net/5925047, BranchQual=, loc


alId=5925047]
)


        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94)


        at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:66)


        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)


        ... 112 more


Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=pserv01.hyperic.net/5925047, BranchQual=, localId=5925047]


        at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:331)


        at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:462)


        at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:894)


        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)


        ... 114 more


2008-04-08 21:45:32,655 ERROR [Thread-88986] [com.hyperic.hq.bizapp.server.session.EELatherBossEJBImpl] Error dispatching method 'measurementSendReport'


javax.ejb.TransactionRolledbackLocalException: Cannot open connection; CausedByException is:


        Cannot open connection


        at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:247)


        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)


        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)


        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)


        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)


        at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)


        at org.jboss.ejb.Container.invoke(Container.java:873)


        at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:415)


        at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:88)


        at $Proxy315.getMeasurement(Unknown Source)


        at org.hyperic.hq.measurement.server.session.ReportProcessorEJBImpl.handleMeasurementReport(ReportProcessorEJBImpl.java:174)


        at sun.reflect.GeneratedMethodAccessor554.invoke(Unknown Source)


        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


        at java.lang.reflect.Method.invoke(Unknown Source)


        at org.jboss.invocation.Invocation.performCall(Invocation.java:345)


        at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)


        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:149)


        at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:154)


        at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)


        at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)


        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)


        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)


        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)


        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)


        at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)


        at org.jboss.ejb.Container.invoke(Container.java:873)


        at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:415)


        at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:88)


        at $Proxy319.handleMeasurementReport(Unknown Source)


        at org.hyperic.hq.bizapp.server.session.LatherDispatcher.cmdMeasurementSendReport(LatherDispatcher.java:491)


        at org.hyperic.hq.bizapp.server.session.LatherDispatcher._dispatch(LatherDispatcher.java:750)


        at org.hyperic.hq.bizapp.server.session.LatherDispatcher.dispatch(LatherDispatcher.java:734)


        at com.hyperic.hq.bizapp.server.session.LatherDispatcher.dispatch(LatherDispatcher.java:148)


        at com.hyperic.hq.bizapp.server.session.EELatherBossEJBImpl.dispatchWithoutTx(EELatherBossEJBImpl.java:86)


        at com.hyperic.hq.bizapp.server.session.EELatherBossEJBImpl.dispatchWithTx(EELatherBossEJBImpl.java:74)


        at com.hyperic.hq.bizapp.server.session.EELatherBossEJBImpl.dispatch(EELatherBossEJBImpl.java:59)


        at sun.reflect.GeneratedMethodAccessor549.invoke(Unknown Source)


        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


        at java.lang.reflect.Method.invoke(Unknown Source)


        at org.jboss.invocation.Invocation.performCall(Invocation.java:345)


        at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)


        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:149)


        at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:154)


        at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)


        at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)


        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:300)


        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)


        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)


        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)


        at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)


        at org.jboss.ejb.Container.invoke(Container.java:873)


        at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:415)


        at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:88)


        at $Proxy329.dispatch(Unknown Source)


        at sun.reflect.GeneratedMethodAccessor548.invoke(Unknown Source)


        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


        at java.lang.reflect.Method.invoke(Unknown Source)


        at org.hyperic.lather.jboss.JBossLatherServlet$EJBCaller.doInvoke(JBossLatherServlet.java:318)


        at org.hyperic.lather.jboss.JBossLatherServlet$EJBCaller.run(JBossLatherServlet.java:354)


org.hibernate.exception.GenericJDBCException: Cannot open connection


        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)


        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)


        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)


        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)


        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)


        at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)


        at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)


        at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)


        at org.hibernate.loader.Loader.doQuery(Loader.java:673)


        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)


        at org.hibernate.loader.Loader.loadEntity(Loader.java:1860)


        at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)


        at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)


        at org.hibernate.loader.entity.BatchingEntityLoader.load(BatchingEntityLoader.java:82)


        at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3042)


        at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395)


        at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)


        at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)


        at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195)


        at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)


        at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)


        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)


        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)


        at org.hyperic.hq.dao.HibernateDAO.get(HibernateDAO.java:72)


        at org.hyperic.hq.measurement.server.session.DerivedMeasurementDAO.get(DerivedMeasurementDAO.java:60)


        at org.hyperic.hq.measurement.server.session.DerivedMeasurementManagerEJBImpl.getMeasurement(DerivedMeasurementManagerEJBImpl.java:603)


        at sun.reflect.GeneratedMethodAccessor478.invoke(Unknown Source)


        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


        at java.lang.reflect.Method.invoke(Unknown Source)


        at org.jboss.invocation.Invocation.performCall(Invocation.java:345)


        at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)


        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:149)


        at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:154)


        at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)


        at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)


        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)


        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)


        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)


        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)


        at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)


        at org.jboss.ejb.Container.invoke(Container.java:873)


        at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:415)


        at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:88)


        at $Proxy315.getMeasurement(Unknown Source)


        at org.hyperic.hq.measurement.server.session.ReportProcessorEJBImpl.handleMeasurementReport(ReportProcessorEJBImpl.java:174)


        at sun.reflect.GeneratedMethodAccessor554.invoke(Unknown Source)


        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


        at java.lang.reflect.Method.invoke(Unknown Source)


        at org.jboss.invocation.Invocation.performCall(Invocation.java:345)


        at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)


        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:149)


        at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:154)


        at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)


        at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)


        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)


        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)


        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)


        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)


        at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)


        at org.jboss.ejb.Container.invoke(Container.java:873)


        at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:415)


        at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:88)


        at $Proxy319.handleMeasurementReport(Unknown Source)


        at org.hyperic.hq.bizapp.server.session.LatherDispatcher.cmdMeasurementSendReport(LatherDispatcher.java:491)


        at org.hyperic.hq.bizapp.server.session.LatherDispatcher._dispatch(LatherDispatcher.java:750)


        at org.hyperic.hq.bizapp.server.session.LatherDispatcher.dispatch(LatherDispatcher.java:734)


        at com.hyperic.hq.bizapp.server.session.LatherDispatcher.dispatch(LatherDispatcher.java:148)


        at com.hyperic.hq.bizapp.server.session.EELatherBossEJBImpl.dispatchWithoutTx(EELatherBossEJBImpl.java:86)


        at com.hyperic.hq.bizapp.server.session.EELatherBossEJBImpl.dispatchWithTx(EELatherBossEJBImpl.java:74)


        at com.hyperic.hq.bizapp.server.session.EELatherBossEJBImpl.dispatch(EELatherBossEJBImpl.java:59)


        at sun.reflect.GeneratedMethodAccessor549.invoke(Unknown Source)


        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


        at java.lang.reflect.Method.invoke(Unknown Source)


        at org.jboss.invocation.Invocation.performCall(Invocation.java:345)


        at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)


        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:149)


        at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:154)


        at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)


        at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)


        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:300)


        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)


        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)


        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)


        at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)


        at org.jboss.ejb.Container.invoke(Container.java:873)


        at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:415)


        at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:88)


        at $Proxy329.dispatch(Unknown Source)


        at sun.reflect.GeneratedMethodAccessor548.invoke(Unknown Source)


        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


        at java.lang.reflect.Method.invoke(Unknown Source)


        at org.hyperic.lather.jboss.JBossLatherServlet$EJBCaller.doInvoke(JBossLatherServlet.java:318)


        at org.hyperic.lather.jboss.JBossLatherServlet$EJBCaller.run(JBossLatherServlet.java:354)


Caused by: org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=pserv01.hyperic.net/5925047, BranchQual=, localId=5925047


]
; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=pserv01.hyperic.net/5925047, BranchQual=, loc


alId=5925047]
)


        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94)


        at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:66)


        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)


        ... 112 more


Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=pserv01.hyperic.net/5925047, BranchQual=, localId=5925047]


        at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:331)


        at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:462)


        at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:894)


        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)


        ... 114 more


2008-04-08 21:45:32,659 WARN [Thread-88986] [org.hyperic.hq.application.HQApp] Method ran a long time.


Class: com.hyperic.hq.bizapp.shared.EELatherBossLocal


Method: dispatch


RunTime: 900187



2008-04-08 21:45:32,659 ERROR [Thread-88986] [org.jboss.ejb.plugins.LogInterceptor] RuntimeException in method: public abstract org.hyperic.lather.LatherValue com.hyperic.hq.bizapp


.shared.EELatherBossLocal.dispatch(org.hyperic.lather.LatherContext,java.lang.String,org.hyperic.lather.LatherValue) throws org.hyperic.lather.LatherRemoteException:


java.lang.IllegalStateException: setRollbackOnly() not allowed without a transaction.


        at org.jboss.ejb.EnterpriseContext$EJBContextImpl.setRollbackOnly(EnterpriseContext.java:445)


        at org.jboss.ejb.StatelessSessionEnterpriseContext$SessionContextImpl.setRollbackOnly(StatelessSessionEnterpriseContext.java:217)


        at com.hyperic.hq.bizapp.server.session.EELatherBossEJBImpl.dispatchWithoutTx(EELatherBossEJBImpl.java:89)


        at com.hyperic.hq.bizapp.server.session.EELatherBossEJBImpl.dispatchWithTx(EELatherBossEJBImpl.java:74)


        at com.hyperic.hq.bizapp.server.session.EELatherBossEJBImpl.dispatch(EELatherBossEJBImpl.java:59)


        at sun.reflect.GeneratedMethodAccessor549.invoke(Unknown Source)


        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


        at java.lang.reflect.Method.invoke(Unknown Source)


        at org.jboss.invocation.Invocation.performCall(Invocation.java:345)


        at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)


        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:149)


        at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:154)


        at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)


        at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)


        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:300)


        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:416)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:468)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)


        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)


        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)


        at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)


        at org.jboss.ejb.Container.invoke(Container.java:873)


        at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:415)


        at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:88)


        at $Proxy329.dispatch(Unknown Source)


        at sun.reflect.GeneratedMethodAccessor548.invoke(Unknown Source)


        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


        at java.lang.reflect.Method.invoke(Unknown Source)


        at org.hyperic.lather.jboss.JBossLatherServlet$EJBCaller.doInvoke(JBossLatherServlet.java:318)


        at org.hyperic.lather.jboss.JBossLatherServlet$EJBCaller.run(JBossLatherServlet.java:354)


2008-04-08 21:45:32,660 ERROR [Thread-88986] [org.hyperic.lather.jboss.JBossLatherServlet] Unexpected exception occurred when invoking com.hyperic.hq.bizapp.shared.EELatherBossLoca


l.dispatch


java.lang.reflect.InvocationTargetException


        at sun.reflect.GeneratedMethodAccessor548.invoke(Unknown Source)


        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


        at java.lang.reflect.Method.invoke(Unknown Source)


        at org.hyperic.lather.jboss.JBossLatherServlet$EJBCaller.doInvoke(JBossLatherServlet.java:318)


        at org.hyperic.lather.jboss.JBossLatherServlet$EJBCaller.run(JBossLatherServlet.java:354)


Caused by: javax.ejb.EJBException: RuntimeException; CausedByException is:


        setRollbackOnly() not allowed without a transaction.


        at org.jboss.ejb.plugins.LogInterceptor.handleException(LogInterceptor.java:382)


        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:196)


        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)


        at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)


        at org.jboss.ejb.Container.invoke(Container.java:873)


        at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:415)


        at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:88)


        at $Proxy329.dispatch(Unknown Source)


        ... 5 more


2008-04-08 21:45:32,661 DEBUG [Thread-93703] [com.hyperic.hq.measurement.server.session.BatchAggregateDataInserter] Inserting 346 metrics into queue (size=3874)


[workerb@pserv01 ~]$

Discussion

Anonymous
Anonymous

Add attachments
Cancel





Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.