SQLite Forum

sector flush atomic
Login
if the sector write is linear at disk driver layer,sqlite transaction is still atomic?

in this case:
when save the page count(at journal header) to journal file,the page count is 4 bytes size,so if the power lose between the first 2 bytes save in journal file successful and last 2 bytes not save in file. then power restore,the page count at the journal file head is the first 2 bytes value,the last 2 bytes value is missed.the rollback only rewrite the frist 2 bytes count page content to database file.yeah,crictal error happens.

is my personal understanding right?