> > Here's an example of the deadlock: > <https://lh6.googleusercontent.com/-qY9VgRfZxRc/UOr0hFHjehI/AAAAAAAABh8/_z-enhvHRSY/s1600/Deadlock.PNG> The transaction on the left is trying to do the *select* and it has already got a *shared *lock on the subclass table (tblCustomerOrders) and is seeking an *upgrade* lock on the base class table (tblOrders). I guess thats how it works when there's a join.
The transaction on the right has already done the select so it already had a *shared* lock on the subclass table (tblCustomerOrders) and an *upgrade *lock on the base class table (tblOrders), and is now trying to issue an UPDATE to the subclass' properties, so it's seeking an *exclusive* lock on that subclass table. -- You received this message because you are subscribed to the Google Groups "nhusers" group. To view this discussion on the web visit https://groups.google.com/d/msg/nhusers/-/0BGh9_MpM34J. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
