phantom read
one transaction modifies rows matching a predicate that another ongoing transaction had read (P3)
phantom read in a sentence
“A phantom appeared when a row matching the WHERE clause was inserted mid-transaction.”
Related Words
stale read
an operation begins after another ends but appears to execute before the prior operation
amnesia
a node forgets information; total amnesia means forgetting everything, partial amnesia occurs after crashes
bit rot
gradual storage corruption from cosmic rays, thermal stress, or media degradation over time
byzantine fault
a node takes arbitrary actions including malicious ones; requires more than two-thirds loyal nodes for consensus
crash
a node stops executing code until it is restarted
crash-stop
a failure model where a node stops executing and never recovers