I am using SQLite version 3.7.14.1.
On Wed, Dec 12, 2012 at 2:56 PM, dd <durga.d...@gmail.com> wrote: > Hi Michael > > I am using journal mode truncate. Explicitly, I am not running any pragma > for synchronous. (i think, it's default value is 2 - Full). > > Regards, > d > > > On Tue, Dec 11, 2012 at 5:08 PM, Michael Black <mdblac...@yahoo.com>wrote: > >> I don't see in the thread where you say what journal mode you're running >> in >> or your synchronous setting. >> That may explain your problem and be easily fixable. >> >> The other thing is to compile your system with stack protection and see if >> that can trap the problem. >> >> If it's just stack corruption you should be able to trigger the error >> locally much more quickly with stack protection on then in a random >> system. >> >> >> >> >> >> -----Original Message----- >> From: sqlite-users-boun...@sqlite.org >> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of dd >> Sent: Tuesday, December 11, 2012 1:00 AM >> To: General Discussion of SQLite Database >> Subject: Re: [sqlite] table backup >> >> Hi Roger, >> >> I don't have any clue. Two databases are corrupted. First one, while >> inserting 20,000 records suddenly sqlite thrown disk io error at 4,000 >> record. No clue. >> >> Second database corrupted when my application crashed. But that time, >> second database was not opened. >> >> So, I am planning to choose backup solution instead of investigating >> corruption. >> >> I discussed this issue in my previous post. >> >> Any sample application for virtual table option. >> >> Best Regards, >> d >> >> >> On Mon, Dec 10, 2012 at 9:09 PM, Roger Binns <rog...@rogerbinns.com> >> wrote: >> >> > -----BEGIN PGP SIGNED MESSAGE----- >> > Hash: SHA1 >> > >> > On 09/12/12 21:44, dd wrote: >> > > Sometimes, sqlite databse corrupts. >> > >> > That is the problem you need to fix. If you have a system that is >> > unreliable then it will also corrupt your backups. >> > >> > http://www.sqlite.org/lockingv3.html#how_to_corrupt >> > http://www.sqlite.org/howtocorrupt.html >> > >> > > So, I want to take online backup of specific table. Not entire >> > > database. >> > >> > Do you need to take a backup on every change, as part of the change or >> is >> > it acceptable to make backups periodically and possibly lose >> intermediate >> > versions of the data? >> > >> > For a periodic backup you can iterate over the table contents and output >> > them in a convenient format for you, such as CSV or SQL statements. >> > >> > For saving all data you can use triggers to save historical values in a >> > second table and then do a periodic backup. >> > >> > If it must be immediate then the only choice available is to use a >> virtual >> > table and do the backup during writes/sync. >> > >> > This is all considerably more work than figuring out why you are getting >> > corruption in the first place. >> > >> > Roger >> > -----BEGIN PGP SIGNATURE----- >> > Version: GnuPG v1.4.11 (GNU/Linux) >> > >> > iEYEARECAAYFAlDGF2IACgkQmOOfHg372QTo9gCfSQQwreSvsa9lrV/wj0YC2Fvj >> > LT0AmwdZSaNvVJJuic3gLYmQfn9YX6x3 >> > =Gx1r >> > -----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 >> >> _______________________________________________ >> 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