DWS_2500000001 DWS Cluster Schema Usage Exceeds the Threshold

Alarm Description

This alarm is generated by the DMS alarm module if the schema usage in the cluster goes beyond the set threshold within a specific time frame and the suppression conditions are not met. The alarm will be cleared once the schema usage in the cluster drops below the threshold.

Alarm Attributes

Alarm ID	Alarm Category	Alarm Severity	Alarm Type	Service Type	Auto Cleared	Threshold Alarm Type
DWS_2500000001_OM	Tenant plane	User-defined by threshold (Critical/Major/Minor/Warning)	Quality of service	Data Warehouse Service (DWS)	Yes	Cloud service threshold alarm

Alarm Parameters

Type	Parameter	Description
Location Information	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.
	Node name	Name of the node for which the alarm is generated.
	Instance name	Name of the instance for which the alarm is generated.
	Database name	Name of the database for which the alarm is generated.
	First_alarm_time	Time when an alarm was generated first time.

Impact on the System

Users cannot create more data in the schema.

Possible Causes

The table data in the schema occupies a large amount of space.

Handling Procedure

Log in to the DWS console.
Click the name of the target cluster. In the navigation pane, choose Intelligent O&M.
Click the O&M Plan tab. Click Add O&M Task.
Perform the following operations on the Add O&M Task page:
- Select Vacuum for O&M Task.
- Set Scheduling Mode to Auto. DWS automatically scans tables that require VACUUM operation.
- Set Auto to User tables (VACUUM FULL).
Click Next: Configure Schedule to configure the schedule and Vacuum type. You are advised to select Periodic for Task Type. DWS automatically executes VACUUM in your selected time windows.

For automatic Vacuum O&M tasks, the system uses the VACUUM FULL operation to process user tables. VACUUM FULL holds a level 8 lock, which blocks other transactions. Other transactions will be in lock waiting during VACUUM FULL execution. After 20 minutes, a timeout error is reported. Therefore, do not perform other transactions in the configured time window.
Click Next: Finish. After you confirm the information, click Finish to submit the request.