Re: Re: [sqlite] Database Corruption and fix suggsted

2006-11-14 Thread jayanth KP
Hi Richard, It is a linux platform compiled with glibc library. And os.c is not changed. Regards Jayanth On Tue, 14 Nov 2006 [EMAIL PROTECTED] wrote : >"jayanth KP" <[EMAIL PROTECTED]> wrote: > > > > 2.) I compiled sqlite 2.8.13 for a proprietary platform that we are using > > for

Re: Re: [sqlite] Database Corruption and fix suggsted

2006-11-14 Thread jayanth KP
Hi Richard, Thanks.. As you said. Now I tried to open the database that is not corrupted with sqlite 2.8.13 (that we have). I have an intresting observation. 1.) I compiled sqlite 2.8.13 for PC (little endian) and ran sqlite binary on the directory that had the journal also. RESULT: -

Re: [sqlite] Database Corruption and fix suggsted

2006-11-14 Thread drh
"jayanth KP" <[EMAIL PROTECTED]> wrote: > > 2.) I compiled sqlite 2.8.13 for a proprietary platform that we are using for > development(little endian) and ran sqlite binary on the directory that had > the journal also. > > RESULT: > --- > The file is getting corrupted. > > > Please can y

Re: [sqlite] Database Corruption and fix suggsted

2006-11-13 Thread drh
"jayanth KP" <[EMAIL PROTECTED]> wrote: > Hi Richard, > I downloaded the sqlite-2.8.17.bin from sqlite.org (sqlite-2.8.17.bin.gz) > and ran it on media.vdb.corrupt. I am getting the following error . I am > confused how were you able to open this file. Plz open media..vdb.corrupt. > Once a

Re: Re: [sqlite] Database Corruption and fix suggsted

2006-11-13 Thread jayanth KP
Hi Richard, I downloaded the sqlite-2.8.17.bin from sqlite.org (sqlite-2.8.17.bin.gz) and ran it on media.vdb.corrupt. I am getting the following error . I am confused how were you able to open this file. Plz open media.vdb.corrupt. ---

Re: [sqlite] Database Corruption and fix suggsted

2006-11-13 Thread drh
"jayanth KP" <[EMAIL PROTECTED]> wrote: > Hi, > > I am using sqlite 2.8.13 which is supposed to have fix for "Corrupt > problem encountered on Windows NT platform" check this > (http://www.sqlite.org/cvstrac/tktview?tn=599). But the code in pager.c still > has the following rc = write32bits

[sqlite] Database Corruption and fix suggsted

2006-11-12 Thread jayanth KP
Hi, I am using sqlite 2.8.13 which is supposed to have fix for "Corrupt problem encountered on Windows NT platform" check this (http://www.sqlite.org/cvstrac/tktview?tn=599). But the code in pager.c still has the following rc = write32bits(&pPager->jfd, pPager->noSync ? 0x : 0); .

[sqlite] Database Corruption and fix suggsted

2006-11-12 Thread jayanth KP
Hi, I am using sqlite 2.8.13 which is supposed to have fix for "Corrupt problem encountered on Windows NT platform" check this (http://www.sqlite.org/cvstrac/tktview?tn=599). But the code in pager.c still has the following rc = write32bits(&pPager->jfd, pPager->noSync ? 0x : 0); .