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. We tested a lot of crash situations in the past and never
experienced a problem. Now we were very surprised about the missing pages.
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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
