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

Unnecessary LOCK on ByteArray-Table during DELETE VariableUpdate

    XMLWordPrintable

    Details

      Description

      Problem Description:
      when deleting a HistoricProcessInstance, the following SQL statement is executed:

      delete from ACT_GE_BYTEARRAY where ID_ in
      (select BYTEARRAY_ID_ from ACT_HI_DETAIL where PROC_INST_ID_ = ?

      if there are many values in the ACT_HI_DETAIL table, this can lock the ACT_GE_BYTEARRAY for quite some time

      AT:

      • refactor deletion of HistoricVariableUpdate to mirror deletion of HistoricVariableInstance

        Attachments

          Activity

            People

            Assignee:
            smirnov Roman Smirnov
            Reporter:
            meyer Daniel Meyer
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: