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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 6.4.11.GA
    • 6.4.9
    • jBPM Core
    • CR1
    • Hide

      See attached pdf for detailed steps on how to reproduce this using manual sql statements.

      Show
      See attached pdf for detailed steps on how to reproduce this using manual sql statements.
    • 2018 Week 27-29

      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).

        1. fixed_query_requestinfo_for_update.sql
          0.5 kB
          Martin Weiler
        2. reproducer.pdf
          136 kB
          Martin Weiler

              swiderski.maciej Maciej Swiderski (Inactive)
              rhn-support-mputz Martin Weiler (Inactive)
              Marian Macik Marian Macik
              Marian Macik Marian Macik
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: