Re: [sqlite] Re: database locked

2006-08-22 Thread Laura Longo
Do you have the 'fuser' command in your flavor of linux/unix? http://linux.about.com/library/cmd/blcmdl1_fuser.htm Yes! Could this help? Sorry for this stupid question, I've read the man pages... it's a wonderful command! Thank you Jay! Laura

Re: [sqlite] Re: database locked

2006-08-22 Thread Laura Longo
Do you have the 'fuser' command in your flavor of linux/unix? http://linux.about.com/library/cmd/blcmdl1_fuser.htm Yes! Could this help? - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] libsqlite3.so

2006-08-22 Thread Laura Longo
"Laura Longo" <[EMAIL PROTECTED]> wrote: Hi Richard, I've tried with mkso.sh but an error has immediately stopped me: make: *** No rule to make target `target_source'. Stop. You need to make a copy of Makefile.linux-gcc into your build directory, change the name t

Re: [sqlite] Re: database locked

2006-08-22 Thread Laura Longo
- Original Message - From: "Jay Sprenkle" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Tuesday, August 22, 2006 6:06 PM Subject: Re: [sqlite] Re: database locked On 8/22/06, Christian Smith <[EMAIL PROTECTED]> wrote: Laura Longo uttered: &g

Re: [sqlite] Re: database locked

2006-08-22 Thread Laura Longo
Try using sqlite3_busy_timeout(), to get round the temporary locks if possible. SQLite will retry locked database access until the command either succeeds or times out. http://www.sqlite.org/capi3ref.html#sqlite3_busy_timeout If this does not fix your problem, it is possible that an

Re: [sqlite] libsqlite3.so

2006-08-22 Thread Laura Longo
Hi Clay, I'm workink under Linux (CentOS), kernel 2.6.16... That's the right file. It might be helpful to know what platform you're building on, and if that platform supports shared libraries. Shared libraries are usually built by default on platforms that support them. As for the source to

[sqlite] libsqlite3.so

2006-08-22 Thread Laura Longo
Hi all, I would like to view the source code of libsqlite3.so because of a problem with sqlite3_get_table function... I have a question: in the file sqlite-3.3.7.tar.gz that I find at http://www.sqlite.org/download.html, are there also the source code of the library? If the answer is no, where

Re: [sqlite] Re: database locked

2006-08-22 Thread Laura Longo
Laura, 'df -h' should give you some hints, or 'showmount'. I run on BSD not Linux, but most unix like OS's will tell you if the mount point is a hard drive or a remote mount, in which case, it will have a hostname:/path instead of a /dev/dsk device file as the device/partition information.

Re: [sqlite] Re: database locked

2006-08-21 Thread Laura Longo
> On 8/21/06, Laura Longo <[EMAIL PROTECTED]> wrote: >> I've tried also executing the query "begine exclusive" before the >> "update", >> and "commit" to end the entire routine, and the query that now returns >> the >

Re: [sqlite] Re: database locked

2006-08-21 Thread Laura Longo
On 8/21/06, Laura Longo <[EMAIL PROTECTED]> wrote: I've tried also executing the query "begine exclusive" before the "update", and "commit" to end the entire routine, and the query that now returns the exit code 5 (database locked) is "b

Re: [sqlite] Re: database locked

2006-08-21 Thread Laura Longo
This looks like it should work fine. The only thing that concerns me is this could be a very long loop if something locks the table or there's an error that's not recoverable. It would sit there forever retrying something that will never be fixed. Some operations will cause the database to be

[sqlite] Re: database locked

2006-08-21 Thread Laura Longo
On 8/21/06, Laura Longo <[EMAIL PROTECTED]> wrote: Hi all, I'm a software developer and I'm using sqlite3 for my application in c++. This is the problem I've found: two processes do queries (about 1 query per second) on one database; the 'select' queries don't have any problem, while '

[sqlite] database locked

2006-08-21 Thread Laura Longo
Hi all, I'm a software developer and I'm using sqlite3 for my application in c++. This is the problem I've found: two processes do queries (about 1 query per second) on one database; the 'select' queries don't have any problem, while 'update' queries find problems after 1 or 2 days that the