[jboss-user] [jBPM] - Multiple JBPM4_VARIABLE records pointing to same LOB_ and different EXECUTIONID_

[Jorge Ferreira]

Jorge Ferreira [http://community.jboss.org/people/imjorge] replied to the discussion

"Multiple JBPM4_VARIABLE records pointing to same LOB_ and different EXECUTIONID_"

To view the discussion, visit: http://community.jboss.org/message/548993#548993

--------------------------------------------------------------
After looking into jBPM source code I get a concrete impression that there should not be two jbpm4_variable (Variable and class hierarchy) that share the same Lob. The Lob constructors take care (because generateDbId is true) of assigning a new id to the record.

My best guess is something with the DatabaseDbIdGenerator but looking into the source code I have found nothing strange. More, the LOB_ that are duplicated as FK in jbpm4_variable table seem unrelated:

1970117,
1970123,
1970218,
2260229,
2260232

So a guess on edge cases, boundaries of block size, is off by now. I put a little test with two JVM for concurrency but the block generation is done inside a transaction and the behavior seems correct. One JVM fails but it is on a cycle of attempts and it peeks the next available block.

Any ideas from the people that coded jBPM, maybe I am missing something.

-- Jorge

--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/548993#548993]

Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100621/d0839285/attachment.html