On Nov 26, 2009, at 12:01 AM, Ronny Dierckx wrote: > Dear list, > > I'm using SQLite 3.6.20 on an ARM Linux device which uses the UBIFS > filesystem (on OneNAND flash). > > When I perform a database update, and cut the power a few seconds > later, the > changes are rolled back > when the device restarts. This is because after the restart the > journal file > has re-appeared in the filesystem. > If I perform a manual sync command in the shell before cutting the > power, > everything works fine. > Does anyone else have experience with running SQLite on UBIFS? > > Before switching to UBIFS we were using our application on a JFFS2 > filesystem without any problems.
Not a solution, but you could try experimenting with "PRAGMA journal_mode=persist" or "PRAGMA journal_mode=truncate" to work around the problem. Dan. > > Thanks, > > Ronny Dierckx > > > _______________________________________________ > 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