OCI-24776
Cannot start or resume the attempt_transaction_type transaction (attempt_transaction_id) due to existing exist_transaction_type transaction (exist_transaction_id)
- attempt_transaction_type: Type of the transaction that failed to start or resume. It can be "sessionless" or "global".
- attempt_transaction_id: Identifier of the transaction that failed to start or resume. See additional information.
- exist_transaction_type: The type of the transaction to which the session is attached. It can be "local", "sessionless" or "global".
- exist_transaction_id: Identifier of the transaction to which the current session has attached. See additional information.
Cause
An attempt to start or resume the transaction is failing because the session is currently attached to an existing transaction.
Action
Process these steps:
- Detach the transaction from the current session:
- For a local transaction, commit or rollback the transaction.
- For a sessionless transaction, commit, rollback or suspend the transaction.
- For a global transaction, end the transaction.
- Retry starting or resuming the desired transaction.
Additional Information
A local transaction is identified by its local transaction ID,
which is composed of three decimal numbers separated by dots.
For example, 3.17.1954.
A sessionless transaction is identified by its global transaction
identifier (GTRID), which is a byte array and is printed as
hexadecimal. For example, 6D2ACF.
A global transaction is identified by the set (Format ID, GTRID,
and Branch Qualifier). Format ID is decimal; GTRID and Branch
Qualifier are byte arrays and are printed as hexadecimal. For
example, (1234, 6D2ACF, 435BC28E).