[adobeeee]

Thank you for explaining so well and clearly!

To you and others, are there any other scenarios too that happen in production?

[philix001]

Enough material here to scare anyone about databases

https://jepsen.io/talks

[marcosdumay]

Some things I have seen in production:

The disk become inoperative during a write, this can be either silent or writes start to return errors. Again, how does the database look like after the problem is solved.

A large operation exceeds the capacity of the server to deal with intermediary state. It runs out of memory, disk, or in some not great DBs it loses control of some locks and gets deadlocked. Can it recover with only the partial log data?

Disks lie about data being written, what happens if one of the problems happen between the disk saying the data was written and it actually getting written?

And, of course, when you move beyond a single server things get way more complex.