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

Missing Index on Foreign Key ERROR_DETAILS_ID_ in External Task

XMLWordPrintable

      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

        This is the controller panel for Smart Panels app

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

                Created:
                Updated:
                Resolved: