RAC DB hang on 'gc current retry'
(Doc ID 2666025.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
RAC DB hang with below contention
<ORACLE_BASE>/diag/rbms/rdbms/<DBNAME>/<SID>/trace/<SID>_ora_17465.trc
===================
Chains most likely to have caused the hang:
[a] Chain 1 Signature: 'gc remaster'<='enq: TX - index contention'
Chain 1 Signature Hash: 0x3905aa03
[b] Chain 2 Signature: 'gc remaster'<='enq: TX - index contention'
Chain 2 Signature Hash: 0x3905aa03
[c] Chain 3 Signature: 'gc remaster'<='enq: TX - index contention'
Chain 3 Signature Hash: 0x3905aa03
..
-------------------------------------------------------------------------------
Chain 1:
-------------------------------------------------------------------------------
Oracle session identified by:
{
instance: 1 (xxxxxx.xxxxxx)
os id: 18053
process id: 300, oracle@xxxxxx
session id: 28
session serial #: 7306
module name: 7 (JDBC Thin Client)
pdb id: 7 (xxxxxx)
}
is waiting for 'enq: TX - index contention' with wait info:
{
p1: 'name|mode'=0x54580004
p2: 'usn<<16 | slot'=0x490006
p3: 'sequence'=0x21e5ae
px1: 'pdb uid'=0x355adfc9
px2: 'master hint'=0x4
time in wait: 1 min 40 sec
timeout after: never
wait id: 1642223
blocking: 0 sessions
current sql_id: 2192857311
current sql: INSERT INTO xxxx.GAME_TRANSACTION#2 (
TRANSACTION_ID, TYPE, UNIQUE_REFERENCE,
PRODUCT, PROVIDER, CHANNEL,
CREATED, USERNAME, CUSTOMER_ID,
JURISDICTION, LANGUAGE, COUNTRY,
BRAND, GAME_ROUND, AMOUNT,
short stack: ksedsts()+426<-ksdxfstk()+58<-ksdxcb()+872<-sspuser()+200<-__sighandler()<-semtimedop()+10<-skgpwwait()+187<-ksliwat()+2201<-kslwaitctx()+200<-kjusuc()+5580<-ksipgetctxia()+1995<-ksqcmi()+2757<-ksqgtlctx()+6620<-ksqgelctx()+838<-ktuGetTxForXid()+324<-ktcwit1()+490<-kclsplitwait()+2064<-kdiwaitforsplit()+139<-kdiins1()+82689<-kdiinsp0()+113<-kauxsin()+1968<-kdtiidx()+1037<-kdtInsRow()+3638<-qerltcNoKdtBufferedInsRowCBK()+288<-qerltcSingleRowLoad()+293<-qerltcFetch()+391<-insexe()+733<-opiexe()+6714<-opipls()+2086<-
wait history:
* time between current wait and wait #1: 0.000256 sec
1. event: 'SQL*Net message from client'
time waited: 0.000190 sec
wait id: 1642222 p1: 'driver id'=0x54435000
p2: '#bytes'=0x1
* time between wait #1 and #2: 0.000002 sec
2. event: 'SQL*Net message to client'
time waited: 0.000001 sec
wait id: 1642221 p1: 'driver id'=0x54435000
p2: '#bytes'=0x1
* time between wait #2 and #3: 0.000024 sec
3. event: 'SQL*Net message from client'
time waited: 0.074164 sec
wait id: 1642220 p1: 'driver id'=0x54435000
p2: '#bytes'=0x1
}
and is blocked by
=> Oracle session identified by:
{
instance: 1 (xxxxxxx)
os id: 18123
process id: 316, oracle@xxxxxxxx
session id: 639
session serial #: 6885
module name: 7 (JDBC Thin Client)
pdb id: 7 (xxxxx)
}
which is waiting for 'gc remaster' with wait info:
{
p1: 'file#'=0xc4
p2: 'block#'=0x7acc3ae
p3: 'class#'=0x1
time in wait: 0.644731 sec
timeout after: 1.355269 sec
wait id: 649070
blocking: 10 sessions
current sql_id: 2192857311
current sql: INSERT INTO xxxxx.GAME_TRANSACTION#2 (
TRANSACTION_ID, TYPE, UNIQUE_REFERENCE,
PRODUCT, PROVIDER, CHANNEL,
CREATED, USERNAME, CUSTOMER_ID,
JURISDICTION, LANGUAGE, COUNTRY,
BRAND, GAME_ROUND, AMOUNT,
short stack: ksedsts()+426<-ksdxfstk()+58<-ksdxcb()+872<-sspuser()+200<-__sighandler()<-semtimedop()+10<-skgpwwait()+187<-ksliwat()+2201<-kslwaitctx()+200<-kclwrcv()+1591<-kcbgcur()+58671<-ktbgcur()+112<-kdisparent()+291<-kdisinsertbr()+449<-kdisle()+5847<-kdiins1()+40000<-kdiinsp0()+113<-kauxsin()+1968<-kdtiidx()+1037<-kdtInsRow()+3638<-qerltcNoKdtBufferedInsRowCBK()+288<-qerltcSingleRowLoad()+293<-qerltcFetch()+391<-insexe()+733<-opiexe()+6714<-opipls()+2086<-opiodr()+1202<-rpidrus()+198<-skgmstack()+65<-rpidru()+132<-rpiswu
wait history:
* time between current wait and wait #1: 0.000013 sec
1. event: 'gc current retry'
time waited: 1 min 40 sec
wait id: 649069 p1: ''=0xc4
p2: ''=0x7acc3ae
p3: ''=0x2010001
* time between wait #1 and #2: 0.000132 sec
2. event: 'db file scattered read'
time waited: 0.000454 sec
wait id: 649068 p1: 'file#'=0x87
p2: 'block#'=0x21b4da8
p3: 'blocks'=0x8
* time between wait #2 and #3: 0.000333 sec
3. event: 'gc current multi block request'
time waited: 0.001009 sec
wait id: 649067 p1: 'file#'=0xc4
p2: 'block#'=0x7acc63f
p3: 'id#'=0x2000001
}
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 |
References |