And not get in an infinite loop, and not harm the startup time of the process in... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

hobs on July 24, 2025 | parent | context | favorite | on: PSA: SQLite WAL checksums fail silently and may lo...

And not get in an infinite loop, and not harm the startup time of the process inordinately, and...

This is just basically how a WAL works, if you have an inconsistent state the transaction is rolled back - at that point you need to redo your work.

HelloNurse on Aug 5, 2025 [–]

The WAL can be replayed up to the first corrupted block, period. It's like a rockslide destroying a road: you can progress up to the gap or rubble heap, but you cannot expect to use the unharmed road past the insurmountable obstacle.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact