Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-12071 Official support for CockroachDB
  3. CAM-12192

[BUG] Concurrent DbDeadlockTest blocks on CRDB

XMLWordPrintable

    • Icon: Sub-task Sub-task
    • Resolution: Fixed
    • Icon: L3 - Default L3 - Default
    • 7.14.0, 7.14.0-alpha2
    • None
    • engine
    • None

      Given:
      Execute the DbDeadlockTest on CRDB.

      When:
      The tests tries to continue the test execution after a SELECT.

      Then:
      The test blocks the test thread and testing has to be stopped.

      Expected:

      • The test is executed only on DBs with TX isolation READ_COMMITTED.
      • A new (adjusted) test is provided only for CRDB with TX isolation SERIALIZABLE.

      Notes:

      • The test is designed to test a deadlock situation in a database with a READ_COMMITTED transaction isolation level.
      • Since CRDB uses a SERIALIZABLE level, and blocks READS when they encounter a concurrent write, the test logic produces a deadlock in CRDB.
      • In a real-life scenario the above wouldn't happen since one of the transactions would commit and unblock the waiting READ.

        This is the controller panel for Smart Panels app

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

                Created:
                Updated:
                Resolved: