Invention Grant
- Patent Title: Deadlock detection in distributed databases
-
Application No.: US17647752Application Date: 2022-01-12
-
Publication No.: US11809916B2Publication Date: 2023-11-07
- Inventor: Chen Luo , Alexander Miller , William Waddington
- Applicant: Snowflake Inc.
- Applicant Address: US MT Bozeman
- Assignee: Snowflake Inc.
- Current Assignee: Snowflake Inc.
- Current Assignee Address: US MT Bozeman
- Agency: Schwegman Lundberg & Woessner, P.A.
- Main IPC: G06F9/52
- IPC: G06F9/52 ; G06F16/23 ; G06F16/25

Abstract:
The subject technology performs a locking operation on a first set of keys by a first statement of a first transaction. The subject technology determines that a conflict occurred between the first statement and a second transaction. The subject technology determines that the second transaction has yet to complete after a predetermined period of time. The subject technology performs a deadlock detection process where the subject technology stores a key and value in a table indicating the first transaction and the second transaction, detects, based at least in part on a graph traversal of the table starting from the first transaction, a cycle between the first transaction and the second transaction, and determines that the first transaction is a youngest transaction in the detected cycle. The subject technology ceases execution of the first transaction in response to the first transaction being a youngest transaction in a detected cycle.
Public/Granted literature
- US20220350677A1 DEADLOCK DETECTION IN DISTRIBUTED DATABASES Public/Granted day:2022-11-03
Information query