On Mon, 14 Nov 2011 18:24:46 +0100, "Alexandr N?mec" <a.ne...@atlas.cz> wrote:
>Thanks again for your answer, > > no, no dangerous pragmas, no journal file removing. > Our file system is NTFS so I hope that no stupid > things are done by the file system :). In fact, > we changed just two things only in the amalgamation file > - we increased SQLITE_MAX_PAGE_COUNT to 2 000 000 000 > and are using SQLITE_THREADSAFE 2 > - we are using multiple database files from inside one > application, but there are separate database connections > for each file and every connection is accessed by a single > thread only (but two queries for two different files using > two different connections can run simultanously in our app). > So I hope we are correct here. That all sounds healthy to me. > We tested a lot of crash situations in the past and never > experienced a problem. > Now we were very surprised about the missing pages. I can image. Soryy, I have no more ideas. >Thanks. > >Alex > >______________________________________________________________ >> Od: "Kees Nuyt" >> Komu: >> Datum: 14.11.2011 15:52 >> P?edm?t: Re: [sqlite] 3.7.7.1 database corruption >> >On Mon, 14 Nov 2011 14:16:46 +0100, "Alexandr N?mec" > wrote: > >> Dear Richard, >> >> huh, thanks very much for the information, I see. >> But anybody having an idea how this can happen? >> There was a power outage and after restart 6 pages >> of the database file are missing... >> We checked the disk carefuly, no bad sector etc. >> What can be the reason for this? > >The disk or the filesystem may have confirmed a write or sync >while in fact the data wasn't on disk yet. >Maybe the filesystem metadata is updated in a separate >transaction, or your filesystem doesn't journal metadata. >fsck only repairs inconsistencies it can find, depending on teh >filesystem used there are quite a few corruptions it cannot detect >nor repair. > >Did you use any dangerous PRAGMA to speed things up, like running >without database journals? > >Does some startup script remove journal files before the database >is connected to by an application? -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users