duplicate key row in object 'ACT_RE_PROCDEF'

sandy13 — Wed, 29 Jul 2020 11:23:00 GMT

I am using activiti 5.21.0 with spring 3.1.4. I am getting occasionally that a dupe rows with same version for a process def exists in ACT_RE_PROCDEF table causing the application to not load at all.

Below error shows when it fail to start,

Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error updating database. Cause: java.sql.SQLException: Attempt to insert duplicate key row in object 'ACT_RE_PROCDEF' with unique index 'ACT_UNIQ_PROCDEF'

I have only one process to deploy and the issue is that even though the bpmn file did not change and you just restart the server - a new row with higher version gets inserted all the time.

How to control when a new proc def gets inserted - i.e., insert if the only new version for proc def is available instead of every bootup?

How bpmn detects if anything changed from the bpmn since it was last deployed?

Is this a known issue with acitivity?

Re: duplicate key row in object 'ACT_RE_PROCDEF'

abbask01 — Fri, 25 Sep 2020 12:38:33 GMT

actually, activiti itself should version the process def - https://www.activiti.org/5.x/userguide/#versioningOfProcessDefinitions

how are you deploying your process?

topic Re: duplicate key row in object 'ACT_RE_PROCDEF' in Alfresco Forum

duplicate key row in object 'ACT_RE_PROCDEF'

Re: duplicate key row in object 'ACT_RE_PROCDEF'