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
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
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
> 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
-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
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
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
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
8 matches
Mail list logo