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

Deadlocks caused by missing index on foreign key in INCIDENT table

    Details

      Description

      The INCIDENT table misses indices on some columns which are foreign key references to other tables (and the table itself):

      Proposed indices (oracle):
      create index ACT_IDX_INC_CAUSEINCID on ACT_RU_INCIDENT(CAUSE_INCIDENT_ID_);
      create index ACT_IDX_INC_EXID on ACT_RU_INCIDENT(EXECUTION_ID_);
      create index ACT_IDX_INC_PROCDEFID on ACT_RU_INCIDENT(PROC_DEF_ID_);
      create index ACT_IDX_INC_PROCINSTID on ACT_RU_INCIDENT(PROC_INST_ID_);
      create index ACT_IDX_INC_ROOTCAUSEINCID on ACT_RU_INCIDENT(ROOT_CAUSE_INCIDENT_ID_);

        Issue Links

          Activity

          Hide
          jan.galinski@holisticon.de Jan Galinski added a comment -

          These indexes are not included in the oracle create script ... so we have to add them manually or run the patch. It would be nice if the create-script would set-up the entire db with one run ...

          Show
          jan.galinski@holisticon.de Jan Galinski added a comment - These indexes are not included in the oracle create script ... so we have to add them manually or run the patch. It would be nice if the create-script would set-up the entire db with one run ...
          Hide
          UrsBucher Urs Bucher added a comment -

          Here's the case described by Viacheslav Maliutin - Lessons to Solve SQL Server Deadlocks with Foreign Keys. It's the second part of the course (available online for colleges in the US too):
          https://www.mssqltips.com/sqlservertip/5191/lessons-to-solve-sql-server-deadlocks-with-foreign-keys--part-2/
          https://domyhomeworkonline.net/ programming-issues/wordpress/Perfstat/.

          Show
          UrsBucher Urs Bucher added a comment - Here's the case described by Viacheslav Maliutin - Lessons to Solve SQL Server Deadlocks with Foreign Keys. It's the second part of the course (available online for colleges in the US too): https://www.mssqltips.com/sqlservertip/5191/lessons-to-solve-sql-server-deadlocks-with-foreign-keys--part-2/ https://domyhomeworkonline.net/ programming-issues/wordpress/Perfstat/.

            People

            • Assignee:
              sebastian.menski Sebastian Menski
              Reporter:
              meyer Daniel Meyer
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development