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

Investigate why job acquisition query performs a full table scan

    XMLWordPrintable

Details

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

    Description

      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

      mgm-controller-panel

        This is the controller panel for Smart Panels app

        Attachments

          Issue Links

            is related to

            Bug Report - A problem which impairs or prevents the functions of the product. CAM-9581 Job acquisition query causes high CPU costs

            • L3 - Default - Minor issue or issue with existing workaround, feature requests and questions
            • Closed

            Activity

              People

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

                Dates

                  Created:
                  Updated:
                  Resolved:

                  Salesforce