Re: [sqlite] Potential bug in crash-recovery code: unlink() and friends are not synchronous

2013-05-21 Thread Thanumalayan Sankaranarayana Pillai
Hi all, Did anyone look into this? I might be setting some config option wrong, so it would be great if you sent me a "you did something wrong" reply if you feel that I might have the wrong config (or might be doing something totally idiotic). I tested with a few other Linux machines and a few

Re: [sqlite] Potential bug in crash-recovery code: unlink() and friends are not synchronous

2013-05-22 Thread Thanumalayan Sankaranarayana Pillai
On Tue, May 21, 2013 at 11:52 AM, Richard Hipp <d...@sqlite.org> wrote: > > On Tue, May 21, 2013 at 12:04 PM, Thanumalayan Sankaranarayana Pillai < > madth...@cs.wisc.edu> wrote: > > > Hi all, > > > > Did anyone look into this? I might be setting some co

Re: [sqlite] Potential bug in crash-recovery code: unlink() and friends are not synchronous

2013-05-22 Thread Thanumalayan Sankaranarayana Pillai
made durable in some systems. Do answer [c] too, if that's possible. I still am examining SQLite and a bunch of other DBMSs for power-crash scenarios, so might come back to badger you about "bugs" in the future. -- Thanumalayan Sankaranarayana Pillai (Graduate student at the University

Re: [sqlite] Potential bug in crash-recovery code: unlink() and friends are not synchronous

2013-05-23 Thread Thanumalayan Sankaranarayana Pillai
much of a loss in > durability (what other than 5 seconds) would be "good enough" in most > cases? ... Again, sorry for the spam; my research is trying to make > sense of the flushing-mess in the entire storage stack, and feedback would > be extremely usef

Re: [sqlite] Database Corrupted!

2013-05-27 Thread Thanumalayan Sankaranarayana Pillai
Hi Woody, If the log messages that you see are "chunk nnn not erased", it might probably be an error between your NAND device and YAFFS2 (according to a couple of Google searches). Ref: http://osdir.com/ml/linux.file-systems.yaffs/2006-09/msg00033.html -- Thanu On Mon, May 27, 2013 at 10:22

Re: [sqlite] Database Corrupted!

2013-05-28 Thread Thanumalayan Sankaranarayana Pillai
Woody, this mailing list might not be the best place to discuss problems with YAFFS2. Saying that, a simple test could be to almost fully fill the YAFFS2 partition with a bunch of files, then read those files and make sure the files have the data they are supposed to have. Files should have