DWS_2000000031 Active Session Usage in a GaussDB(DWS) Cluster Exceeds the Threshold

Updated on 2025-03-03 GMT+08:00

View PDF

Alarm Description

The DMS alarm module generates an alarm if the active session usage in the cluster exceeds the set threshold within a specific time frame and the suppression conditions are not met. The alarm is cleared when the DMS alarm module detects that the active session usage in the cluster is below the threshold.

Alarm Attributes

Alarm ID	Alarm Category	Alarm Severity	Alarm Type	Service Type	Auto Cleared
DWS_2000000031	Management plane alarm	> 90 (Critical); > 80 (Major)	Service alarm	GaussDB(DWS)	Yes

Alarm Changes

Change Type	Change Version	Description	Reason for Change
New	8.2.1.230	New alarm	New alarm

Alarm Parameters

Type	Parameter	Description
Fault Location	Cluster name	Cluster for which the alarm is generated.
	Tenant name	Name of the tenant to which the cluster belongs.
	Alarm level	Severity of the alarm.
Additional Information	Resource ID	ID of the cluster for which the alarm is generated.
	Resource name	Cluster for which the alarm is generated.
	First_alarm_time	First occurrence event of an alarm, including the alarm threshold and current value.

Impact on the System

The number of available sessions is insufficient, affecting service execution.

Possible Causes

The value of max_active_statements is too small.

Procedure

Log in to the GaussDB(DWS) console and choose Dedicated Clusters > Clusters in the navigation pane on the left.
In the cluster list, locate the desired cluster and click the cluster name. The Cluster Information page is displayed.
In the navigation pane on the left, choose Parameter Modifications. On the Parameters tab page, search for and modify the following parameters, and click Save.
1. In the Common Configuration area, enter resource_track_duration in the search box to find the parameter and set both Value for CN and Value for DN to 1.
  Figure 1 Modifying the resource_track_duration parameter
2. In the Common Configuration area, enter topsql_retention_time in the search box to find the parameter and set both Value for CN and Value for DN to 14. Alternatively, you can set them as needed.
  Figure 2 Modifying the topsql_retention_time parameter
Find the SQL statement that causes the deadlock.
- Method 1
1. Return to the Dedicated Clusters page. Locate your desired cluster and click Monitoring Panel in the Operation column.
2. In the navigation pane on the left, choose Monitoring > Historical Queries. In the upper right corner of the history query page, select Reason and the keyword deadlock detected.
3. Find the SQL statements that cause the deadlock. Sort them chronologically to pinpoint the most recent statement causing the deadlock.
  Figure 3 SQL statement 1 causing the deadlock
- Method 2
1. Return to the console. In the navigation pane on the left, choose Monitoring > Optimization Diagnosis.
2. On the displayed General trend of historical queries sub-tab of Historical query analysis, select Reason and the keyword deadlock detected.
3. Find the SQL statements that cause the deadlock. Sort them chronologically to pinpoint the most recent statement causing the deadlock.
  Figure 4 SQL statement 2 causing the deadlock
Solution to the deadlock issue: Deadlocks will be automatically detected in Huawei Cloud Stack 8.2.1 or later clusters. The detection will be delayed for 1 second. The lock will be automatically released when a deadlock is detected.

Alarm Clearance

This alarm is automatically cleared after the fault is rectified.

Related Information

None

Parent topic: Alarm Handling

Previous topic: DWS_2000000030 Session Usage in a GaussDB(DWS) Cluster Exceeds the Threshold

Next topic: DWS_2000000032 Number of Database Deadlocks in a GaussDB(DWS) Cluster Exceeds the Threshold

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.

Chatbot