Return
-
Title
SQL Deadlocks when using Oracle database -
Description
SQL Deadlock statements:
UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = :B2 WHERE JOBID = :B1 AND MSGSTATUS <> 4
and
UPDATE EXCHANGEPAMDAPOOL SET THREADID = :B4 WHERE (((THREADID <> :B4 AND THREADID > 0) OR (THREADID = 0 AND (ERROR_TIME IS NULL OR ERROR_TIME < :B3 ))) AND MSGSTATUS = 0 AND STORAGELIMIT = :B2 ) AND POOLID <= :B1
-
Cause
Product issue -
Resolution
Issue resolved in MAM 8.7 CU3