Re: [sqlite] "database is locked" SQLITE_BUSY when db is on network drive...
Hi Chase, it connects fine. no errors. but then i try to create a temp table (which, like i said, works if the db is local) it fails immediately with SQLITE_BUSY "database is locked". It's some Mac vs SQLite bug. You can recompile SQLite to fix it. See the old post below. And search the archives for "locked" in the subject. Tom From: T <[EMAIL PROTECTED]> Date: 11 May 2007 10:54:02 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] database is locked error Is there a timetable for including the fix for opening SQLite files on a shared volume? Since it's fairly trivial, is there a reason why it hasn't been included yet? Thanks, Tom From: T <[EMAIL PROTECTED]> Date: 29 April 2007 3:35:00 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] database is locked error Following up an old thread: The SQLite sources include an (Apple-supplied) patch to work around the problem. Recompile with -DSQLITE_ENABLE_LOCKING_STYLE=1 We are working toward turning on this patch by default, but we are not quite there yet. I compiled and ran SQLite 3.3.17 and got the old error again when accessing a database file on a server volume, with SQLite saying it is locked. Does this mean that we are still "not quite there yet" with a default fix? Any time frame? Thanks, Tom -- Best value broadband in Australia. $3 per GB excess instead of $150 from BigPond Free uploads, free morning downloads. http://www.tandb.com.au/broadband/?sig - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] "database is locked" SQLITE_BUSY when db is on network drive...
Can you do any other write queries (INSERT or UPDATE for example)? On 8/2/07, Chase <[EMAIL PROTECTED]> wrote: > > running sqlite 3.4.1 on mac os x 10.4 > > i've set up a file share on another mac running 10.4 and placed a small > db file on the share and chmod'ed it to 777 (full access). > > i go to the development mac and log into the other mac as the user who > owns that db file. > > the path on my dev mac to that shared db is now: > /Volumes/SharedFolder/smalldb.db > > the test app (which works perfectly with the same exact small db > sitting on its local drive) is launched and a connection is made to the > db sitting on the other mac. > > it connects fine. no errors. but then i try to create a temp table > (which, like i said, works if the db is local) it fails immediately > with SQLITE_BUSY "database is locked". > > NO ONE else is accessing this database file, so how is that possible? > > > what am i doing wrong? > > - chase > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > -- - Mitchell Vincent - K Software - Innovative Software Solutions - Visit our website and check out our great software! - http://www.ksoftware.net - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] "database is locked" SQLITE_BUSY when db is on network drive...
running sqlite 3.4.1 on mac os x 10.4 i've set up a file share on another mac running 10.4 and placed a small db file on the share and chmod'ed it to 777 (full access). i go to the development mac and log into the other mac as the user who owns that db file. the path on my dev mac to that shared db is now: /Volumes/SharedFolder/smalldb.db the test app (which works perfectly with the same exact small db sitting on its local drive) is launched and a connection is made to the db sitting on the other mac. it connects fine. no errors. but then i try to create a temp table (which, like i said, works if the db is local) it fails immediately with SQLITE_BUSY "database is locked". NO ONE else is accessing this database file, so how is that possible? what am i doing wrong? - chase - To unsubscribe, send email to [EMAIL PROTECTED] -