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

Missing index on ACT_RU_EXECUTION:PROC_INST_ID_

XMLWordPrintable

      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

        This is the controller panel for Smart Panels app

            [CAM-3565] Missing index on ACT_RU_EXECUTION:PROC_INST_ID_

            Robert Gimbel added a comment -

            Please pay attention to Christian's comments in github

            Robert Gimbel added a comment - Please pay attention to Christian's comments in github

            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

            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

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

                Created:
                Updated:
                Resolved: