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

CRDB SQL selects require a tx retry

XMLWordPrintable

    • Icon: Bug Report Bug Report
    • Resolution: Unresolved
    • Icon: L3 - Default L3 - Default
    • None
    • 7.14.0
    • engine
    • None

      Given:
      A Process Engine running on CockroachDB.

      When:
      The Process Engine performs a READ operation (SQL select).

      Then:
      It's possible that the operation will fail with a TransactionRetryError and require a retry.

      Expected:
      The error is reported as a CrdbTransactionRetryException, so that it can be detected and handled correctly by the provided (defined) Process Engine mechanisms.

      Technical note:
      This case of CRDB concurrency error is rare but possible in cases when a concurrent READ falls in the "uncertainty window", where it can't be determined which TX timestamp is older. In these cases, CRDB prefers to abort the transaction, instead of making the wrong assumption.

        This is the controller panel for Smart Panels app

              Unassigned Unassigned
              nikola.koevski Nikola Koevski
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: