New ttXactLog option to move stuck XLA bookmark, workaround for TT 8029: Persistent Transaction Log API Bookmark Already In Use. (Doc ID 2022222.1)

Last updated on FEBRUARY 19, 2016

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.2.2.0 to 11.2.2.7.13 [Release 11.2]
Oracle TimesTen In-Memory Database - Version 11.2.2.8.0 to 11.2.2.8.5 [Release 11.2]
Oracle TimesTen In-Memory Database - Version 11.2.2.6.0 to 11.2.2.6.16 [Release 11.2]
Information in this document applies to any platform.

Symptoms

User encounters the following problem when trying to use ttXlaDeleteBookmark to remove an XLA bookmark of a XLA application that was killed:

8029: Persistent transaction log API bookmark already in use.

User is thus not able to recreate or reuse that XLA bookmark

User can also check if the transaction log table thinks there is an xla bookmark (id = bookmark name, inuse = used by persistent api (0=no, 1=yes), and pid = last pid to open xla bookmark): 

Command > select id, inuse, pid from TRANSACTION_LOG_API;

< XLABOOK.1 , 01, 16001 >

 

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