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

Missing Index on Foreign Key ERROR_DETAILS_ID_ in External Task

    XMLWordPrintable

Details

    • Bug Report
    • Status: Closed
    • L3 - Default
    • Resolution: Fixed
    • None
    • 7.7.0, 7.6.3, 7.7.0-alpha1
    • engine

    Description

      Problem

      The external task table has a foreign key to the byte array table.

      alter table ACT_RU_EXT_TASK
          add constraint ACT_FK_EXT_TASK_ERROR_DETAILS
          foreign key (ERROR_DETAILS_ID_)
          references ACT_GE_BYTEARRAY (ID_);
      

      But there is no index on the ERROR_DETAILS_ID_ column. In the case a byte array is deleted some databases may lock the whole external task table, which can lead to a deadlock.

      AT:

      • create index on ERROR_DETAILS_ID_ in external task table

      mgm-controller-panel

        This is the controller panel for Smart Panels app

        Attachments

          Activity

            People

              sebastian.menski Sebastian Menski
              sebastian.menski Sebastian Menski
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Salesforce