Avatar of FranklinRaj22
FranklinRaj22

asked on 

Lock timeout/Deadlocks on a update query that updates the same column value

I am seeing a repeated deadlock scenario in an update query and that query seems to be updating the column with the same value . Loooks fishy , is this a reason for the deadlocks ?

UPDATE BAL SET VALUE = VALUE
WHERE ID IN (?) AND BAL_ID IN
( SELECT MIN(BAL_ID) FROM cl WHERE cl.ID=1 )
DB2Oracle DatabaseMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
noci

8/22/2022 - Mon