AnsweredAssumed Answered

Unique contraint violated - ACT_HI_VARINST(ID_)

Question asked by badrisudheer on Jan 28, 2013
Latest reply on Jan 30, 2013 by ronald.van.kuijk
When we have activiti engine running in 2 different servers (trying to setup a clustered environment) pointing to same DB schema. one of the engines is throwing java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (APP.SYS_C00386332) violated. This is violating unique constraint is on ACT_HI_VARINST (ID_) column. Here is the constraint definition.

We have come across similar unique constraint issues on ACT_HI_PROCINST(PROC_INST_ID_) column also. Looks like Activiti engine is not using any DB sequence in generating these IDs and some how in this type of clustered environment we are observing the failures on 2 instances trying to save the data to these tables with same ID value.

Please note that we are experiencing this when we tried to perform load testing on a workflow with simple Service Tasks. We were trying to see how Activiti engine handles the requests on high volumes of requests which would initiate multiple process instances for a given process definition in a clustered environment.

Can some one help me understand what may be causing this.