Re: [sqlite] Disk I/O Error on Ext3/write-back/barrier FS.

2011-09-20 Thread Berthier, Emmanuel
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dan Kennedy > Are you using synchronous=NORMAL or synchronous=FULL? When opening the database, in sqlite3PagerSetSafetyLevel(), I get: level:3, noSync:0, fullSync:1, sync_flags:2 > What does sqlite3_vfs_f

Re: [sqlite] Disk I/O Error on Ext3/write-back/barrier FS.

2011-09-20 Thread Berthier, Emmanuel
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin > Sorry to say that this subject is one where the longer you spend looking at > it the more annoying it gets. You are not annoying me at all! ;-) > You either have storage devices which supp

Re: [sqlite] Disk I/O Error on Ext3/write-back/barrier FS.

2011-09-20 Thread Berthier, Emmanuel
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin > > That's the usual scenario with spinning media. I'm less familiar with the > > internal workings of flash memory controllers. But people tell me that they > > fail in similar ways. > > Yes

Re: [sqlite] Disk I/O Error on Ext3/write-back/barrier FS.

2011-09-20 Thread Berthier, Emmanuel
> From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dan Kennedy > > Can you post the hex of the first 28 bytes of the journal > file? 000 d5d9 f905 a120 d763 0400 a15c eae6 010 6300 0002 0004 020

Re: [sqlite] Disk I/O Error on Ext3/write-back/barrier FS.

2011-09-20 Thread Berthier, Emmanuel
-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin > Can I ask where a power failure or a crash is involved in your finding at all > ? > Or is the corruption found when programs have only ever run as designed with

Re: [sqlite] Disk I/O Error on Ext3/write-back/barrier FS.

2011-09-20 Thread Berthier, Emmanuel
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Stephan Beal > seek() allows one to seek past the end of the file, so the problem is not > with seek (unless sqlite3's VFS interface castrates it), but probably a > follow-up read() after the seek. It is pe

Re: [sqlite] Disk I/O Error on Ext3/write-back/barrier FS.

2011-09-20 Thread Berthier, Emmanuel
ssion of SQLite Database Subject: Re: [sqlite] Disk I/O Error on Ext3/write-back/barrier FS. On 20 Sep 2011, at 9:43am, Berthier, Emmanuel wrote: > I'm using Sqlite 3.6.22 Froyo Branch on Android 2.3.4 distribution on a > handset with eMMC storage memory. > In case of power-cut (bat

[sqlite] Disk I/O Error on Ext3/write-back/barrier FS.

2011-09-20 Thread Berthier, Emmanuel
Hi, I'm using Sqlite 3.6.22 Froyo Branch on Android 2.3.4 distribution on a handset with eMMC storage memory. In case of power-cut (battery removal or kernel panic), we encounter some rare but critical errors during database rollback sequence: journal file is corrupted: # sqlite3 contacts2.db s