TIMESTEN:TT16999: XXX TXNCOMMIT DID NOT FIND TXN FOR XID <XXXX> WITH CTN (Doc ID 2270500.1)

Last updated on JUNE 01, 2017

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.2.8.17 to 11.2.2.8.20 [Release 11.2]
Information in this document applies to any platform.

Symptoms

In this particular case customer facing issue where intermittent transaction taking more than 10 seconds. This is a two safe replication with default return wait time .

During this time we observe below kind of message in the log

2017-01-31 15:56:44.07 Info: REP: 30790: [0x7fa847cfe700, 0, noAwt]TT00:transmitter.c(12475): TT16999: XXX txnCommit did not find txn for XID: <152.145426> with CTN:1484725372.7

This is the replication configuration

create active standby pair
scn_tt00 on "XXXXXX", scn_tt00 on "YYYYYYY" return twosafe
store scn_tt00 on "XXXXXXX"
disable return all 1
durable commit off
resume return 10000
failthreshold 3
local commit action commit
return services off when stopped
store scn_tt00 on "YYYYYYY"
disable return all 1
durable commit off
resume return 10000
failthreshold 3
local commit action commit
return services off when stopped

DMLs were running in the active node continuously.

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