Database Open Hung with 'cursor: pin S wait on X'
(Doc ID 2717393.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 19.5.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Database open hung while trying to start database instance .
Set LMHB to elevated priority
2020-09-23T13:30:14.542120-04:00
TT03 (PID:131198): Sleep 10 seconds and then try to clear SRLs in 3 time(s)
2020-09-23T13:30:24.544408-04:00
TT03 (PID:131198): Sleep 20 seconds and then try to clear SRLs in 4 time(s)
2020-09-23T13:30:44.546515-04:00
TT03 (PID:131198): Sleep 40 seconds and then try to clear SRLs in 5 time(s)
2020-09-23T13:30:53.606105-04:00
TMON (PID:91198): Detected ARCH process failure
TMON (PID:91198): STARTING ARCH PROCESSES
Starting background process ARC0
2020-09-23T13:30:53.628823-04:00
ARC0 started with pid=206, OS id=153857 , bound to OS numa node 1
TMON (PID:91198): ARC0: Archival started
TMON (PID:91198): STARTING ARCH PROCESSES COMPLETE
From hanganalyze::
=> Oracle session identified by:
{
instance: 2 (abbabaa.abbabaa2)
os id: 72335
process id: 93, oracle@xxxxxxxxxxx
session id: 2521
session serial #: 61436
}
which is waiting for 'cursor: pin S wait on X' with wait info:
{
p1: 'idn'=0x4d078f90
p2: 'value'=0xd0800000000
p3: 'where'=0x500000000
time in wait: 51.970892 sec
heur. time in wait: 3 min 10 sec
timeout after: never
wait id: 17
blocking: 109 sessions
current sql_id: 2381986511
current sql: update /*+ rule */ undo$ set name=:2,file#=:3,block#=:4,status$=:5,user#=:6,undosqn=:7,xactsqn=:8,scnbas=:9,scnwrp=:10,inst#=:11,ts#=:12,spare1=:13 where us#=:1
short stack: ksedsts()+783<-ksdxfstk()+58<-ksdxcb()+872<-sspuser()+200<-__sighandler()
<-__select()+19<-skgpwwait()+420<-kgxWait()+828<-kgxSharedExamine()+785<-kxsGetRuntimeLock()+246
<-kkscsCheckCursor()+550<-kkscsSearchChildList()+1324<-kksfbc()+15548<-kkspsc0()+1566
<-kksParseCursor()+114<-opiosq0()+2310<-opiodr()+1202<-rpidrus()+198<-skgmstack()+65
<-rpidru()+132<-rpiswu2()+541<-rpidrv()+1248<-rpisplu_internal()+474<-ktuscu()+294<-kqrcmt()+969
<-ktcCommitTxn_new()+5246<-ktcCommitTxn()+94<-kturfptrSlaveWork()+869<-kturfptrSlaveM
wait history:
* time between current wait and wait #1: 0.000005 sec
1. event: 'cursor: pin S wait on X'
time waited: 1 min 9 sec
wait id: 16 p1: 'idn'=0x4d078f90
p2: 'value'=0xd0800000000
p3: 'where'=0x500000000
* time between wait #1 and #2: 0.000005 sec
2. event: 'cursor: pin S wait on X'
time waited: 1 min 9 sec
wait id: 15 p1: 'idn'=0x4d078f90
p2: 'value'=0xd0800000000
p3: 'where'=0x500000000
* time between wait #2 and #3: 0.000082 sec
3. event: 'cell single block physical read'
time waited: 0.001188 sec
wait id: 14 p1: 'cellhash#'=0x6bea4954
p2: 'diskhash#'=0x4dc8b18c
p3: 'bytes'=0x2000
px1: 'disk number'=0x39
px2: 'au'=0x267e2
px3: 'offset'=0x220000
}
and is blocked by the session at the start of the chain.
Chain 1 Signature: 'cursor: pin S wait on X'<='row cache lock' (cycle)
Chain 1 Signature Hash: 0xe29f9836
-------------------------------------------------------------------------------
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 |