Purpose
Note
This view is introduced since OceanBase Database V4.0.0.
Note
This view is introduced since OceanBase Database V4.0.0.
This view DBA_OB_DEADLOCK_EVENT_HISTORY displays the history of deadlock events of the current user tenant.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| 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 between the node creation time and the time when deadlock detection starts. Unit: ms. |
| 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. Valid value: wait_sql. |
| EXTRA_VALUE1 | longtext | YES | The content of additional information 1 that the upper layer wishes to add to the deadlock report event. It indicates the SQL statement that causes the deadlock in the transaction. |
| EXTRA_NAME2 | longtext | YES | The name of additional information 2 that the upper layer wishes to add to the deadlock report event. Valid value: hold_sql_request_time. |
| EXTRA_VALUE2 | longtext | YES | The content of additional information 2 that the upper layer wishes to add to the deadlock report event. It indicates the request time of the SQL statement that holds the lock. |
| EXTRA_NAME3 | longtext | YES | The name of additional information 3 that the upper layer wishes to add to the deadlock report event. Valid value: hold_sql. |
| EXTRA_VALUE3 | longtext | YES | The content of additional information 3 that the upper layer wishes to add to the deadlock report event. It indicates the SQL statement that holds cycle_idx - 1 row records corresponding to the Object. |
Sample query
Query the history of deadlock events for all tenants.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY LIMIT 10;