Replication Failures, many locks were observed on the standby node (Doc ID 1922756.1)

Last updated on FEBRUARY 27, 2016

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.2.6.7 and later
Information in this document applies to any platform.

Symptoms

Replication not receiving updates on the standby node.  Over 13000 locks were observed on the standby node by repd through ttxactadmin output. 

pstack of the replication receiver doing this:

Thread 3 (Thread 0x2b2336882940 (LWP 32299)):
#0  0x00002b21325acd0d in sbHaLookup () from /home/syscatsttadminuser/TimesTen/t
#1  0x00002b21325913b4 in sbHixLookup () from /home/syscatsttadminuser/TimesTen/
#2  0x00002b213258ff43 in sbHixGetCursorFirstFetchLocks () from /home/syscatstta
#3  0x00002b21324f9021 in sbIxCurNext () from /home/syscatsttadminuser/TimesTen/
#4  0x00002b213253fd19 in sbEeHashScanNext () from /home/syscatsttadminuser/Time
#5  0x00002b213244cdbd in sbEeNLJoinNext () from /home/syscatsttadminuser/TimesT
#6  0x00002b213244cd39 in sbEeNLJoinNext () from /home/syscatsttadminuser/TimesT
#7  0x00002b213244cd39 in sbEeNLJoinNext () from /home/syscatsttadminuser/TimesT
#8  0x00002b2132138c61 in sbEeUpdateEval () from /home/syscatsttadminuser/TimesT
#9  0x00002b2132be1719 in updateViews () from /home/syscatsttadminuser/TimesTen/
#10 0x00002b2132139ac9 in sbEeUpdateEval () from /home/syscatsttadminuser/TimesT
#11 0x00002b213257f5b0 in sbEeStmtEval () from /home/syscatsttadminuser/TimesTen
#12 0x00002b21327f4982 in sbSqlCmdExecLoop () from /home/syscatsttadminuser/Time
#13 0x00002b2132ba0795 in sb_sqlExecLoop () from /home/syscatsttadminuser/TimesT
#14 0x0000000000473f48 in rxUpdFlush ()
#15 0x000000000046805c in rxRunTx ()
#16 0x000000000045c228 in rxRunBatch ()
#17 0x000000000045ba03 in rxAck ()
#18 0x000000000045ae53 in rxBatchAck ()
#19 0x0000000000455b0f in ServeRqst ()
#20 0x0000000000453055 in receiver ()
#21 0x000000000040ed23 in chaperone ()
#22 0x000000312be0683d in start_thread () from /lib64/libpthread.so.0
#23 0x000000312aed500d in clone () from /lib64/libc.so.6

 



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