View the deadlock history

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:

1. Log in to the OCP console.

2. In the left-side navigation pane, click OceanBase Autonomy Service .

3. In the Cluster Details section, click the name of the cluster that you want to view.

4. Go to the Session Management tab of the Real-time Diagnostics page.

5. Click the View Deadlock History tab and view the historical deadlock information.