My Oracle Support Banner

Resolve TimesTen Error "TT16187: Transaction: N.N; Error: transient 0, permanent 1 state 2" When Executing ALTER TABLE With Classic Replication - Bug 18136810 (Doc ID 1633082.1)

Last updated on AUGUST 23, 2021

Applies to:

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

Symptoms

 In a multi-primary replication scheme , following permanent error is observed while dropping the columns

From the ttmesg.log in node 2 following error is observed

04:20:51.12 Err : REP: 31452: [1097898304, 0, noAwt] DG_222221:receiver.c(14136): TT16094: Failed to execute SQL: ALTER TABLE "TIMESTEN"."T1" DROP ("C2")
04:20:51.13 Err : REP: 31452: [1097898304, 0, noAwt] DG_222221:receiver.c(8091): TT16187: Transaction: 1390795896.340; Error: transient 0, permanent 1 state 2 error message :
04:20:51.13 Info: REP: 31549: [1106286912, 0, noAwt] DG_222222:transmitter.c(2717): TT16117: Dropped definition for column C2 (in table TIMESTEN.T1) from TTREP.REPTABLES

This error is permanent error which means that replicated transaction is not going to be re-tried. This is not correct.
Ideally in this scenario, TT6003 Lock request denied because of time-out Details should appear in the log as ALTER
table is not applied in the subscriber node as exclusive lock has not acquired

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
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.