We are running webMethods 7.1.3.0 in a clustered environment. All 4 servers attempt to read the IS_USER_TASKS table and hold it for an UPDLOCK, thus deadlocking the other 3 servers when they attempt to do the same. Has anyone seen this before, is there a way around it?
Note I am the DBA, not the WM admin…
(@P1 nvarchar(4000),@P2 nvarchar(4000),@P3 nvarchar(4000),@P4 nvarchar(4000))SELECT UUID, DESCRIPTION, SERVICE, TARGET, RUNASUSER, RUNFROMEND, TASKTYPE, STARTTIME, ENDTIME, TIMEINTERVAL, MONTHMASK, DAYOFWEEKMASK, DAYOFMONTHMASK, HOURMASK, MINUTEMASK, STATE, RUNNINGON, UUIDREF, NEXTRUN, LATENESS, LATENESSACTION, LASTERROR, LASTSTACKTRACE, INPUTS , “UUID”, “DESCRIPTION”, “SERVICE”, “TARGET”, “RUNASUSER”, “RUNFROMEND”, “TASKTYPE”, “STARTTIME”, “ENDTIME”, “TIMEINTERVAL”, “MONTHMASK”, “DAYOFWEEKMASK”, “DAYOFMONTHMASK”, “HOURMASK”, “MINUTEMASK”, “STATE”, “RUNNINGON”, “UUIDREF”, “NEXTRUN”, “LATENESS”, “LATENESSACTION”, “LASTERROR”, “LASTSTACKTRACE” FROM IS_USER_TASKS WITH (UPDLOCK) WHERE NEXTRUN=(SELECT MIN(NEXTRUN) FROM IS_USER_TASKS WHERE (TARGET=‘$any’ OR TARGET=@P1 ) AND ( STATE = 0 OR (STATE = 1 AND TASKTYPE <> 0) ) AND (ENDTIME IS NULL OR ENDTIME > CURR