---
answer: direct
beat: system-design
source: 1 article · updated: November 14, 2026
---

Why do update locks exist?

Two transactions that both take a shared lock to read a row, then both try to upgrade to exclusive to write it, wait on each other forever. An update lock says I will probably write: only one transaction can hold it, so the upgrade can never deadlock against another reader-turned-writer.

Answered in

Database Locks Explained: Shared, Exclusive, Update, Key-Range and Granularity

What each lock mode allows, why update locks exist, how key-range locks stop phantoms, and when row, page or table locks cost you concurrency.

Crashtech Editorial November 14, 2026 System Design & Architecture

Read the full analysis

Other questions this article answers

More system design & architecture questions

Every answer on Crashtech is written by the editor of the article it comes from — never auto-summarised. Browse all answers or the System Design & Architecture beat.