activiti 5.12 db error

[sc_boss]

I see this error when i tried to upgrade from 5.11 to 5.12 AND during new install of 5.12

12:34:02,916 [Thread-3] ERROR org.activiti.engine.impl.interceptor.CommandContext  - Error while closing command context
org.apache.ibatis.exceptions.PersistenceException:
### Error updating database.  Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (ACTIVITI.ACT_FK_IDL_PROCINST) violated - child record found

### The error may involve org.activiti.engine.impl.persistence.entity.ExecutionEntity.deleteExecution-Inline
### The error occurred while setting parameters
### SQL: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ?
### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (ACTIVITI.ACT_FK_IDL_PROCINST) violated - child record found

        at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:147)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.delete(DefaultSqlSession.java:158)
        at org.activiti.engine.impl.db.DbSqlSession$DeletePersistentObjectOperation.execute(DbSqlSession.java:237)
        at org.activiti.engine.impl.db.DbSqlSession.flushDeletes(DbSqlSession.java:668)
        at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:462)
        at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:168)
        at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:115)
        at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:70)
        at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)
        at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
        at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)
        at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
        at org.activiti.engine.impl.TaskServiceImpl.complete(TaskServiceImpl.java:159)
        at org.activiti.explorer.demo.DemoDataGenerator$1.run(DemoDataGenerator.java:278)
        at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (ACTIVITI.ACT_FK_IDL_PROCINST) violated - child record found

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1008)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
        at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
        at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41)
        at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66)
        at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45)
        at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:108)
        at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:145)
        … 14 more
Exception in thread "Thread-3" org.apache.ibatis.exceptions.PersistenceException:
### Error updating database.  Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (ACTIVITI.ACT_FK_IDL_PROCINST) violated - child record found

### The error may involve org.activiti.engine.impl.persistence.entity.ExecutionEntity.deleteExecution-Inline
### The error occurred while setting parameters
### SQL: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ?
### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (ACTIVITI.ACT_FK_IDL_PROCINST) violated - child record found

        at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:147)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.delete(DefaultSqlSession.java:158)
        at org.activiti.engine.impl.db.DbSqlSession$DeletePersistentObjectOperation.execute(DbSqlSession.java:237)
        at org.activiti.engine.impl.db.DbSqlSession.flushDeletes(DbSqlSession.java:668)
        at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:462)
        at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:168)
        at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:115)
        at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:70)
        at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)
        at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
        at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)
        at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
        at org.activiti.engine.impl.TaskServiceImpl.complete(TaskServiceImpl.java:159)
        at org.activiti.explorer.demo.DemoDataGenerator$1.run(DemoDataGenerator.java:278)
        at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (ACTIVITI.ACT_FK_IDL_PROCINST) violated - child record found

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1008)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
        at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
        at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41)
        at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66)
        at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45)
        at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:108)
        at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:145)
        … 14 more

[jbarrez]

It seems that from the stacktrace this happens when generating the demo data for Explorer using an Oracle DB, right?

Which Oracle version are you running on?

[jbarrez]

And also: which OS are you running on?

[sc_boss]

Oracle db on Windows 10g express edition.

Activiti on Windows/tomcat 7.0.37.

Let me know if I can help you more.

[jbarrez]

I've been looking into the issue (http://jira.codehaus.org/browse/ACT-1591) and could reproduce it locally.

The problem was that we were using identityService.setAuthenticatedUser("johndoe"), but it was never reset to null.

So, are you using the setAuthenticatedUser method somehow? That would explain why you also see the issue.

[jbarrez]

Fixed it on master: https://github.com/Activiti/Activiti/commit/73c11b55987cea047751e1aebd84afb16c01c3d4

We're currently thinking of releasing a 5.12.1 to include this fix, as some people will be hit by it and won't be able to fix it.

[infrag]

Fixed it on master: https://github.com/Activiti/Activiti/commit/73c11b55987cea047751e1aebd84afb16c01c3d4

We're currently thinking of releasing a 5.12.1 to include this fix, as some people will be hit by it and won't be able to fix it.

We would highly appreciate release of Activiti 5.12.1 since this bug affects us. When do you expect it will be released? Thank you.

[grantgochnauer1]

Fixed it on master: https://github.com/Activiti/Activiti/commit/73c11b55987cea047751e1aebd84afb16c01c3d4

We're currently thinking of releasing a 5.12.1 to include this fix, as some people will be hit by it and won't be able to fix it.

We would highly appreciate release of Activiti 5.12.1 since this bug affects us. When do you expect it will be released? Thank you.

+1! We're currently waiting for this as well. I see there is a release being prepared here: https://github.com/Activiti/Activiti/commit/4c372d89f209d38be8baa180b5f59330bc3e2084

[jbarrez]

5.12.1 is released yesterday. You can get it from the website or Maven!

[shilpi]

Hi JOram Barrez

I raised one JIRA : ACT-4259 same issue as the explained once. Could you please look into that and suggest me.

Please help me here.

Thanks and Regards,

Shilpi