On Fri, Sep 13, 2013 at 1:00 PM, Andrew Beal <ab...@whoi.edu> wrote: > All, > > When you issue a checkpoint command to the SQLite system and it fails on a > hardware I/O error when interacting with the database, is there a way to > use the WAL to rebuild the database or is the database corrupt beyond > repair at that point? >
That's actually a test scenario for SQLite. The database should be intact, as long as the I/O error didn't erase or change any of the disk content. The next process to open the database file will complete the recovery. If you are in a situation where some of either the database file or the WAL file is unreadable due to hardware problems, then that could lead to corruption. But as long as the files are readable, recovery should always be possible. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
