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

Investigate why job acquisition query performs a full table scan

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Won't Fix
    • Icon: L3 - Default L3 - Default
    • None
    • None
    • engine

      The query to select jobs to acquire [1] does a full table scan under the following conditions:

      • Oracle 11g
      • there are > 160.000 entries in job table
      • approximately 3 jobs (out of > 160.000 jobs) have a lock expiration time set

      [1]: https://github.com/camunda/camunda-bpm-platform/blob/9d33a42463f0616ff4fa461abecd6c17f1ecee92/engine/src/main/resources/org/camunda/bpm/engine/impl/mapping/entity/Job.xml#L137-L167

        This is the controller panel for Smart Panels app

              Unassigned Unassigned
              roman.smirnov Roman Smirnov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: