topic Error de deadlock en ACT_RU_JOB in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-de-deadlock-en-act-ru-job/m-p/84610#M56971 <HTML><HEAD></HEAD><BODY><DIV class=""><P>Hola,</P><P style="min-height: 8pt; padding: 0px;"></P><P style="min-height: 8pt; padding: 0px;">Estoy usando Activiti 5.22.0.0 con base de datos Oracle y estoy teniendo el siguiente error de deadlock en la tabla de Activiti ACT_RU_JOB:</P></DIV><DIV class=""> </DIV><DIV class="">GRAVE: Error while closing command context<BR /><P>org.apache.ibatis.exceptions.PersistenceException: <BR />### Error updating database.&nbsp; Cause: java.sql.SQLException: ORA-00060: detectado interbloqueo mientras se esperaba un recurso</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>### The error may involve org.activiti.engine.impl.persistence.entity.JobEntity.updateMessage-Inline<BR />### The error occurred while setting parameters<BR />### SQL: update ACT_RU_JOB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SET REV_ =&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LOCK_EXP_TIME_ = ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LOCK_OWNER_ = ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RETRIES_ = ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EXCEPTION_STACK_ID_ = ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EXCEPTION_MSG_ = ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DUEDATE_ = ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where ID_= ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and REV_ = ?<BR />### Cause: java.sql.SQLException: ORA-00060: detectado interbloqueo mientras se esperaba un recurso</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>&nbsp;&nbsp; &nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)<BR />&nbsp;&nbsp; &nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:172)<BR />&nbsp;&nbsp; &nbsp;at org.activiti.engine.impl.db.DbSqlSession.flushUpdates(DbSqlSession.java:875)<BR />&nbsp;&nbsp; &nbsp;at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:616)<BR />&nbsp;&nbsp; &nbsp;at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:212)<BR />&nbsp;&nbsp; &nbsp;at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:138)<BR />&nbsp;&nbsp; &nbsp;at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:66)<BR />&nbsp;&nbsp; &nbsp;at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)<BR />&nbsp;&nbsp; &nbsp;at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)<BR />&nbsp;&nbsp; &nbsp;at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)<BR />&nbsp;&nbsp; &nbsp;at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)<BR />&nbsp;&nbsp; &nbsp;at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)<BR />&nbsp;&nbsp; &nbsp;at org.activiti.engine.impl.asyncexecutor.AcquireAsyncJobsDueRunnable.run(AcquireAsyncJobsDueRunnable.java:52)<BR />&nbsp;&nbsp; &nbsp;at java.lang.Thread.run(Thread.java:748)<BR />Caused by: java.sql.SQLException: ORA-00060: detectado interbloqueo mientras se esperaba un recurso</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>&nbsp;&nbsp; &nbsp;at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)<BR />&nbsp;&nbsp; &nbsp;at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)<BR />&nbsp;&nbsp; &nbsp;at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)<BR />&nbsp;&nbsp; &nbsp;at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)<BR />&nbsp;&nbsp; &nbsp;at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)<BR />&nbsp;&nbsp; &nbsp;at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)<BR />&nbsp;&nbsp; &nbsp;at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)<BR />&nbsp;&nbsp; &nbsp;at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1008)<BR />&nbsp;&nbsp; &nbsp;at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)<BR />&nbsp;&nbsp; &nbsp;at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)<BR />&nbsp;&nbsp; &nbsp;at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)<BR />&nbsp;&nbsp; &nbsp;at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)<BR />&nbsp;&nbsp; &nbsp;at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:45)<BR />&nbsp;&nbsp; &nbsp;at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:73)<BR />&nbsp;&nbsp; &nbsp;at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)<BR />&nbsp;&nbsp; &nbsp;at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:115)<BR />&nbsp;&nbsp; &nbsp;at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)<BR />&nbsp;&nbsp; &nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:170)<BR />&nbsp;&nbsp; &nbsp;... 13 more</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P style="min-height: 8pt; padding: 0px;">El diagrama consiste en varias actividades asíncronas en paralelo con una parallell gateway asíncrona y exclusiva cerrándolas.</P></DIV><DIV class=""> </DIV><DIV class="">Por favor, si necesitan información adicional pídanmela y se la proporciono. Muchas gracias.</DIV><DIV class=""> </DIV><DIV class="">Saludos</DIV><DIV class=""><BR /><P>Míguel</P></DIV></BODY></HTML> Mon, 12 Mar 2018 07:16:52 GMT mallop 2018-03-12T07:16:52Z Error de deadlock en ACT_RU_JOB https://connect.hyland.com/t5/alfresco-archive/error-de-deadlock-en-act-ru-job/m-p/84610#M56971 Hola,Estoy usando Activiti 5.22.0.0 con base de datos Oracle y estoy teniendo el siguiente error de deadlock en la tabla de Activiti ACT_RU_JOB: GRAVE: Error while closing command contextorg.apache.ibatis.exceptions.PersistenceException: ### Error updating database.&nbsp; Cause: java.sql.SQLException: OR Mon, 12 Mar 2018 07:16:52 GMT https://connect.hyland.com/t5/alfresco-archive/error-de-deadlock-en-act-ru-job/m-p/84610#M56971 mallop 2018-03-12T07:16:52Z Re: Error de deadlock en ACT_RU_JOB https://connect.hyland.com/t5/alfresco-archive/error-de-deadlock-en-act-ru-job/m-p/84611#M56972 <HTML><HEAD></HEAD><BODY><P>¿Cuánta RAM tienes dimensionada para la JVM (entiendo que Tomcat)?</P></BODY></HTML> Mon, 12 Mar 2018 09:09:00 GMT https://connect.hyland.com/t5/alfresco-archive/error-de-deadlock-en-act-ru-job/m-p/84611#M56972 angelborroy 2018-03-12T09:09:00Z Re: Error de deadlock en ACT_RU_JOB https://connect.hyland.com/t5/alfresco-archive/error-de-deadlock-en-act-ru-job/m-p/84612#M56973 <HTML><HEAD></HEAD><BODY><P>-Xms256m -Xmx1024m</P></BODY></HTML> Mon, 12 Mar 2018 11:51:08 GMT https://connect.hyland.com/t5/alfresco-archive/error-de-deadlock-en-act-ru-job/m-p/84612#M56973 mallop 2018-03-12T11:51:08Z Re: Error de deadlock en ACT_RU_JOB https://connect.hyland.com/t5/alfresco-archive/error-de-deadlock-en-act-ru-job/m-p/84613#M56974 <HTML><HEAD></HEAD><BODY><P>Igual es corto, ¿puedes probar a subirle el Xmx?</P></BODY></HTML> Mon, 12 Mar 2018 11:57:07 GMT https://connect.hyland.com/t5/alfresco-archive/error-de-deadlock-en-act-ru-job/m-p/84613#M56974 angelborroy 2018-03-12T11:57:07Z Re: Error de deadlock en ACT_RU_JOB https://connect.hyland.com/t5/alfresco-archive/error-de-deadlock-en-act-ru-job/m-p/84614#M56975 <HTML><HEAD></HEAD><BODY><P>Buenos días,</P><P>He subido el Xmx y sigue dando el mismo error.</P></BODY></HTML> Tue, 13 Mar 2018 09:51:38 GMT https://connect.hyland.com/t5/alfresco-archive/error-de-deadlock-en-act-ru-job/m-p/84614#M56975 mallop 2018-03-13T09:51:38Z