Return
-
Title
Warning: Mtp is deadlocked. Cause is unknown (due to DLOAD) -
Description
On source, there is a DELETE and followed by INSERT /*+APPEND*/ into .. select * from ... (DLOAD) followed by one commit all done in one oracle session.
There is a unique index on this table.
On target, we saw two sessions blocking each other. One session is doing DELETE and the other session is doing DLOAD. MTP is hung and gets "Warning: Mtp is deadlocked. Cause is unknown". It started killing sessions and restarting and never get out of this loop.
If you switch to STP, post gets "Post stopped due to obreak".
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.