Race Two Patients for One Slot

Concurrency Control: Pessimistic Row Lock vs. Database Constraint Defense

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.