On Thu, Dec 23, 2010 at 3:10 PM, Max Vlasov <max.vla...@gmail.com> wrote:

> Hi,
> I experimented with artificial power loss (using hd box) and 3.7.4 both
> library and shell didn't restore the files to the initial state. 3.6.10
> restores successfully. I don't know whether it's related the the contents of
> the file, but here the db files:
>  <http://www.maxerist.net/downloads/dbwithjournal.zip>
>

I did additional tests without power loss (just by killing the process). The
result is the same (both the db and journal still exist) only  when no
single change is written to the db file (the original db and the db after
the interruption are binary the same) and because of this it seems that the
only problem is that the journal file is not deleted. If there was a real
write to the db file, the restoration deletes the journal

Max
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to