Help Center/ GaussDB(DWS)/ Management Guide/ Monitoring and Alarms/ Alarms/ Alarm Handling/ DWS_2000000017 Number of Queuing Query Statements Exceeds the Threshold

Updated on 2024-09-05 GMT+08:00

View PDF

DWS_2000000017 Number of Queuing Query Statements Exceeds the Threshold

Description

When real-time query monitoring is enabled, GaussDB(DWS) checks the queuing status of jobs on CNs through the GS_WLM_SESSION_STATISTICS view every 60 seconds by default.

This alarm is generated when the number of queuing SQL statements in the cluster exceeds 10 (configurable) within 10 minutes (configurable), and is automatically cleared when the number of queuing SQL statements drops below 10.

If there continues to be queuing query statements more than the alarm threshold, the alarm is generated again 24 hours later (configurable).

Alarm Attributes

Alarm ID	Alarm Category	Alarm Severity	Alarm Type	Service Type	Auto Cleared
DWS_2000000017	Management plane alarm	Urgent: >10	Operation alarm	GaussDB(DWS)	Yes

Alarm Parameters

Category	Name	Description
Location information	Name	Number of Queuing Query Statements Exceeds the Threshold
	Type	Operation alarm
	Generation time	Time when the alarm is generated
Other information	Cluster ID	Cluster details such as resourceId and domain_id

Impact on the System

SQL queries are blocked. As a result, the execution time is too long.

Possible Causes

The number of queuing query statements during service execution exceeds the alarm threshold.

Handling Procedure

Check whether the current queuing jobs in the cluster are normal.

Log in to the GaussDB(DWS) console.
Choose Management > Alarms in the navigation pane on the left, select the current cluster from the cluster selection drop-down list in the upper right corner and view the alarm information of the cluster in the last seven days. Locate the name of the cluster that triggers the alarm based on the location information.
On the Clusters > Dedicated Clusters page, locate the row that contains the cluster for which the alarm is generated and click Monitoring Panel in the Operation column.
Choose Monitoring > Queries to view the real-time sessions and queries of the current cluster. Select the Queries tab to view the status of jobs being executed in the current cluster. Click and select Blocking Time (ms) and Waiting status. Click to sort the values of Blocking Time (ms). You can view the information about the waiting SQL statements with the longest blocking time. If a query job is in the waiting state and the blocking time is abnormal, you can terminate the query.

Current queuing status of the statements, including:
- Global: global queuing.
- Respool: resource pool queuing.
- CentralQueue: queuing on the CCN
- Transaction: being in a transaction block
- StoredProc: being in a stored procedure
- None: not in a queue
- Forced None: being forcibly executed (transaction block statement or stored procedure statement are) because the statement waiting time exceeds the specified value