> i saw the same behaviour with Oracle's CLI client
> ("sqlplus") - as long as i had sqlplus opened and connected, my PHP pages
> couldn't insert any data.
>
> i.e. this type of problem isn't limited to sqlite3.
This is completely unrelated because Oracle works differently. And if
you saw this locking most probably you had an open transaction in the
sqlplus. Note that OP's problem is specific to AFP and you won't see
such behavior e.g. on Linux with ext4 over NFS. I believe you won't
see such behavior on Windows over Samba either.
Pavel
On Wed, Aug 24, 2011 at 12:02 PM, Stephan Beal <sgb...@googlemail.com> wrote:
> On Wed, Aug 24, 2011 at 3:51 PM, Simon Slavin <slav...@bigfraud.org> wrote:
>
>> SQLite3::query(): Unable to execute statement: database is locked in
>> [...]readrec.php
>>
>
> For what it's worth: while porting a customer's PHP app from MySQL to Oracle
> early this year, i saw the same behaviour with Oracle's CLI client
> ("sqlplus") - as long as i had sqlplus opened and connected, my PHP pages
> couldn't insert any data.
>
> i.e. this type of problem isn't limited to sqlite3.
>
> --
> ----- stephan beal
> http://wanderinghorse.net/home/stephan/
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
