recall

← recall

write skew term

two transactions read overlapping data, write disjoint, both commit

Anomaly under snapshot isolation. Classic example: two doctors both check 'is anyone else on call?' (yes, the other), both decide they can leave, both leave — now nobody's on call. Prevented by serializable isolation.

topics: consistency, databases

references: