It was a typo. I was setting fullsync when the correct pragma name is fullfsync.
On Fri, Sep 26, 2008 at 9:50 AM, Jeffrey Rennie (レニー) <[EMAIL PROTECTED]>wrote: > > 2008/9/25 D. Richard Hipp <[EMAIL PROTECTED]> > >> >> You are confusing the statement journal with the rollback journal. >> The statement journal has nothing to do with database recovery - that >> is the task of the rollback journal. So the statement journal can be >> deleted at will without damaging the database. And, in fact, the >> statement journal is opened with delete-on-close. >> > > Indeed I was. > > I gained some more insight into the problem. I set a breakpoint on line > 950 of os_unix.cc: > > #if HAVE_FULLFSYNC > if( fullSync ){ > >>> rc = fcntl(fd, F_FULLFSYNC, 0); > }else{ > rc = 1; > } > > > And the breakpoint never hits, no matter what pragmas I set! Instead, it > always executes the rc = 1; line. > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users