On Mon, 14 Nov 2011 14:16:46 +0100, "Alexandr N?mec" <a.ne...@atlas.cz> 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
