#1150 [HHQ-1058] "Could not synchronize database state with sessio

[Hyperic Team]

http://jira.hyperic.com/browse/HHQ-1058
Many HQ servers report the following errors despite the fact that there are free connections to the database. Many times, these errors follow a "org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1" error.

2007-07-21 00:00:32,057 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null


2007-07-21 00:00:32,057 ERROR [org.hibernate.util.JDBCExceptionReporter] Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=corpjavabuildw/39721730, BranchQual=, localId=39721730]; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=corpjavabuildw/39721730, BranchQual=, localId=39721730])


2007-07-21 00:00:32,057 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session


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:420)


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


at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:94)


at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)


at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:218)


at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2159)


at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2595)


at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:52)


at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)


at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)


at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)


at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)


at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)


at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)


at org.hyperic.hq.hibernate.SessionManager.cleanupSessionInternal(SessionManager.java:149)


at org.hyperic.hq.hibernate.SessionManager.cleanupSession(SessionManager.java:161)


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


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


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.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 $Proxy294.dispatch(Unknown Source)


at sun.reflect.GeneratedMethodAccessor7857.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:292)


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


Caused by: org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=corpjavabuildw/39721730, BranchQual=, localId=39721730]; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=corpjavabuildw/39721730, BranchQual=, localId=39721730])


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


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


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


... 34 more


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


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:73)


... 36 more


2007-07-21 00:00:32,073 WARN [org.hyperic.hq.hibernate.SessionManager] Error closing session


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:420)


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


at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:94)


at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)


at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:218)


at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2159)


at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2595)


at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:52)


at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)


at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)


at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)


at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)


at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)


at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)


at org.hyperic.hq.hibernate.SessionManager.cleanupSessionInternal(SessionManager.java:149)


at org.hyperic.hq.hibernate.SessionManager.cleanupSession(SessionManager.java:161)


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


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


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.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 $Proxy294.dispatch(Unknown Source)


at sun.reflect.GeneratedMethodAccessor7857.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:292)


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


Caused by: org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=corpjavabuildw/39721730, BranchQual=, localId=39721730]; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=corpjavabuildw/39721730, BranchQual=, localId=39721730])


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


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


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


... 34 more


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


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:73)


... 36 more