[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

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 key8...@gmail.com 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

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 have

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

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 an

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 addition to a