On 6 Sep 2012, at 3:13pm, Richard Hipp <d...@sqlite.org> wrote: > If the last writer to the database file crashed and left a hot > journal<http://www.sqlite.org/atomiccommit.html#section_4_2>then the > next reader to come along must rollback that journal before it can > start reading, and that will require write access. We have encountered > cases where companies accidently publish a gazillion copies of a CDROM that > contains a hot journal. The database on such CDROMs are unreadable.
Ouch. Yeah, I guess that's going to happen occasionally. Suppose you open a database in read-only mode (using SQLITE_OPEN_READONLY) and SQLite finds a hot journal for it. Is tidying up the hot journal done even in _READONLY, or do you immediately get a result indicating an error, or do you get an error result later ? (I could test this on my Mac, but I don't know whether the results are documented and cross-platform or the result of my particular setup.) Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
