Hbase Adapter replicat abended- oracle.goldengate.util.GGException: Unable to commit transaction (Doc ID 2305241.1)

Last updated on JULY 18, 2023

Applies to:

Symptoms

The Hbase Adapter replicat abended with the following error

org.apache.hadoop.hbase.client.AsyncProcess$AsyncRequestFutureImpl waitUntilDone
INFO: #2, waiting for 20090 actions to finish
Aug 11, 2017 4:15:54 AM
org.apache.hadoop.hbase.client.AsyncProcess$AsyncRequestFutureImpl logNoResubmit
WARNING: #2, table=P117:S_PROD_INT, attempt=35/35 failed=20090ops, last
exception: java.io.IOException: Call to
l<host_name>:port failed on local exception:
org.apache.hadoop.hbase.ipc.CallTimeoutException: Call id=250,
waitTime=60001, operationTimeout=60000 expired. on
<host_name>:port,1500911807279, tracking started Fri Aug 11
03:32:22 EDT 2017; not retrying 20090 - final failure
ERROR [main] (HBase98Writer.java:309) - A failure occurred when flushing
HBase tables.
org.apache.hadoop.hbase.client.RetriesExhaustedWithDetailsException: Failed
20090 actions: IOException: 20090 times,
at
org.apache.hadoop.hbase.client.AsyncProcess$BatchErrors.makeException(AsyncPro
cess.java:247)
at
org.apache.hadoop.hbase.client.AsyncProcess$BatchErrors.access$1800(AsyncProce
ss.java:227)
at
org.apache.hadoop.hbase.client.AsyncProcess$AsyncRequestFutureImpl.getErrors(A
syncProcess.java:1663)
at
org.apache.hadoop.hbase.client.HTable.batch(HTable.java:982)
at
oracle.goldengate.handler.hbase.operations.HBase98Writer.flushTables(HBase98Wr
iter.java:304)
at
oracle.goldengate.handler.hbase.HBaseHandler.transactionCommit(HBaseHandler.ja
va:412)
at
oracle.goldengate.datasource.DsEventManager$2.send(DsEventManager.java:430)
at
oracle.goldengate.datasource.DsEventManager$EventDispatcher.distributeEvent(Ds
EventManager.java:231)
at
oracle.goldengate.datasource.DsEventManager.fireTransactionCommit(DsEventManag
er.java:438)
at
oracle.goldengate.datasource.AbstractDataSource.fireTransactionCommit(Abstract
DataSource.java:490)
at
oracle.goldengate.datasource.UserExitDataSource.commitActiveTransaction(UserEx
itDataSource.java:1663)
at
oracle.goldengate.datasource.UserExitDataSource.commitTx(UserExitDataSource.ja
va:1573)
DEBUG [main] (HBaseHandler.java:416) - Received transaction commit event,
transaction count=1, pos=00000001020289832006 (total_ops= 26779, buffered=0),
ts=2017-08-10 06:40:20.009716
WARN [main] (DsEventManager.java:259) - Error sending event to handler:
status=ABEND, event=Commit transaction, handler=hbase
DEBUG [main] (UserExitDataSource.java:1664) - Returned status is
ABENDABEND(1)
Exception in thread "main" oracle.goldengate.util.GGException: Unable to
commit transaction, STATUS=ABEND
at
oracle.goldengate.datasource.UserExitDataSource.commitActiveTransaction(UserEx
itDataSource.java:1670)
at
oracle.goldengate.datasource.UserExitDataSource.commitTx(UserExitDataSource.ja
va:1573)
Source Context :
SourceModule : [gglib.ggdal.adapter.java]
SourceID :
[/scratch/aime/adestore/views/aime_adc4150311/oggcore/OpenSys/src/gglib/ggdal/
Adapter/Java/JavaAdapter.cpp]
SourceFunction : [HandleJavaException]
SourceLine : [158]
ThreadBacktrace : [20] elements
:
[/ORACLE/goldengate/siebel/12.2.0/libgglog.so(CMessageContext::AddThreadContex
t()+0x26) [0x7f8a3f7cc336]]
:
[/ORACLE/goldengate/siebel/12.2.0/libgglog.so(CMessageFactory::CreateMessage(C
SourceContext*, unsigned int, ...)+0x6a8) [0x7f8a3f7bf358]]
:
[/ORACLE/goldengate/siebel/12.2.0/libgglog.so(_MSG_ERR_JAVA_EXCEPTION(CSourceC
ontext*, char const*, CMessageFactory::MessageDisposition)+0x41)
[0x7f8a3f741f41]]
:
[/ORACLE/goldengate/siebel/12.2.0/libggjava.so(+0x2fddf) [0x7f8a303faddf]]
:
[/ORACLE/goldengate/siebel/12.2.0/libggjava.so(ggs::gglib::ggdal::CJavaRecordW
riter::CommitTransaction(ggs::gglib::ggdal::CDALError&)+0x145)
[0x7f8a303fc925]]
:
[/ORACLE/goldengate/siebel/12.2.0/replicat(ggs::gglib::ggdal::CDALRecordWriter
::CommitTransaction(ggs::gglib::ggdal::CDALError&)+0x5d) [0x7b897d]]
:
[/ORACLE/goldengate/siebel/12.2.0/replicat(GenericImpl::CommitTransaction()+0x
30) [0x79f080]]
:
[/ORACLE/goldengate/siebel/12.2.0/replicat(odbc_commit_transaction()+0x16)
[0x799936]]
:
[/ORACLE/goldengate/siebel/12.2.0/replicat(Commit_and_Checkpoint(short,
bool&)+0x189) [0x644459]]
:
[/ORACLE/goldengate/siebel/12.2.0/replicat(ClassicWorker::CommitAndCheckpoint(
short)+0x11) [0x5863e1]]
:
[/ORACLE/goldengate/siebel/12.2.0/replicat(REP_end_transaction(short)+0x17)
[0x644b97]]
:
[/ORACLE/goldengate/siebel/12.2.0/replicat(ggs::er::ReplicatContext::processRe
plicatLoop(ggs::Heartbeat::MapGeneratorParams&)+0x2ff9) [0x5e54d9]]
:
[/ORACLE/goldengate/siebel/12.2.0/replicat(ggs::er::ReplicatContext::run(ggs::
Heartbeat::MapGeneratorParams&)+0x38) [0x5d6308]]
: [/ORACLE/goldengate/siebel/12.2.0/replicat()
[0x645e9b]]
:
[/ORACLE/goldengate/siebel/12.2.0/replicat(ggs::gglib::MultiThreading::MainThr
ead::ExecMain()+0x66) [0x771ba6]]
:
[/ORACLE/goldengate/siebel/12.2.0/replicat(ggs::gglib::MultiThreading::Thread:
:RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x147)
[0x775f77]]
:
[/ORACLE/goldengate/siebel/12.2.0/replicat(ggs::gglib::MultiThreading::MainThr
ead::Run(int, char**)+0x12d) [0x77658d]]
:
[/ORACLE/goldengate/siebel/12.2.0/replicat(main+0x3b) [0x647b1b]]
: [/lib64/libc.so.6(__libc_start_main+0xfd)
[0x308621ed5d]]
: [/ORACLE/goldengate/siebel/12.2.0/replicat()
[0x5368d9]]

2017-08-11 04:15:54 ERROR OGG-15051 Java or JNI exception:
oracle.goldengate.util.GGException: Unable to commit transaction,
STATUS=ABEND.

Changes

Cause

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