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

Reply via email to