Hi Simon,
Simon Slavin writes:
> On 29 Mar 2011, at 10:48am, Boris Kolpackov wrote:
>
> > If I add IMMEDIATE (or EXCLUSIVE) to the first transaction
> > (three INSERTs), nothing changes, [snip]
> >
> > If I add IMMEDIATE to the second transaction (SELECT then UPDATE), then
> > the deadlocks go away for both transaction as one would expect.
>
> In your testing, did you test adding IMMEDIATE to /both/ transactions ?
No, since adding it just to the second transaction already got rid of
all the deadlocks in both transactions. But I just ran the test with
both transactions starting immediately. As I would expect, there are
no deadlocks.
Thanks,
Boris
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
