Classic Extract - Extract Hang Using 100% CPU (Doc ID 1528401.1)

Last updated on MAY 16, 2017

Applies to:

Oracle GoldenGate - Version 11.2.1.0.1 to 11.2.1.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Extract or Datapump abend on start up ; or

Datapump process using 100% CPU and not advancing .

pstack from process consuming CPU or backtrace (bt) from a core dump may show a stack similar to the
following :

 0: 4000000000705ed0 : parse_supp_token_buf(char*,int,chkpt_context_t*)() at /scratch/aime1/adestore/views/aime1_staoj01/oggcore/OpenSys/src/gglib/ggapp/checkpt.c:2744
 1: 400000000070d430 : CP_read_checkpoint_csn(chkpt_context_t*,int,bool)() at /scratch/aime1/adestore/views/aime1_staoj01/oggcore/OpenSys/src/gglib/ggapp/checkpt.c:3365
 2: 40000000003d4670 :
START_EXTRACT_CHECKPOINT(chkpt_context_t*,char*,char*,char*,char*,short,int,int,int,char*,short,short,short)() at
/scratch/aime1/adestore/views/aime1_staoj01/oggcore/OpenSys/src/app/er/api.c:2647
 3: 40000000005b9a90 : extract_start_point(time_elt_def*,time_elt_def*)() at /scratch/aime1/adestore/views/aime1_staoj01/oggcore/OpenSys/src/app/er/common.cpp:2053
 4: 40000000006a76a0 : main() at
/scratch/aime1/adestore/views/aime1_staoj01/oggcore/OpenSys/src/app/er/extract/extract.cpp:804
 5: c000000000045880 : main_opd_entry() + 0x50 (/usr/lib/hpux64/dld.so)

Note : parse_supp_token_buf should be visible in one of the threads.

Changes

 versions - 11.2.1.0.1 -> 11.2.1.0.4 being used.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms