Uploaded image for project: 'JBoss BPMS Platform'
  1. JBoss BPMS Platform
  2. RHBPMS-5154

[GSS](6.4.z) Same job processed multiple times on Oracle

    Details

    • Type: Bug
    • Status: Verified (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 6.4.9
    • Fix Version/s: 6.4.11.GA
    • Component/s: jBPM Core
    • Labels:
    • Environment:

      Description

      Even after the upgrade to BPMS 6.4.9 which includes the BPMS-5115 fix, we see jobs getting executed twice. The problem is that the native query seems to release the lock too early, so that a second executor thread can also retrieve the same job.

      To fix this, it is enough to change the native query to also include the 'status' field in the outer query (see fixed sql).

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                swiderski.maciej Maciej Swiderski
                Reporter:
                mputz Martin Weiler
                Tester:
                Marian Macik
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: