On Fri, Nov 8, 2013 at 10:06 AM, Mario M. Westphal <m...@mwlabs.de> wrote:
> > 1. PRAGMA integrity_check(100) > 2. VACUUM > 3. ANALYZE > > My idea was that these routines should reveal problems reading from or > writing to the database file. > > Today I had a case where my diagnosis considered a database as OK (all > SQLite functions used in the diagnosis returned SQLITE_OK), but the > database > still runs into the dreaded "disk image malformed" problem shortly > afterwards :-( > You should never get an SQLITE_CORRUPT error after querying a database file that is unchanged since a successful PRAGMA integrity_check. If you have a contrary example, please send me a copy of the database file via private email. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users