Re: [sqlite] Journal file corrouption on power failure .

2006-11-10 Thread drh
"jayanth KP" <[EMAIL PROTECTED]> wrote: > I have set PRAGMA synchronous=FULL; > Do your power-off-corruption thing and send me copies of both the journal file and the original database and I will see what I can find. -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] Journal file corrouption on power failure .

2006-11-10 Thread drh
"jayanth KP" <[EMAIL PROTECTED]> wrote: > 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. > > Try setting PRAGMA synchronous=FULL; --

[sqlite] Journal file corrouption on power failure .

2006-11-10 Thread jayanth KP
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