My Oracle Support Banner

Parallel Insert Hangs With Enq: TX - Contention Between Slaves (Doc ID 2774332.1)

Last updated on JANUARY 25, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 19.9.0.0.0 and later
Information in this document applies to any platform.

Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample or bulit-in schema(s),
Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead,
is purely coincidental and not intended in any manner.

Parallel insert hangs with enq: TX - contention between slaves
Serial insert works fine.

From Hanganalyze trace:

Chains most likely to have caused the hang:
[a] Chain 1 Signature: 'PX Deq: Execution Msg'<='enq: TX - contention'
Chain 1 Signature Hash: 0x1fa68c23
[b] Chain 2 Signature: 'PX Deq: Metadata Update'
Chain 2 Signature Hash: 0x9c9fdfa0
[c] Chain 3 Signature: 'PX Deq: Execution Msg'
Chain 3 Signature Hash: 0x6319d684

 

Main chain/s seen (if any):
HA 1 Chain 1 Signature: PX Deq: Execution Msg<=enq: TX - contention blocking 0 sessions >>>>>>>>>>>>>>>>>>>>

and is blocked by
=> Oracle session identified by:
{
instance: 1 (orcl.orcl)
os id: 1509
process id: 43, oracle@oel8 (P000)
session id: 103
session serial #: 45221
module name: sqlplus
}
which is waiting for 'PX Deq: Execution Msg' with wait info: >>>>>>>>>>
{
p1: 'sleeptime/senderid'=0x1001ffff
p2: 'passes'=0x82
p3: ''=0x773a0258
time in wait: 4.489966 sec (last interval)
time in wait: 1 min 22 sec (total)
timeout after: never
wait id: 2152
blocking: 1 session >>>>>>>>>>>>>

 

Changes

 

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
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.