[sqlite] Problem with using WAL journal mode in embedded system (disk I/O error)

2011-09-26 Thread Korey Calmettes
Hi All, We have been upgrading our embedded Linux system to version 3.7.7.1 of SQLite. We had hopes of using WAL mode to cure some of the database locking issues that we have had. Not sure if it matters but we are running an ARM9 with JFFS2 file system. We are using a very old kernel

Re: [sqlite] Problem with using WAL journal mode in embedded system (disk I/O error)

2011-09-26 Thread Korey Calmettes
ichard Hipp Sent: September 26, 2011 8:38 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Problem with using WAL journal mode in embedded system (disk I/O error) On Mon, Sep 26, 2011 at 11:30 AM, Korey Calmettes <kcalmet...@icontime.com>wrote: > ~ # sqlite3 test.db &

Re: [sqlite] Problem with using WAL journal mode in embedded system (disk I/O error)

2011-09-26 Thread Korey Calmettes
s-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: September 26, 2011 11:36 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Problem with using WAL journal mode in embedded system (disk I/O error) On Mon, Sep 26, 2011 at 2:21 PM, Korey Calmettes <kcalmet...@icontime.com>wrot

Re: [sqlite] Problem with using WAL journal mode in embedded system (disk I/O error)

2011-09-28 Thread Korey Calmettes
...@sqlite.org] On Behalf Of Richard Hipp Sent: September 26, 2011 11:55 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Problem with using WAL journal mode in embedded system (disk I/O error) On Mon, Sep 26, 2011 at 2:48 PM, Korey Calmettes <kcalmet...@icontime.com>wrote: >

[sqlite] Disk I/O Error

2011-10-31 Thread Korey Calmettes
Hello, We are having a random problem with our system that has be puzzled at this point. First a little background. We have an embedded system running an ARM processor and JFFS file system. We are running 3.7.7.1. I e-mailed about a month ago about enabling WAL on our system. Found out

Re: [sqlite] Disk I/O Error

2011-11-01 Thread Korey Calmettes
Of Richard Hipp Sent: October 31, 2011 2:32 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Disk I/O Error On Mon, Oct 31, 2011 at 5:01 PM, Korey Calmettes <kcalmet...@icontime.com>wrote: > Hello, > > We are having a random problem with our system that

Re: [sqlite] Disk I/O Error

2011-11-01 Thread Korey Calmettes
--Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: October 31, 2011 2:32 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Disk I/O Error On Mon, Oct 31, 2011 at 5:01 PM, Korey Calmettes <kcalmet...

[sqlite] SQLite on ARM9 running Linux

2007-03-02 Thread Korey Calmettes
I am planning an embedded project using SQLite an a Cirrus Logic EP9301. I am curious of any difficulties that have been found in either compiling and/or using SQLite in this environment. Thanks for any input that you can provide, Korey

[sqlite] Tracking error 11 : database disk image is malformed.

2012-02-01 Thread Korey Calmettes
Hello All, I have been in the process of getting SQLite 3.7.7.1 working on our ARM based platform and using WAL on some of our database files. Yesterday, I kept getting: Error = 11 : database disk image is malformed We have seen this issue before, but not quite like this. We were manually

Re: [sqlite] Tracking error 11 : database disk image is malformed.

2012-02-02 Thread Korey Calmettes
been to duplicate the problem and examine the file to see if I can see a pattern. (And hopefully find a cause.) Korey On Feb 1, 2012, at 2:28 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 01/02/12 12:57, Korey Calmettes wrote: >> Wha

Re: [sqlite] Tracking error 11 : database disk image is malformed.

2012-02-03 Thread Korey Calmettes
/02/12 10:59, Korey Calmettes wrote: >> If I do happen to recreate the problem, is there a way to track the >> location in the file that the corruption begins and how long the >> corruption is? > > Recreating the problem is the hard part since something isn't working the