RE: [sqlite] Multiple connections - stale cache?

2007-07-10 Thread Mark Brown
My final post on this issue...vxWorks has confirmed a bug in their fstat() implementation. I'm hoping for a quick resolution. Thanks for the help. Mark > > Just a follow-up for the group... > > Richard was able to determine that my platform is having > trouble with an > fstat() call to get

RE: [sqlite] Multiple connections - stale cache?

2007-06-28 Thread Mark Brown
Just a follow-up for the group... Richard was able to determine that my platform is having trouble with an fstat() call to get the size of files on my file system. Specifically, the call is returning a size of 0 when it should be 11K. I am investigating the vxWorks platform and have found that

RE: [sqlite] Multiple connections - stale cache?

2007-06-27 Thread Mark Brown
Hi- No, I am not confident that my file locking code is working. For vxWorks, I needed to alter the .lock functionality, as it wouldn't compile. Pretty much changes such as calling stat() instead of lstat(), etc. However, for this example, I do know that the two threads operate serially (ie,

Re: [sqlite] Multiple connections - stale cache?

2007-06-26 Thread drh
"Mark Brown" <[EMAIL PROTECTED]> wrote: > > > REPEAT TEST 1 > - > DB Counter 0:0:42:-89 > DB Counter 0:0:42:-89 > DB Counter 0:0:42:-89 > DB Counter 0:0:42:-89 > DB Counter 0:0:42:-96 <-- What did my code do to cause this? This

RE: [sqlite] Multiple connections - stale cache?

2007-06-26 Thread Mark Brown
I have some odd results to report on the db counter. I put some diagnostic code in our database wrapper class to write out the db counter whenever a statement is executed. It will print out for every statement executed whether the statement is a SELECT or UPDATE or BEGIN TRANSACTION. Richard

RE: [sqlite] Multiple connections - stale cache?

2007-06-26 Thread Mark Brown
Hi Richard and Joe- It probably is some application error in our code. What puzzles me is that calling sqlite3_enable_shared_cache(1) appears to fix (or at least change) the behavior. Not sure if that triggers any ideas as to what our problem might be. Your suggestion of looking at the

Re: [sqlite] Multiple connections - stale cache?

2007-06-26 Thread drh
"Mark Brown" <[EMAIL PROTECTED]> wrote: > Thanks for the quick reply. Unfortunately, we are developing code > on the vxWorks platform, so I don't think sample code would be of > use. We have seen the problem for some time now...at least from > 3.3.12. The logic in SQLite that handles cache

RE: [sqlite] Multiple connections - stale cache?

2007-06-26 Thread Joe Wilson
Can you list all the compile flags you used to compile the sqlite3 library (including all -DOMIT_* defines)? --- Mark Brown <[EMAIL PROTECTED]> wrote: > Thanks for the quick reply. Unfortunately, we are developing code on the > vxWorks platform, so I don't think sample code would be of use. We

RE: [sqlite] Multiple connections - stale cache?

2007-06-26 Thread Mark Brown
Thanks for the quick reply. Unfortunately, we are developing code on the vxWorks platform, so I don't think sample code would be of use. We have seen the problem for some time now...at least from 3.3.12. The submitter of the ticket appears to have the exact same scenario as us. Hopefully he

Re: [sqlite] Multiple connections - stale cache?

2007-06-26 Thread drh
"Mark Brown" <[EMAIL PROTECTED]> wrote: > Hi- > > We have a scenario where we have two different database connections to the > same database. Each database connection is running on a separate thread, > but in this situation, we are only using one connection at a time. We are > finding that