Two phase locking is an old method of ensuring serializable transactions using locks. A common issue with non-serializable isolation in the fact of concurrent writes is the lost update problem. Here’s an example of a lost update, lets assume: Some databases will detect a write conflict like this and raise an error and others may […]