This topic describes how to view the deadlock history.
You can view deadlock analysis information by using the following methods:
Method 1: Log in to the OceanBase Cloud Platform (OCP) console. In the left-side navigation pane, click OceanBase Autonomy Service. On the page that appears, find the target cluster and click its name to go to the Real-time Diagnostics page. Then, click the Session Management tab.
Method 2: Log in to the OCP console and go to the Overview page of the target tenant. In the left-side navigation pane, click Session Management and go to the View Deadlock History tab.
Prerequisites
To view the deadlock history by using Method 1, make sure that you have the following permissions:
- Resource Permissions: Cluster Read-only or Tenant Read-only permission
- Menu Permissions: Permission on the Real-time Diagnostics menu of OceanBase Autonomy Service
To view the deadlock history by using Method 2, make sure that you have the following permissions:
- Resource Permissions: Cluster Read-only or Tenant Read-only permission
- Menu Permissions: Permission on the Session Management menu of Tenants
Automatic detection of deadlocks is enabled for the cluster where the tenant belongs. For more information, see Enable automatic detection of deadlocks.
Procedure
The procedure of Method 1 is described as follows:
Log in to the OCP console.
In the left-side navigation pane, click OceanBase Autonomy Service.
In the Cluster Details section, click the name of the cluster that you want to view.
Go to the Session Management tab of the Real-time Diagnostics page.
Click the View Deadlock History tab and view the historical deadlock information.