DB-010: Dual Anomalies
· One min read
Combined Anomaly: Dirty Read Leads to Lost Update
A more complex scenario with 3 transactions on a non-MVCC system. It shows how T2 performing a 'Dirty Read' on T1's uncommitted data directly enables the 'Lost Update' anomaly when T1 later aborts.
Step: 0/10 | Time: 0
Next TxID: 1
Database State (No Versions)
Current Operation
None
Transaction States & Undo Logs
No active transactions.
Transaction Timelines
0
10
20
30
40
50
60
70
80
90
100
T1
B
W
A
T2
B
R
W
C
T3
B
R
C