Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

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:

Was this article helpful?