Purpose
The oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY view displays the history of deadlock events. After you log on as the root user to the sys tenant, you can view the deadlock event history of all tenants.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| EVENT_ID | bigint(20) unsigned | NO | The ID of the deadlock event. |
| SVR_IP | varchar(46) | NO | The IP address of the node participating in the deadlock event. |
| SVR_PORT | bigint(20) unsigned | NO | The port number on the node participating in the deadlock event. |
| DETECTOR_ID | bigint(20) unsigned | NO | The ID of the node participating in the deadlock event, which must be unique within the process. |
| REPORT_TIME | timestamp(6) | NO | The reporting time of the deadlock event based on the timestamp on the reporting server. |
| CYCLE_IDX | bigint(20) | NO | The number of the node in the deadlock cycle. |
| CYCLE_SIZE | bigint(20) | NO | The number of nodes participating in the deadlock event. |
| ROLE | longtext | NO | The role that the node plays in the deadlock event. Valid values: |
| PRIORITY_LEVEL | longtext | NO | The level of priority of the node. Valid values: |
| PRIORITY | bigint(20) unsigned | NO | The priority value that the node has. When the priorities are the same, the priority values are checked, and the node with the lowest priority value in the cycle is evicted. |
| CREATE_TIME | timestamp(6) | NO | The time when the node was created. |
| START_DELAY_US | bigint(20) unsigned | NO | The interval, in μs, between the node creation time and the time when deadlock detection starts. |
| MODULE | longtext | NO | The module where the node resides, such as transaction. |
| VISITOR | longtext | NO | The resource visitor represented by the node, such as trans_id. |
| OBJECT | longtext | NO | The resource that the node requests for, such as row_key. |
| EXTRA_NAME1 | longtext | YES | The name of additional information 1 that the upper layer wishes to add to the deadlock report event. |
| EXTRA_VALUE1 | longtext | YES | The content of additional information 1 that the upper layer wishes to add to the deadlock report event. |
| EXTRA_NAME2 | longtext | YES | The name of additional information 2 that the upper layer wishes to add to the deadlock report event. |
| EXTRA_VALUE2 | longtext | YES | The content of additional information 2 that the upper layer wishes to add to the deadlock report event. |
| EXTRA_NAME3 | longtext | YES | The name of additional information 3 that the upper layer wishes to add to the deadlock report event. |
| EXTRA_VALUE3 | longtext | YES | The content of additional information 3 that the upper layer wishes to add to the deadlock report event. |