To find number sequence
SELECT * FROM NumberSequenceList WITH (READUNCOMMITTED)
WHERE EXISTS (SELECT RecId FROM NumberSequenceTTS WITH (READUNCOMMITTED) where NumberSequenceTTS.TRANSID = NumberSequenceList.TRANSID)
AND TRANSID != 0
tells us the lock is related to the TOB number sequence ... which is set to continuous .. but shouldn't be (or it is not strictly required anyway).
Solution :
So the problem here is a number sequence that was set to be continuous and several processes fetching a new number from this number sequence simultaniously.
It is advised to make this specific number sequence not continuous and review all other continuous number sequences.
SELECT * FROM NumberSequenceList WITH (READUNCOMMITTED)
WHERE EXISTS (SELECT RecId FROM NumberSequenceTTS WITH (READUNCOMMITTED) where NumberSequenceTTS.TRANSID = NumberSequenceList.TRANSID)
AND TRANSID != 0
tells us the lock is related to the TOB number sequence ... which is set to continuous .. but shouldn't be (or it is not strictly required anyway).
Solution :
So the problem here is a number sequence that was set to be continuous and several processes fetching a new number from this number sequence simultaniously.
It is advised to make this specific number sequence not continuous and review all other continuous number sequences.
No comments:
Post a Comment