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

CRDB SQL selects require a tx retry

    XMLWordPrintable

Details

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

    Description

      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.

      mgm-controller-panel

        This is the controller panel for Smart Panels app

        Attachments

          Issue Links

            is related to

            Feature Request - A new feature of the product, which has yet to be developed. CAM-12071 Official support for CockroachDB

            • L3 - Default - Minor issue or issue with existing workaround, feature requests and questions
            • Closed

            Activity

              People

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

                Dates

                  Created:
                  Updated:

                  Salesforce