Re: Theoretical Basis for SELECT FOR UPDATE

"vc" <boston103_at_hotmail.com> wrote in message news:1128453433.143208.246170_at_z14g2000cwz.googlegroups.com...
> The transactions deadlock because there is a *bug*: the programmer
> neglected to eliminate non-serializable transaction histories. Any
> transaction history whose serializability graph has cycles will
> deadlock.

All very erudite no doubt, but you asserted that spaghetti code caused deadlocks, which is just wrong and I showed you it is wrong.

Question: how can I know the serializability graph for a transaction I can't even find?

> The way to avoid the deadlock is naturally to eliminate
> non-serializable histories. In SQL Server, one would use the UPDLOCK
> hint:

[snip]

> In Oracle, SELECT FOR UPDATE is your friend.

And in other products there are other equivalent hacks.

Are you telling me that a sufficient knowledge of proprietary hacks makes it unnecessary to know where transactions start and what is included in them?

Roy Received on Wed Oct 05 2005 - 00:28:45 CEST