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

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.
On the Alarm page, view the alarms generated in the last seven days.
Choose Dedicated Clusters > Clusters and locate the cluster based on the cluster information in the alarm details.
Click the name of a cluster to view its details. On the cluster details page, click Parameter Modifications, search for max_active_statements in the search box on the right of the parameter list, and change its value.

Figure 1 Modifying parameters