SQL Practice Logo

SQLPractice Online

Level 9 - DistinguishedScenario-Based Questionsm3 concurrency isolation deadlocks

Retry and Idempotency for Deadlock Victims

Design scenario: deadlock victim retries currently duplicate ledger entries. Propose one retry policy and one idempotency key strategy that fixes correctness.