MV_TRANSACTION_TABLE

Contains distributed transaction metadata.

Column Name

Description

NODE_ID

The node the transaction is from (MV).

DATABASE_NAME

The name of the database including the partition ordinal.

DATABASE_STATE

The state of the database (i.e online, replicating, etc.).

SHARDED_DATABASE_ID

The ID of the sharded database.

DATABASE_ROLE

The role of the database: Primary or Replica

TRANSACTION_ID

The ID of the distributed transaction.

COORDINATOR_ID

The ID of the coordinator.

PREPREPARE_TS

The timestamp the transaction selects just before beginning its prepare phase.

TIMESTAMP

Timestamp of the commit.

PARTICIPANT_LIST

List of all participants of the distributed transaction.

STATE

State of the transaction: Prepared, Committed, or Aborted

Last modified: June 5, 2023

Was this article helpful?