SHOW TRANSACTION

description

This syntax is used to view transaction details for the specified transaction id or label name.

grammar:

  1. SHOW TRANSACTION
  2. [FROM db_name]
  3. WHERE
  4. [id = transaction_id]
  5. [label = label_name];

Example return result:

  1.      TransactionId: 4005
  2.              Label: insert_8d807d5d-bcdd-46eb-be6d-3fa87aa4952d
  3.        Coordinator: FE: 10.74.167.16
  4.  TransactionStatus: VISIBLE
  5.  LoadJobSourceType: INSERT_STREAMING
  6.        PrepareTime: 2020-01-09 14:59:07
  7.         CommitTime: 2020-01-09 14:59:09
  8.         FinishTime: 2020-01-09 14:59:09
  9.             Reason:
  10. ErrorReplicasCount: 0
  11.         ListenerId: -1
  12.          TimeoutMs: 300000
  • TransactionId: transaction id
  • Label: the label of the corresponding load job
  • Coordinator: the node responsible for transaction coordination
  • TransactionStatus: transaction status * PREPARE: preparation stage * COMMITTED: The transaction was successful, but the data is not visible * VISIBLE: The transaction was successful and the data is visible * ABORTED: transaction failed
  • LoadJobSourceType: The type of the load job.
  • PrepareTime: transaction start time
  • CommitTime: the time when the transaction was successfully committed
  • FinishTime: The time when the data is visible
  • Reason: error message
  • ErrorReplicasCount: Number of replicas with errors
  • ListenerId: the id of the related load job
  • TimeoutMs: transaction timeout time in milliseconds

example

  1. View the transaction with id 4005:

    SHOW TRANSACTION WHERE ID = 4005;

  2. Specify the db and view the transaction with id 4005:

    SHOW TRANSACTION FROM db WHERE ID = 4005;

  3. View the transaction with label label_name:

    SHOW TRANSACTION WHERE LABEL = ‘label_name’;

keyword

  1. SHOW, TRANSACTION