-My journal mode is set to WAL, synchronous mode is NORMAL and Checkpoint mode is Manual.
Transactions are written to the WAL file, therefore, even if the WAL file is lost, I should be able to retrieve the database without corruption.(sacrificing some data ofcourse) ? Moreover, I do know that there was no checkpoint in progress when the power was turned OFF. Hence syncs should not be a problem ? -Sreekumar On Mon, Jan 23, 2012 at 3:00 PM, Roger Binns <rog...@rogerbinns.com> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 23/01/12 01:03, Sreekumar TP wrote: > > is it possible to find out if sqlite was in the middle of a transaction > > when the power off occurred ? > > WAL mode has the transactions in a separate file. Normal mode alters the > database and keeps the original data in a rollback journal. > > However unless you identify the underlying cause (eg disk lying about > syncs) it won't help since you have to assume all data you see is a lie. > > Roger > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.11 (GNU/Linux) > > iEYEARECAAYFAk8dKLYACgkQmOOfHg372QTuBQCgwFLnZ5108QRfelWm11qDiRjY > szYAn0tgEw0klQqRllRSyepezxt550ha > =SRbO > -----END PGP SIGNATURE----- > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users