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