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:

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

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