My Oracle Support Banner

Why can't I rollback a transaction using ttXactAdmin -xactIdRollback? (Doc ID 1496443.1)

Last updated on AUGUST 23, 2021

Applies to:

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

Symptoms

A user saw the following behaviour where ttXactAdmin -xactIdRollback could not rollback a transaction

 

$ ttxactadmin XXX


Outstanding locks

PID     Context            TransID     TransStatus Resource  ResourceID           Mode  SqlCmdID             Name

Program File Name: timestenorad

4491    0x1e4f2110          173.1056253 Active      Database  0x01312d0001312d00   IX    0
                                                   Row       BMUFVUAAAA4AwMAADR   Xn    0                    GRID.XXX_2

<missed out>
                                                   Row       BMUFVUAAAA5AwMACgD   Xn    0                    GRID.XXX_2
                                                   Table     718160               IXn   0                    GRID.XXX_2
                           122 locks found for transaction 173.1056253

1 outstanding transaction found

$ ttxactadmin -xactIdRollback 173.1056253 XXX

$ ttxactadmin XXX

Outstanding locks

PID     Context            TransID     TransStatus Resource  ResourceID           Mode  SqlCmdID             Name

Program File Name: timestenorad

4491    0x1e4f2110          173.1056253 Active      Database  0x01312d0001312d00   IX    0
                                                   Row       BMUFVUAAAA4AwMAADR   Xn    0                    GRID.XXX_2
<missed out>

                           122 locks found for transaction 173.1056253

1 outstanding transaction found

 

Changes

 

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