Re: [sqlite] SIGBUS error in case of disk full with WAL mode

2012-03-10 Thread Kees Nuyt
On Sat, 10 Mar 2012 10:25:10 +0900, Yongil Jang wrote: >Following sentences are found on sqlite source. >And, there is a comment about database corruption. >Could I get more detailed explanation about this? > >The use of the SQLITE_SHM_DIRECTORY compile-time >** option results in an incompati

Re: [sqlite] SIGBUS error in case of disk full with WAL mode

2012-03-09 Thread Yongil Jang
Dear all, Thank you for your help. I tried -DSQLITE_SHM_DIRECTORY="/dev/shm" option for make file. It works very well. (One line should be added to make "/dev/shm" directory before calling file open) But, I didn't tried to use locking mode because of multiple processes can use same sqlite databa

Re: [sqlite] SIGBUS error in case of disk full with WAL mode

2012-03-08 Thread Scott Hess
On Thu, Mar 8, 2012 at 9:28 AM, Pavel Ivanov wrote: >> Question:  Does anybody know of a better way to get memory shared among >> processes other than to create a fake file and mmap() it?  Are there some >> magic options to mmap() (perhaps Linux-only options) that prevent it from >> actually writi

Re: [sqlite] SIGBUS error in case of disk full with WAL mode

2012-03-08 Thread Pavel Ivanov
> Question:  Does anybody know of a better way to get memory shared among > processes other than to create a fake file and mmap() it?  Are there some > magic options to mmap() (perhaps Linux-only options) that prevent it from > actually writing to disk? Why don't you use shm_open() instead of a re

Re: [sqlite] SIGBUS error in case of disk full with WAL mode

2012-03-08 Thread Black, Michael (IS)
stems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Richard Hipp [d...@sqlite.org] Sent: Thursday, March 08, 2012 11:03 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] SIGBUS error in case of disk full with WAL mode On Thu, Mar 8, 2012

Re: [sqlite] SIGBUS error in case of disk full with WAL mode

2012-03-08 Thread Richard Hipp
te.org] > on behalf of Richard Hipp [d...@sqlite.org] > Sent: Thursday, March 08, 2012 10:35 AM > To: General Discussion of SQLite Database > Subject: EXT :Re: [sqlite] SIGBUS error in case of disk full with WAL mode > > On Thu, Mar 8, 2012 at 10:58 AM, Yongiljang wrote: > >

Re: [sqlite] SIGBUS error in case of disk full with WAL mode

2012-03-08 Thread Black, Michael (IS)
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Richard Hipp [d...@sqlite.org] Sent: Thursday, March 08, 2012 10:35 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] SIGBUS error in case of disk full with WAL mode On Thu, Mar 8,

Re: [sqlite] SIGBUS error in case of disk full with WAL mode

2012-03-08 Thread Richard Hipp
On Thu, Mar 8, 2012 at 10:58 AM, Yongiljang wrote: > Dear all, > I'm an android developer in charge of sqlite database. > > Some days ago, I'd got a SIGBUS error from sqlite when there is no space > in current partition and WAL journal mode is used. > This error was occurred from memset function

[sqlite] SIGBUS error in case of disk full with WAL mode

2012-03-08 Thread Yongiljang
Dear all, I'm an android developer in charge of sqlite database. Some days ago, I'd got a SIGBUS error from sqlite when there is no space in current partition and WAL journal mode is used. This error was occurred from memset function in libc that was called by libsqlite and debugging information