On Mon, May 27, 2013 at 8:28 AM, Simon Slavin <[email protected]> wrote:
> > On 27 May 2013, at 1:25pm, Clemens Ladisch <[email protected]> wrote: > > > Woody Wu wrote: > >> I have a testing code, attached in this email, if continuously run it > for > >> 20 - 40 hours, the sqlite database will be corrupted. > >> > >> The application is running on an ARM Linux system with Yaffs2 filesystem > >> on NAND flashes. > > > > I'd guess that the flash is not very reliable. > > I test on Flash drives. No problems. But I don't use yaffs2, I use FAT > and HFS+. I'm not saying there's anything wrong with yaffs2. > (1) Do a web search for "counterfeit flash". There are a lot of dodgy flash drives and flash memory chips in circulation. Simon might be using good chips whereas Woody might have a bad one. (2) I'm less willing to give yaffs2 a pass. Yaffs2 bypasses much of the common filesystem code in the Linux kernel and attempts to do its own thing. This has been a persistent source of issues. I recommend that Woody try Ext4 instead. All that said: I have compiled Woody's test program and am running it now on a Linux workstation. We'll see what happens after 40 hours.... -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
