Re: [sqlite] Problems with file locks on USB keys

2009-04-03 Thread Dave Brown
Well the problem is this is happening on our customer's computers. Haven't been able to see it here yet...will keep trying. But we get reports of this about once a week. On Fri, Apr 3, 2009 at 10:35 AM, Sherief N. Farouk wrote: > > Hi - it only happens on Windows systems that are using U3 USB ke

Re: [sqlite] Problems with file locks on USB keys

2009-04-03 Thread Sherief N. Farouk
> Hi - it only happens on Windows systems that are using U3 USB keys. > None of > the queries are intensive - they are pretty simple and shouldn't take > longer > than a few milliseconds. > > On harddisks it *always* works. Never had an issue there. > Like Teg said, you can use procmon in additi

Re: [sqlite] Problems with file locks on USB keys

2009-04-03 Thread Teg
Hello Dave, Friday, April 3, 2009, 12:16:37 PM, you wrote: DB> Hi - it only happens on Windows systems that are using U3 USB keys. None of DB> the queries are intensive - they are pretty simple and shouldn't take longer DB> than a few milliseconds. DB> On harddisks it *always* works. Never had a

Re: [sqlite] Problems with file locks on USB keys

2009-04-03 Thread Dave Brown
Hi - it only happens on Windows systems that are using U3 USB keys. None of the queries are intensive - they are pretty simple and shouldn't take longer than a few milliseconds. On harddisks it *always* works. Never had an issue there. On Fri, Apr 3, 2009 at 5:15 AM, Emil Obermayr wrote: > On T

Re: [sqlite] Problems with file locks on USB keys

2009-04-03 Thread Emil Obermayr
On Thu, Apr 02, 2009 at 08:20:38PM -0700, Dave Brown wrote: > Our software often runs into problems when run on USB keys. Specifically, > calls to sqlite to read/write to the database hang infinitely, or return Does it work on harddisk? I can tell RO-access works nicely on Windows XP. Do you hav

Re: [sqlite] Problems with file locks on USB keys

2009-04-03 Thread Jean-Denis Muys
On 4/3/09 5:20 AM, "Dave Brown" wrote: > Our software often runs into problems when run on USB keys. Specifically, > calls to sqlite to read/write to the database hang infinitely, or return > SQLITE_BUSY after even 10 seconds of waiting. The problem seems to be that > the database file gets locke

[sqlite] Problems with file locks on USB keys

2009-04-03 Thread Dave Brown
Our software often runs into problems when run on USB keys. Specifically, calls to sqlite to read/write to the database hang infinitely, or return SQLITE_BUSY after even 10 seconds of waiting. The problem seems to be that the database file gets locked and remains locked, presumably by some problem