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

Missing index on ACT_RU_EXECUTION:PROC_INST_ID_

    Details

    • Type: Bug Report
    • Status: Closed
    • Priority: L3 - Default
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 7.3.0, 7.2.5, 7.1.10, 7.3.0-alpha4
    • Component/s: engine
    • Labels:
      None

      Description

      Problem description:
      Missing index on ACT_RU_EXECUTION:PROC_INST_ID_

      Impact:

      • possible source of deadlocks
      • performance

      AT:

      • index on ACT_RU_EXECUTION:PROC_INST_ID_ is added

        Activity

        Hide
        gimbel Robert Gimbel added a comment -

        Please pay attention to Christian's comments in github

        Show
        gimbel Robert Gimbel added a comment - Please pay attention to Christian's comments in github
        Hide
        RandyBonnette Randy Bonnette added a comment -

        In general (and in short), one needs to tweak the database indexes to avoid deadlocks. The issue has been posted in the codehouse reports - https://community.alfresco.com/thread/219057-data-model-review and https://writemyessaytoday.net/write-my-essay-in-2-hours Here's a discussion on Camunda Asych with MSSQL Producing Deadlocks - https://groups.google.com/forum/#!topic/camunda-bpm-users/RPE7xeEyOws

        Show
        RandyBonnette Randy Bonnette added a comment - In general (and in short), one needs to tweak the database indexes to avoid deadlocks. The issue has been posted in the codehouse reports - https://community.alfresco.com/thread/219057-data-model-review and https://writemyessaytoday.net/write-my-essay-in-2-hours Here's a discussion on Camunda Asych with MSSQL Producing Deadlocks - https://groups.google.com/forum/#!topic/camunda-bpm-users/RPE7xeEyOws

          People

          • Assignee:
            meyer Daniel Meyer
            Reporter:
            meyer Daniel Meyer
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development