JBoss Community

Re: Could not synchronize databse problem

created by M - in jBPM - View the full discussion

Did you find a solution for this?

 

I'm getting this as well while load testing with AS 5.1.0, ESB 4.9, jBPM 3.2.8, using HSQL or MS SQL Server 2005.

 

2010-11-10 12:02:25,799 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] (JbpmJobExector:192.168.1.121:1) [Could not synchronize database state with session]
org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [org.jbpm.job.ExecuteActionJob#6557]
at org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:1792)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
at org.hibernate.transaction.CacheSynchronization.beforeCompletion(CacheSynchronization.java:88)
at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:101)
at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:269)
at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:89)
at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)
at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1423)
at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:137)
at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)
at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClientUserTransaction.java:162)
at org.jbpm.persistence.jta.JtaDbPersistenceService.commit(JtaDbPersistenceService.java:98)
at org.jbpm.persistence.db.DbPersistenceService.endTransaction(DbPersistenceService.java:135)
at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:201)
at org.jbpm.svc.Services.close(Services.java:247)
at org.jbpm.JbpmContext.close(JbpmContext.java:131)
at org.jbpm.job.executor.JobExecutorThread.executeJob(JobExecutorThread.java:202)
at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:63)
2010-11-10 12:02:25,800 WARN  [com.arjuna.ats.arjuna.logging.arjLoggerI18N] (JbpmJobExector:192.168.1.121:1) [[com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator_2] TwoPhaseCoordinator.beforeCompletion - failed for com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple@42fa7aa3]
org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [org.jbpm.job.ExecuteActionJob#6557]
at org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:1792)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
at org.hibernate.transaction.CacheSynchronization.beforeCompletion(CacheSynchronization.java:88)
at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:101)
at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:269)
at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:89)
at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)
at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1423)
at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:137)
at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)
at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClientUserTransaction.java:162)
at org.jbpm.persistence.jta.JtaDbPersistenceService.commit(JtaDbPersistenceService.java:98)
at org.jbpm.persistence.db.DbPersistenceService.endTransaction(DbPersistenceService.java:135)
at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:201)
at org.jbpm.svc.Services.close(Services.java:247)
at org.jbpm.JbpmContext.close(JbpmContext.java:131)
at org.jbpm.job.executor.JobExecutorThread.executeJob(JobExecutorThread.java:202)
at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:63)
2010-11-10 12:02:25,805 ERROR [org.jbpm.job.executor.JobExecutorThread] (JbpmJobExector:192.168.1.121:1) [exception in JbpmJobExector:192.168.1.121:1, waiting 5000 ms]
java.lang.IllegalStateException: BaseTransaction.rollback - [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] no transaction!
at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.rollback(BaseTransaction.java:160)
at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.rollback(BaseTransactionManagerDelegate.java:114)
at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.rollback(ServerVMClientUserTransaction.java:170)
at org.jbpm.persistence.jta.JtaDbPersistenceService.rollback(JtaDbPersistenceService.java:119)
at org.jbpm.persistence.db.DbPersistenceService.endTransaction(DbPersistenceService.java:137)
at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:201)
at org.jbpm.svc.Services.close(Services.java:247)
at org.jbpm.JbpmContext.close(JbpmContext.java:131)
at org.jbpm.job.executor.JobExecutorThread.executeJob(JobExecutorThread.java:202)
at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:63)

2010-11-10 12:02:25,799 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] (JbpmJobExector:192.168.1.121:1) [Could not synchronize database state with session]

org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [org.jbpm.job.ExecuteActionJob#6557]

     at org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:1792)

     at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)

     at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)

     at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)

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

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

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

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

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

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

     at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)

     at org.hibernate.transaction.CacheSynchronization.beforeCompletion(CacheSynchronization.java:88)

     at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:101)

     at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:269)

     at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:89)

     at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)

     at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1423)

     at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:137)

     at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)

     at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClientUserTransaction.java:162)

     at org.jbpm.persistence.jta.JtaDbPersistenceService.commit(JtaDbPersistenceService.java:98)

     at org.jbpm.persistence.db.DbPersistenceService.endTransaction(DbPersistenceService.java:135)

     at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:201)

     at org.jbpm.svc.Services.close(Services.java:247)

     at org.jbpm.JbpmContext.close(JbpmContext.java:131)

     at org.jbpm.job.executor.JobExecutorThread.executeJob(JobExecutorThread.java:202)

     at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:63)

2010-11-10 12:02:25,800 WARN  [com.arjuna.ats.arjuna.logging.arjLoggerI18N] (JbpmJobExector:192.168.1.121:1) [[com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator_2] TwoPhaseCoordinator.beforeCompletion - failed for com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple@42fa7aa3]

org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [org.jbpm.job.ExecuteActionJob#6557]

     at org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:1792)

     at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)

     at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)

     at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)

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

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

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

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

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

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

     at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)

     at org.hibernate.transaction.CacheSynchronization.beforeCompletion(CacheSynchronization.java:88)

     at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:101)

     at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:269)

     at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:89)

     at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)

     at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1423)

     at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:137)

     at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)

     at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClientUserTransaction.java:162)

     at org.jbpm.persistence.jta.JtaDbPersistenceService.commit(JtaDbPersistenceService.java:98)

     at org.jbpm.persistence.db.DbPersistenceService.endTransaction(DbPersistenceService.java:135)

     at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:201)

     at org.jbpm.svc.Services.close(Services.java:247)

     at org.jbpm.JbpmContext.close(JbpmContext.java:131)

     at org.jbpm.job.executor.JobExecutorThread.executeJob(JobExecutorThread.java:202)

     at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:63)

2010-11-10 12:02:25,805 ERROR [org.jbpm.job.executor.JobExecutorThread] (JbpmJobExector:192.168.1.121:1) [exception in JbpmJobExector:192.168.1.121:1, waiting 5000 ms]

java.lang.IllegalStateException: BaseTransaction.rollback - [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] no transaction!

     at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.rollback(BaseTransaction.java:160)

     at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.rollback(BaseTransactionManagerDelegate.java:114)

     at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.rollback(ServerVMClientUserTransaction.java:170)

     at org.jbpm.persistence.jta.JtaDbPersistenceService.rollback(JtaDbPersistenceService.java:119)

     at org.jbpm.persistence.db.DbPersistenceService.endTransaction(DbPersistenceService.java:137)

     at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:201)

     at org.jbpm.svc.Services.close(Services.java:247)

     at org.jbpm.JbpmContext.close(JbpmContext.java:131)

     at org.jbpm.job.executor.JobExecutorThread.executeJob(JobExecutorThread.java:202)

     at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:63)

Reply to this message by going to Community

Start a new discussion in jBPM at Community