INFORMATION_SCHEMA.TDSTORE_PESSIMISTIC_DEADLOCK_INFO on the node performing deadlock detection, you can obtain the occurrence time of all historical deadlocks, the ID of the rolled-back transaction, the IDs of transactions forming a deadlock ring, and the Node ID of the SQLEngine executing each 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. |
timestamp | varchar(64) | The occurrence time of deadlocks. |
tdsql> SELECT * FROM information_schema.tdstore_pessimistic_deadlock_info;+----------------------+--------------------------------------------------------+-------------------------+| rolled_back_trans_id | cycle_transactions | timestamp |+----------------------+--------------------------------------------------------+-------------------------+| 29342246289539082 | 29342246289539082 (node 1), 29342246423756948 (node 1) | 2025-06-03 15:03:05 501 |+----------------------+--------------------------------------------------------+-------------------------+
피드백