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

Unnecessary LOCK on ByteArray-Table during DELETE VariableUpdate

XMLWordPrintable

      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

        This is the controller panel for Smart Panels app

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

                Created:
                Updated:
                Resolved: