On Fri, Feb 17, 2012 at 2:45 PM, Angelo, Bryan [USA]
<angelo_br...@bah.com>wrote:

> All,
>
> I am using SQLite version 3.7.8.  I am receiving the SQLITE_IOERR result
> code from sqlite3_prepare_v2 function when attempting to compile a PRAGMA
> statement on a read-only database where a rollback journal file also
> exists.  Is it possible to force SQLite to ignore rollback journal files
> (or WAL files) ?
>

If you have a hot journal (a rollback journal that still exists and has a
non-zero header) that indicates that the previous process to write to the
database did not shutdown cleanly.  The journal must be rolled back in
order to restore the database to a consistent state.  SQLite is not able to
read the database until it has been recovered by rolling back the hot
journal.


-- 
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