On Wed, Aug 24, 2011 at 6:14 PM, Pavel Ivanov <paiva...@gmail.com> wrote:

> This is completely unrelated because Oracle works differently.
>

Regardless of the reason for the specific behaviours, the symptoms are
similar, and they are both locking-related problems. Maybe off-topic,
admittedly, but not "completely unrelated."

And if
> you saw this locking most probably you had an open transaction in the
> sqlplus.


sqlplus was there only to run SELECTs to make sure that PHP was writing what
it should. It was running on the Oracle box and PHP was connecting over IP.
i can't explain the behaviour, i can only tell you what the symptoms were.

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.
>

That might be, but the general category of problem is not specific to the
combination of sqlite3/AFP.

-- 
----- 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

Reply via email to