Re: [sqlite] database is locked error with 3.3.13
I'm experiencing the same problem on QNX compiled for Renesas SH4... > This is not a bug in SQLite - it is a bug in Apple's implementation >(or more precisely their lack of implementation) of POSIX advisory > locks for AppleShare mounted volumes. 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. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] database is locked error with 3.3.13
T <[EMAIL PROTECTED]> wrote: > > I recently installed SQLite 3.3.13, after having used previous > versions. I now get an error: > > Error: database is locked > > when I use the sqlite3 command line tool to access a database on a > shared volume. > > But opening the same file with an earlier version works fine. > > I'm not sure what version introduced this problem. I suspect it's > after 3.3.9. It's definitely after 3.1.3. > > I'm using Mac OS X 10.4.8, with the database file on an AppleShare > mounted volume. > > What's the issue here? Is it a known bug? Will it be fixed? > This is not a bug in SQLite - it is a bug in Apple's implementation (or more precisely their lack of implementation) of POSIX advisory locks for AppleShare mounted volumes. 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. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] database is locked error with 3.3.13
I have the following sources which one would you like? sqlite-2.8.16.tag.gz sqlite-3.3.8.tar.gz sqlite-3.2.2.tar.gz sqlite-3.3.9.tar.gz sqlite-3.2.8.tar.gz sqlite-3.3.10.tar.gz sqlite-3.3.12.tar.gz sqlite-3.3.13.tar.gz sqlite-3.3.5.tar.gz sqlite-3.3.7.tar.gz Ken T <[EMAIL PROTECTED]> wrote: Hi all, Following up: > I recently installed SQLite 3.3.13, after having used previous > versions. I now get an error: > > Error: database is locked > > when I use the sqlite3 command line tool to access a database on a > shared volume. > > But opening the same file with an earlier version works fine. > > I'm not sure what version introduced this problem. I suspect it's > after 3.3.9. It's definitely after 3.1.3. > > I'm using Mac OS X 10.4.8, with the database file on an AppleShare > mounted volume. I tried using sqlite 3.3.10 (which I had on another machine) and still have the problem. I looked for 3.3.9 to re-install it, to try that version, but couldn't find it on the sqlite.org web site. Have others experienced a locking error on remote volumes? Where can I get 3.3.9 and earlier source code? Thanks, Tom - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] database is locked error with 3.3.13
> Where can I get 3.3.9 and earlier source code? http://www.sqlite.org/sqlite-source-3_3_0.zip ... http://www.sqlite.org/sqlite-source-3_3_9.zip But it would be nice to have direct link on the website, or even better to have tags for all releases in CVS. - Aparat cyfrowy, odtwarzacz mp3 i inne nagrody. Sprawd¼ nowy konkurs na TeleInteria!>> http://link.interia.pl/f1a2d - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] database is locked error with 3.3.13
Hi all, Following up: I recently installed SQLite 3.3.13, after having used previous versions. I now get an error: Error: database is locked when I use the sqlite3 command line tool to access a database on a shared volume. But opening the same file with an earlier version works fine. I'm not sure what version introduced this problem. I suspect it's after 3.3.9. It's definitely after 3.1.3. I'm using Mac OS X 10.4.8, with the database file on an AppleShare mounted volume. I tried using sqlite 3.3.10 (which I had on another machine) and still have the problem. I looked for 3.3.9 to re-install it, to try that version, but couldn't find it on the sqlite.org web site. Have others experienced a locking error on remote volumes? Where can I get 3.3.9 and earlier source code? Thanks, Tom - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] database is locked error with 3.3.13
Hi all, I recently installed SQLite 3.3.13, after having used previous versions. I now get an error: Error: database is locked when I use the sqlite3 command line tool to access a database on a shared volume. But opening the same file with an earlier version works fine. I'm not sure what version introduced this problem. I suspect it's after 3.3.9. It's definitely after 3.1.3. I'm using Mac OS X 10.4.8, with the database file on an AppleShare mounted volume. What's the issue here? Is it a known bug? Will it be fixed? Thanks, Tom - To unsubscribe, send email to [EMAIL PROTECTED] -