Goldengate Pump Extract Abended With ERROR OGG-01449 Scan failed in trail file <path> with scan start seqno <n>, rba <n> When Remote Trail Files Are On Mounted Filesystem (Doc ID 2110048.1)

Last updated on MARCH 21, 2016

Applies to:

Oracle GoldenGate - Version 12.1.2.1.10 and later
IBM AIX on POWER Systems (64-bit)

Symptoms

This issue is specific to IBM AIX OS where trails are stored on mount point.


Source Context :
SourceModule : [er.extrout]
SourceID : [/scratch/aime1/adestore/views/aime1_adc4150488/oggcore/OpenSys/src/app/er/extrout.c]
SourceFunction : [outTrailGetLastCsnRemote]
SourceLine : [6692]
ThreadBacktrace : [14] elements
: [/ccwfm_gg/goldengate/app/ccwfmgg/product/12.1.2/oggcore_1/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x2b7b394a2abe]]
: [/ccwfm_gg/goldengate/app/ccwfmgg/product/12.1.2/oggcore_1/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x340) [0x2b7b3949d7d0]]
: [/ccwfm_gg/goldengate/app/ccwfmgg/product/12.1.2/oggcore_1/libgglog.so(_MSG_ERR_RECOVERY_FAILED_TRAIL_SCAN(CSourceContext*, char const*, int, int, CMessageFactory::MessageDisposition)+0x3f) [0x2b7b3947c1b3]]
: [/ccwfm_gg/goldengate/app/ccwfmgg/product/12.1.2/oggcore_1/extract [0x557f62]]
: [/ccwfm_gg/goldengate/app/ccwfmgg/product/12.1.2/oggcore_1/extract [0x5559ff]]
: [/ccwfm_gg/goldengate/app/ccwfmgg/product/12.1.2/oggcore_1/extract [0x555c4b]]
: [/ccwfm_gg/goldengate/app/ccwfmgg/product/12.1.2/oggcore_1/extract(open_targ_ext_files(short)+0x43) [0x5563b3]]
: [/ccwfm_gg/goldengate/app/ccwfmgg/product/12.1.2/oggcore_1/extract(extract_main(int, char**)+0x37f) [0x5bce1f]]
: [/ccwfm_gg/goldengate/app/ccwfmgg/product/12.1.2/oggcore_1/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x4f) [0x6a8a0f]]
: [/ccwfm_gg/goldengate/app/ccwfmgg/product/12.1.2/oggcore_1/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x104) [0x6a8f14]]
: [/ccwfm_gg/goldengate/app/ccwfmgg/product/12.1.2/oggcore_1/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x8b) [0x6a92db]]
: [/ccwfm_gg/goldengate/app/ccwfmgg/product/12.1.2/oggcore_1/extract(main+0x3f) [0x5bc84f]]
: [/lib64/libc.so.6(__libc_start_main+0xf4) [0x34f901d994]]
: [/ccwfm_gg/goldengate/app/ccwfmgg/product/12.1.2/oggcore_1/extract [0x52e5e9]]

2015-12-21 10:46:04 ERROR OGG-01449 Scan failed in trail file /odsprod_nfsgg8/goldengate/dirdat/ccwfm/cx000000, with scan start seqno 0, rba 0.

2015-12-21 10:46:04 ERROR OGG-01668 PROCESS ABENDING.

 


1. Extract works fine upon first start.

2. It hangs while restarting. Noticed that, it has an issue doing recovery. Confirmed that, Collector/Server process has created dynamically at remote system.

3. It works fine if we alter extract pump with 'ETROLLOVER' option. This means that, we are altering checkpoint file. So, I believe checkpoint file is not being modified correctly while stopping first time.

Changes

 Moved the trail files to NFS mount.

Below are mount options:

rw,bg,hard,nointr,rsize=32768,wsize=32768,proto=tcp,noac,vers=3,timeo=600

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