Ioana Danes wrote:
I assume that the T3 - second insert in Table1 is
locked by the "waiting" T2 - update on table2 (or
anyway something similar) because if I remove the
update statement from all this scenario everything
works well, no deadlocks!!!
Any thoughts?
Thank you,
Ioana Danes
Hi Ioana,
You assume well, the deadlock happens exactly where you spotted it. The
root cause is that Sequoia does not provide row-level locking semantics.
What is provided is a slightly enhanced table-level locking, which might
lead to think in certain cases that we are providing "true" row-level
locking. It is hence safer to code your applications as if table-level
locking was being used.
Hope this helps,
Damián
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
