Lost Update

noun

say it: “LAWST up-DAYT” /ˈlɔst ʌpˈdeɪt/

A mistake where two people change the same record at about the same time and one change silently overwrites the other.

What is Lost Update in a relational database?

Lost Update — A concurrency problem where one write unintentionally overwrites another transaction's write.

In a sentence

  • “Changing the count with $inc in the database avoids a lost update.”
  • “Two cashiers sold the last mug at once, and a lost update left the stock at 1 instead of -1.”

Level: Freelancer · More Database terms at this level

Updated