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

Concurrent insert of new variables leads to FK Violations

XMLWordPrintable

    • Icon: Bug Report Bug Report
    • Resolution: Fixed
    • Icon: L3 - Default L3 - Default
    • 7.1.0
    • None
    • engine
    • None

      Situation:
      Two concurrent transactions add a new variable to an execution.
      In this case, optimistic locking does not work since the row is freshly inserted. (cannot lock on non-existing row)
      As a result we end up with two rows which have the same execution id and the same name.
      When deleting the execution, only one of the rows is deleted which causes a Foreign Key constrain violation since the second row still references the Execution.

      Could be fixed with an integety constraint on EXECUTION_ID and NAME_ as well es TASK_ID_ and NAME_

      Failing testcase:
      https://github.com/camunda/camunda-bpm-platform/commit/6fffa99cbfe91204f402174349a8f1c87347efe1

      See also:
      https://groups.google.com/forum/?fromgroups#!topic/camunda-bpm-dev/WPHPzBCsTL0

        This is the controller panel for Smart Panels app

              sebastian.menski Sebastian Menski
              meyer Daniel Meyer
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: