SHOW TRANSACTION

description

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

grammar:

SHOW TRANSACTION
[FROM db_name]
WHERE id = transaction_id;

Example return result:

     TransactionId: 4005
             Label: insert_8d807d5d-bcdd-46eb-be6d-3fa87aa4952d
       Coordinator: FE: 10.74.167.16
 TransactionStatus: VISIBLE
 LoadJobSourceType: INSERT_STREAMING
       PrepareTime: 2020-01-09 14:59:07
        CommitTime: 2020-01-09 14:59:09
        FinishTime: 2020-01-09 14:59:09
            Reason:
ErrorReplicasCount: 0
        ListenerId: -1
         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;

keyword

SHOW, TRANSACTION