topic Re: duplicate version row in ACT_RE_PROCDEF in Alfresco Forum

duplicate version row in ACT_RE_PROCDEF

nmorado — Thu, 31 Aug 2017 16:22:01 GMT

I am using activiti 5.22.0 with springboot 4.2.xI am seeing ocassionally 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.Is this a known issue? thanks

Re: duplicate version row in ACT_RE_PROCDEF

cjose — Fri, 01 Sep 2017 15:48:40 GMT

Not that I'm aware. Could you please provide a screenshot of this from your table? At least the ProcessDefinitionId (ID_) should be unique!

Re: duplicate version row in ACT_RE_PROCDEF

nmorado — Fri, 01 Sep 2017 17:15:01 GMT

I will provide next time it happens but we have only one process when this happens.

how do control when a new proc def gets inserted - i.e., insert if only new version for proc def is available instead of every boot up?

Re: duplicate version row in ACT_RE_PROCDEF

cjose — Fri, 01 Sep 2017 19:03:07 GMT

Check this link for more details about duplicate resource filtering.

Ciju

Re: duplicate version row in ACT_RE_PROCDEF

nmorado — Tue, 05 Sep 2017 18:25:25 GMT

where is the version specified for the single-resource strategy? does not seem obvious from the designer perspective - somewhere else?

Re: duplicate version row in ACT_RE_PROCDEF

nmorado — Tue, 05 Sep 2017 18:40:26 GMT

reviewing back the link - the single source seems to only handle version at a process def file level vs as a whole.

the issue that we were getting 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.

not sure how bpmn detects if anything changed from the bpmn since it was last deployed?

Re: duplicate version row in ACT_RE_PROCDEF

kam — Mon, 11 Sep 2017 18:37:52 GMT

Today I faced exactly the same problem of duplicate rows with same version. I have two nodes in cluster, both were restarted same time and they ended up with same version but different ID_ though. Removing the rows just worked fine. Seems this is indeed a bug in activiti where it could possibly add rows with same version + key, however when you try to start a process with key, it queries for key + version and expects on only one result.

Re: duplicate version row in ACT_RE_PROCDEF

nmorado — Fri, 15 Sep 2017 11:06:45 GMT

attaching the dupe