Archives of the TeradataForum
Message Posted: Fri, 01 Jan 2010 @ 15:02:35 GMT
From what you have described I gather that the "normal" scenario would be blocking, not deadlocking. There is a very good thread in the Archives explaining in great detail the difference so I am just quoting it to add all that context to the discussion:
The big question is, therefore, how the deadlock is even possible?
That's something you need to do additional research on. My guess is that there is lock level escalation to table level. If all locks are on hash level than two sessions cannot acquire such lock for the same hash, so no deadlock at all.
If this escalation is indeed taking place, then is it a feature (and a function of the current system configuration / price) or a bug? Not always easy to tell but in both cases you are pretty much stuck in your today's production environment.
On a more practical way, check out this thread:
Perhaps you hit the MSR exception mentioned in it? Changing the order of execution of the statement may change something.
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023