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

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 proprie

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

. Please can you suggest to me what could be the issue. Or suggest to me where to look for this issue. Thanks and Regards Jayanth On Mon, 13 Nov 2006 [EMAIL PROTECTED] wrote : >"jayanth KP" <[EMAIL PROTECTED]> wrote: > > Hi Richard, > > I downlo

[sqlite] Database Corruption and fix suggsted

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(>jfd, pPager->noSync ? 0x : 0); . But as

[sqlite] Database Corruption and fix suggsted

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(>jfd, pPager->noSync ? 0x : 0); . But as

[sqlite] Journal file corrouption on power failure .

Hi, I have a question regarding powerfailure. I am using sqlite version 2.8.13 . I am seeing that the database is getting corrupted after power failure during delete database entry operation. Here are my observation that may give you gugs some insight: 1. I see a journal file in the

Re: Re: [sqlite] database corrouption during power failure

of the orginal data does not happen. But the journal file is removed. I am suprised how can journal be be present and still database corruption happen.. Please help me resolving this issue. Bye Jayanth On Mon, 23 Oct 2006 Dennis Cote wrote : >jayanth KP wrote: >>But how d

Re: Re: [sqlite] database corrouption during power failure

Hi Dennis Cote, But how do we read the current synchronous value using C interface. Plz reply. Regards Jayanth On Mon, 16 Oct 2006 Dennis Cote wrote : >jayanth KP wrote: >>Thanks for ur reply. I searched in the whole source code i could not find >> SQLITE_NO_SYNC

Re: Re: [sqlite] database corrouption during power failure

". 3) In another scenario sqlite_open() did not detect the corruption. But any subsequent calls is not successful. For example if we start sqlite application and run .tables , nothing is returned. Thanks and regards Jayanth On Fri, 13 Oct 2006 [EMAIL PROTECTED] wrote : >"j

[sqlite] [sqlite]: How does a transaction work

Hi, I wanted to know how does a transaction work.. In the following example shown below, where is the transaction updated. Is it in the memory or some temp file or is it directly written to the database file. Please give more internal details on this. sqlite_exec_printf(pDBHandle,"begin

Re: Re: [sqlite] database corrouption during power failure

Hi, Please can anybody respond to this question. I am able to hits is issue pretty often now... Regards, Jayanth On Fri, 06 Oct 2006 [EMAIL PROTECTED] wrote : >"jayanth KP" <[EMAIL PROTECTED]> wrote: > > Hi, > >I have a question regarding power f

Re: Re: [sqlite] database corrouption during power failure

006 [EMAIL PROTECTED] wrote : >"jayanth KP" <[EMAIL PROTECTED]> wrote: > > Hi, > >I have a question regarding power failure handling in sqlite 2.8.3. > > > > When the power is switched off during a database write like > > (in

[sqlite] database corrouption during power failure

Hi, I have a question regarding power failure handling in sqlite 2.8.3. When the power is switched off during a database write like (insert/update), in next reboot database is getting corroupted. The database is in a ext3 partition on the harddisk (linux 2.6). Also i tried the

[sqlite] test mail - plz ignore