My Oracle Support Banner

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 later
Information 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


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