Re: [sqlite] 3.7.7.1 database corruption

2011-11-14 Thread Kees Nuyt
On Mon, 14 Nov 2011 21:03:56 +0100, Kees Nuyt wrote: >I can image. Soryy, I have no more ideas. Oops. Make that: I can imagine. Sorry, I have no more ideas. -- ( Kees Nuyt ) c[_] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite

Re: [sqlite] 3.7.7.1 database corruption

2011-11-14 Thread Kees Nuyt
erienced 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

Re: [sqlite] 3.7.7.1 database corruption

2011-11-14 Thread Alexandr Němec
uot; 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

Re: [sqlite] 3.7.7.1 database corruption

2011-11-14 Thread Kees Nuyt
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 car

Re: [sqlite] 3.7.7.1 database corruption

2011-11-14 Thread Alexandr Němec
once more.   Alex   __ Od: "Richard Hipp" Komu: General Discussion of SQLite Database Datum: 14.11.2011 14:03 Předmět: Re: [sqlite] 3.7.7.1 database corruption 2011/11/14 Alexandr Němec Dear Filip, thanks for your reply.

Re: [sqlite] 3.7.7.1 database corruption

2011-11-14 Thread Richard Hipp
is not used. > > Thanks very much for your help. > > Alex > > __**__**__ > >> Od: "Filip Navara" Komu: General Discussion of SQLite Database Datum: >> 14.11.2011 11:17 >> Předmět: Re: [sqlite] 3.7.7.1 database corruption >> >> Hi Ale

Re: [sqlite] 3.7.7.1 database corruption

2011-11-14 Thread Alexandr Němec
  No, WAL mode is not used.   Thanks very much for your help.   Alex __ Od: "Filip Navara" Komu: General Discussion of SQLite Database Datum: 14.11.2011 11:17 Předmět: Re: [sqlite] 3.7.7.1 database corruption Hi Alexandr, t

Re: [sqlite] 3.7.7.1 database corruption

2011-11-14 Thread Filip Navara
Hi Alexandr, the mailing list doesn't allow attachments. Please send us the output of "pragma integrity_check;" on the corrupted database file. Also, is the database used in WAL mode? Best regards, Filip Navara 2011/11/14 Alexandr Němec : > Dear all, > > we are using SQLite in our projects. We a

[sqlite] 3.7.7.1 database corruption

2011-11-13 Thread Alexandr Němec
Dear all,   we are using SQLite in our projects. We are using the 3.7.7.1 version compiled on Windows platform from the amalgamation file. One of our servers crashed badly (power outage) and after the server restarted, we saw that the database was corrupt (all queries we tried return SQLITE_COR