[jboss-user] [jBPM] - Re: JobExecutor becomes broken and cannot recover (JBPM3.2.2)

[Chatura Kalansooriya]

Chatura Kalansooriya [http://community.jboss.org/people/chatura] created the discussion

"Re: JobExecutor becomes broken and cannot recover (JBPM3.2.2)"

To view the discussion, visit: http://community.jboss.org/message/582972#582972

--------------------------------------------------------------
Hi All,

 I had similar issue with jbpm in my production environment. it’s very difficult pinpoint the real issue. 


10:07:04,782 WARN  [arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator_2] TwoPhaseCoordinator.beforeCompletion - failed for com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple at 30f230f2
org.hibernate.exception.GenericJDBCException: could not update: [org.jbpm.job.ExecuteActionJob#591486]
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2453)
        at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2335)
        at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2635)
        at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:115)
        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:168)
        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:114)
        at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:247)
        at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:86)
        at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)
        at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1389)
        at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:135)
        at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:87)
        at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClientUserTransaction.java:140)
        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.acquireJobs(JobExecutorThread.java:144)
        at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:60)
Caused by: 
java.sql.SQLException: ORA-01591: lock held by in-doubt distributed transaction 10.23.24923

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)
        at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
        at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2435)
        ... 26 more
10:07:04,784 ERROR [JobExecutorThread] exception in JbpmJobExector:172.26.23.52:1 (http://172.26.23.52:1/), waiting 3600000 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:158)
        at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.rollback(BaseTransactionManagerDelegate.java:126)
        at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.rollback(ServerVMClientUserTransaction.java:148)
        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.acquireJobs(JobExecutorThread.java:144)
        at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:60)

*environmet -jbpm 3.2.7(jta enable persistence service)* 
*                   -jboss 4.2.3 databace* 
*                   -oracle 10g(XA ds)*

*Pls help me to solve this.*

*Thanks in Advance !!!!!!!!
*

*
*


*
*
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/582972#582972]

Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110125/1e0aecfe/attachment.html