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

Missing Index on Foreign Key ERROR_DETAILS_ID_ in External Task

    Details

    • Type: Bug Report
    • Status: Closed
    • Priority: L3 - Default
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 7.7.0, 7.6.3, 7.7.0-alpha1
    • Component/s: engine
    • Labels:

      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

        Activity

        There are no comments yet on this issue.

          People

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

            Dates

            • Created:
              Updated:
              Resolved: