INFORMATION_SCHEMA.TDSTORE_PESSIMISTIC_DEADLOCK_INFO can be queried on the node where deadlock detection is performed to obtain the occurrence time of all historical deadlocks, the ID of the transaction that was rolled back, the IDs of the transactions that form the deadlock cycle, and the Node ID of the SQLEngine that executed the transaction.Field Name | Type | Description |
rollback_trans_id | bigint unsigned | The ID of the rolled-back transaction. |
cycle_transactions | longtext | The IDs of transactions forming a deadlock ring and the Node ID of the SQLEngine executing each transaction. |
occurred_at | timestamp(3) | The occurrence time of deadlocks. |
tdsql> SELECT * FROM information_schema.tdstore_pessimistic_deadlock_info;+----------------------+--------------------------------------------------------+-------------------------+| rolled_back_trans_id | cycle_transactions | occurred_at |+----------------------+--------------------------------------------------------+-------------------------+| 29342246289539082 | 29342246289539082 (node 1), 29342246423756948 (node 1) | 2026-04-28 15:31:08.555 |+----------------------+--------------------------------------------------------+-------------------------+
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback