Re: [sqlite] Thread safety guarantees

2005-09-04 Thread Christopher R. Palmer
Ron Avriel wrote: On 9/3/05, D. Richard Hipp <[EMAIL PROTECTED]> wrote: This is not portable. Some operating systems (ex: RedHat) will cause intermittent problems if the same SQLite handle is used by more than one thread. The program will seem to work initially but will begin to exhibit

Re: [sqlite] Thread locking issues on RH9

2005-06-16 Thread Christopher R. Palmer
My problem (ticket 1272) is that I open multiple sqlite handles in one thread and then pass the handles to other threads to perform the work. That is: db1 = sqlite3_open(); db2 = sqlite3_open(); pthread_create(...,db1); pthread_create(...,db2); While this does not appear to be disallowed by

Re: [sqlite] Problems compiling threadsafe code from cvs

2005-06-16 Thread Christopher R. Palmer
D. Richard Hipp wrote: On Thu, 2005-06-16 at 13:24 -0400, Christopher R. Palmer wrote: In the current cvs, there is a problem compiling the threadsafe code (at least when threads override each other). The OsFile structure defined in os_unix.h depends on the definition of THREADSAFE which

[sqlite] Problems compiling threadsafe code from cvs

2005-06-16 Thread Christopher R. Palmer
In the current cvs, there is a problem compiling the threadsafe code (at least when threads override each other). The OsFile structure defined in os_unix.h depends on the definition of THREADSAFE which is not included in the normal compilation flags (for example, for pager.o). I made the

Re: [sqlite] Thread locking issues on RH9

2005-06-15 Thread Christopher R. Palmer
D. Richard Hipp wrote: On Wed, 2005-06-15 at 10:24 -0400, Christopher R. Palmer wrote: In my case, I added printf statements to trace the fcntl calls and it was the case that one thread did the fcntl to get the shared lock and then a second thread attempted the fcntl to go from shared

Re: [sqlite] Race condition in testThreadLockingBehavior?

2005-03-03 Thread Christopher R. Palmer
D. Richard Hipp wrote: On Thu, 2005-03-03 at 07:30 -0500, Christopher R. Palmer wrote: It looks to me like this test assumes that no other process currently has a lock on this file. If any other process has any lock on this file, I believe one or both of the locking calls will fail which

[sqlite] Race condition in testThreadLockingBehavior?

2005-03-03 Thread Christopher R. Palmer
will fail which will trick sqlite into believing that the locks are fd specific, not process specific. Am I reading this right? Cheers, Chris. -- Christopher R. Palmer [EMAIL PROTECTED] Chief Technology Officer www.vivisimo.com Vivisimo, Inc.

[sqlite] Solaris 2.5 compilation

2005-02-11 Thread Christopher R. Palmer
I had problems compiling the 3.0.8 version of sqlite on my Solaris box. The version of "awk" on Solaris does not support the gsub function which makes the generation of opcodes.c and opcodes.h fail. The use of gsub is actually quite simple and I created a little patch that using sed in the