Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-4091

Reduce complexity of suspension state check in job query

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed
    • Priority: L3 - Default
    • Resolution: Fixed
    • Affects Version/s: 7.3.1
    • Fix Version/s: 7.4.0, 7.4.0-alpha3
    • Component/s: engine
    • Labels:
    • Environment:
      Camunda BPM 7.3.X
      WebSphere
      DB2

      Description

      The job acquisition query selects only active jobs. For reasons of backwards compatibility, an active job has SUSPENSION_STATE_ = 1 or SUSPENSION_STATE_ is null. This additional null check makes the acquisition query more complex, posing problems on some databases for index usage.

      AT:

      • the SUSPENSION_STATE_ column is declared NOT NULL and has a default value 1 (active)
      • the job acquisition query no longer performs a null check for SUSPENSION_STATE_

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              matthijs.burke Matthijs Burke
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: