Race Two Patients for One Slot
Concurrency Control: Pessimistic Row Lock vs. Database Constraint Defense
◄ Prev
Play ▶
Next ►
Reset ↺
Remove the Lock
Timeline
T0: INIT
LANE 1: PATIENT A (TX A)
LANE 2: PATIENT B (TX B)
DATABASE STATE & CONSTRAINTS
SLOT 09:30 AM
STATUS: OPEN
ACTIVE TRANSACTION BOUNDARY (PATIENT A)
TABLE: APPOINTMENTS
0 RECORDS
TABLE: TRANSACTIONAL_OUTBOX
EMPTY (0 PENDING)
COURIER DISPATCH
IDLE
CONSTRAINT: appointments_one_active_per_slot (UNIQUE INDEX)
1. TAP BOOK 9:30
Patient A App
2. LOCK SLOT
SELECT FOR UPDATE
3. WRITE DATA
Appt + Outbox
4. COMMIT TX
Release Locks
200 OK
Slot Booked
1. TAP BOOK 9:30
Patient B App
2. LOCK SLOT
SELECT FOR UPDATE
3. RE-CHECK SLOT
findActiveForSlot()
409 TAKEN
Conflict
System Status:
Click or step through the timeline to observe race condition dynamics.