Goldengate Replication skips records due to deadlocks
(Doc ID 2126646.1)
Last updated on DECEMBER 18, 2019
Applies to:
Oracle GoldenGate - Version 12.1.2.1.6 and laterInformation in this document applies to any platform.
Symptoms
Deadlock are causing transactions to be skipped:
Oracle GoldenGate Delivery for Oracle
Version 12.1.2.1.6 20803560 21496507_FBO
Solaris, sparc, 64bit (optimized), Oracle 11g on Jul 24 2015 06:15:44
WARNING OGG-00869 OCI Error ORA-00060: deadlock detected while waiting for resource
(status = 60), SQL <UPDATE /*+ RESTRICT_ALL_REF_CONS */ "OMS"."PROMOTIONS2" x SET x."NAME" = :a1,x."MAX_NUM_USES" = :a2,x."NUM_ALREADY_USED" = :a3,x."RESTRICTION_INFO_XML" = sys.xmltype.createxml(:a4,null,1,1),x."PRICING_INFO_XML" = sys.xmltype.createxml(:a5,null,1,1),x."MSG_KEY" = :a6,x."IS_ACTIVE" = :a7,x."NOTES" = :a8,x."SHOW_PRICING_ONLY" = :a9,x."START_DATE" = :a10,x."END_DATE" = :a11,x."CREATED_DATE" = :a12,x."MODIFIED_DATE" = :a13,x."CREATED_BY_ID" = :a14,x."MODIFIED_BY_ID" = :a15,x."BUSINESS_OBJECTIVE" = :a16,x."CHANNEL" = :a17,x."UPDATE_COUNT" = :a18,x."VERSION" = :a19,x."PRODUCT_FAMILY" = :a20,x."GG_MODI_TS" = :a21,x."GG_STATUS" = :a22,x."PROMOTION_CAMPAIGN_TYPE" = :a23 WHERE x."PROMO_ID" = :b0 AND x."NUM_ALREADY_USED" = :b1 AND x."MODIFIED_DATE" = :b2 AND x."UPDATE_COUNT" is NULL AND x."GG_MODI_TS" = :b4 AND x."GG_STATUS" = :b5>.
(status = 60), SQL <UPDATE /*+ RESTRICT_ALL_REF_CONS */ "OMS"."PROMOTIONS2" x SET x."NAME" = :a1,x."MAX_NUM_USES" = :a2,x."NUM_ALREADY_USED" = :a3,x."RESTRICTION_INFO_XML" = sys.xmltype.createxml(:a4,null,1,1),x."PRICING_INFO_XML" = sys.xmltype.createxml(:a5,null,1,1),x."MSG_KEY" = :a6,x."IS_ACTIVE" = :a7,x."NOTES" = :a8,x."SHOW_PRICING_ONLY" = :a9,x."START_DATE" = :a10,x."END_DATE" = :a11,x."CREATED_DATE" = :a12,x."MODIFIED_DATE" = :a13,x."CREATED_BY_ID" = :a14,x."MODIFIED_BY_ID" = :a15,x."BUSINESS_OBJECTIVE" = :a16,x."CHANNEL" = :a17,x."UPDATE_COUNT" = :a18,x."VERSION" = :a19,x."PRODUCT_FAMILY" = :a20,x."GG_MODI_TS" = :a21,x."GG_STATUS" = :a22,x."PROMOTION_CAMPAIGN_TYPE" = :a23 WHERE x."PROMO_ID" = :b0 AND x."NUM_ALREADY_USED" = :b1 AND x."MODIFIED_DATE" = :b2 AND x."UPDATE_COUNT" is NULL AND x."GG_MODI_TS" = :b4 AND x."GG_STATUS" = :b5>.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |