My Oracle Support Banner

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 19, 2019

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
: [<GGHOME>/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x2b7b394a2abe]]
: [<GGHOME>/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x340) [0x2b7b3949d7d0]]
: [<GGHOME>/libgglog.so(_MSG_ERR_RECOVERY_FAILED_TRAIL_SCAN(CSourceContext*, char const*, int, int, CMessageFactory::MessageDisposition)+0x3f) [0x2b7b3947c1b3]]
: [<GGHOME>/extract [0x557f62]]
: [<GGHOME>/extract [0x5559ff]]
: [<GGHOME>/extract [0x555c4b]]
: [<GGHOME>/extract(open_targ_ext_files(short)+0x43) [0x5563b3]]
: [<GGHOME>/extract(extract_main(int, char**)+0x37f) [0x5bce1f]]
: [<GGHOME>/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x4f) [0x6a8a0f]]
: [<GGHOME>/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x104) [0x6a8f14]]
: [<GGHOME>/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x8b) [0x6a92db]]
: [<GGHOME>/extract(main+0x3f) [0x5bc84f]]
: [/lib64/libc.so.6(__libc_start_main+0xf4) [0x34f901d994]]
: [<GGHOME>/extract [0x52e5e9]]

2015-12-21 10:46:04 ERROR OGG-01449 Scan failed in trail file <PATH>xx000000, 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

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.