SQLite Forum

Proposed updates to https://sqlite.org/howtocorrupt.html
Login
I was recently looking into a database corruption issue that ended up being caused by the POSIX lock quirks mentioned in section 2.2 of https://sqlite.org/howtocorrupt.html.

The code that caused this problem was a bit different than the situation that was described. Rather than operating in a multi-threaded environment, I was dealing with code that did a double fork to daemonize *after* already opening up an SQLite connection. For similar reasons mentioned in section 2.2, this resulted in POSIX locks to be released.

Could you update that section to mention this scenario as well? Having seen a reference to this might have sounded some alarm bells in my head and saved a bunch of debugging time Hopefully it can save others in the future!