IPC Send timeout detected ORA-12805 when executing GV$ query (Doc ID 2864314.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

On : 19.9.0.0.0 version, Real Application Cluster

ERROR
-----------------------

A specific node that is a RAC environment  IPC Send timeout detected error occurred with ORA- 12805 error.

I checked the OS Watcher log, but there are no special issues. 

The same ORA-12805 occurs in the customer's AIX, LIUNX environment.

< alert_node 1.log >

2021-02-15T12:06:58.711036+09:00
IPC Receiver dump detected. Sender instance 2 Receiver pnum 211 ospid 82706691 [oracle@process21], pser 17
2021-02-15T12:06:58.714357+09:00
Errors in file /oracle/db/base/diag/rdbms/node1/trace/node1_ora_55707164.trc:
2021-02-15T12:07:50.409943+09:00
opidcl aborting process unknown ospid (55707164) as a result of ORA-12805    <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< !!!!!
2021-02-15T12:12:34.376420+09:00
IPC Receiver dump detected. Sender instance 2 Receiver pnum 147 ospid 52626605 [oracle@process21(TNS V1-V3)], pser 38
2021-02-15T12:12:34.379640+09:00
Errors in file /oracle/db/base/diag/rdbms/node1/trace/node1_ora_26346872.trc:


< alert_node2.log >

2021-02-15T12:07:41.551462+09:00
IPC Send timeout detected. Sender: ospid 10879348 [oracle@process2(PPA7)]    <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< !!!!!
Receiver: inst 1 binc 24 ospid 82706691
2021-02-15T12:09:44.922318+09:00
Thread 2 advanced to log sequence 803 (LGWR switch),  current SCN: 4828050715
 Current log# 11 seq# 803 mem# 0: +DATA/node/ONLINELOG/group_11.275.1060101743
2021-02-15T12:09:47.563002+09:00
TT02 (PID:26543806): SRL selected for T-2.S-803 for LAD:2
2021-02-15T12:09:57.079277+09:00
ARC1 (PID:41355430): Archived Log entry 3249 added for T-2.S-802 ID 0x651d62be LAD:1
2021-02-15T12:13:17.195538+09:00
IPC Send timeout detected. Sender: ospid 10879348 [oracle@process2(PPA7)]
Receiver: inst 1 binc 24 ospid 52626605

< node1_ora_13240656_ORA12805_PX_10046_trace.trc >

WAIT #4853909832: nam='PX Deq: reap credit' ela= 6 p1=0 p2=0 p3=0 obj#=-1 tim=10631788896883
2021-02-15 14:29:22.717*:PX_Messaging:kxfp.c@10395:kxfprigdb():
Get dequeued buffer from 1.32766 qref=0x7000101ff19e398 flags= DQR
flow mode was 0x2 would have been 0x2
got buffer mh=0x7000107fb19bf00  qref=0x7000101ff19e398 qrser=860161 qrseq=10 qrflg=0x7 qrfmh=0x2
2021-02-15 14:29:22.717*:PX_Messaging:kxfp.c@8402:kxfpProcessMsg():
type 6(DTA) 54(KXFQ UNPARTITIONED TQ) from q=0x7000101ff19e8e8 qref=0x7000101ff19e398(1.32766) ser=860161 seq=8
WAIT #4853909832: nam='PX Deq: Execute Reply' ela= 448 sleeptime/senderid=0 passes=0 p3=0 obj#=-1 tim=10631788896949
2021-02-15 14:29:22.717*:PX_Messaging:kxfp.c@10395:kxfprigdb():
Get dequeued buffer from 1.32766 qref=0x7000101ff19e398 flags=-none-
flow mode was 0x2 would have been 0x2
got buffer mh=0x7000107fb19bf00  qref=0x7000101ff19e398 qrser=860161 qrseq=10 qrflg=0x1 qrfmh=0x2
FETCH #4853909832:c=507,e=869,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,plh=441670765,tim=10631788897072
WAIT #4853909832: nam='SQL*Net message from client' ela= 7187 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=10631788904278
WAIT #4853909832: nam='SQL*Net message to client' ela= 1 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=10631788904305
FETCH #4853909832:c=60,e=103,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,plh=441670765,tim=10631788904399

*** 2021-02-15T14:33:45.517401+09:00
Received ORADEBUG command (#1) 'dump errorstack 1' from process '42797310'

*** 2021-02-15T14:33:45.517499+09:00
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=1, mask=0x0)
----- Error Stack Dump -----

=========================================

< node1_ppa7_39716962_ORA12805_PX_10046_trace.trc >

2021-02-15 14:29:20.715*:PX_Control:kxfx.c@4857:kxfxsp1(end):
2021-02-15 14:29:20.718*:PX_Control:kxfx.c@5889:kxfxsp(end):
2021-02-15 14:29:20.718*:PX_Scheduler:qerpx.c@7821:qerpxStart(): start parallelizer pxid:1 rwsrid:1
2021-02-15 14:29:20.718*:PX_Control:kxfx.c@6121:kxfxsStatus():joining TRUE ParseState KXFXUPARSE1 (1)
2021-02-15 14:29:20.725*:PX_Scheduler:qerpx.c@9385:qerpxSlaveFetch(): <- execute pxid:1 rwsrid:1 dfo:0 dfoPair=2
2021-02-15 14:29:20.725*:PX_Scheduler:qerpx.c@9534:qerpxSlaveFetch(): -> fetching pxid:1 rwsrid:1 dfo:0
2021-02-15 14:41:39.006*:PX_Scheduler:qerpx.c@9779:qerpxSlaveFetch(): exiting pxid:1 rwsrid:1 error:10388 <<<<<<<<<<<<<<<<<< !!!
2021-02-15 14:41:39.006*:PX_Control:kxfx.c@11415:kxfxmai():In signal-handler after catching 10388
2021-02-15 14:41:39.006*:PX_Control:kxfx.c@5682:kxfxsuf(): 

BUSINESS IMPACT
-----------------------
The query was executed normally, but after about 10 minutes, an IPC Send timeout detected  error occurred in the alert.

Changes

doesn't exist.

Cause

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