You can only hop a query if there's a matching queue available for the user group or query group configuration. Verify that the queues match the WLM configuration. Run the following query for more information on the service_class to queue mapping: select * from stv_wlm_service_class_config where service_class>5 Īfter you get the queue mapping information, check the WLM configuration from the Amazon Redshift console. For example, service_class 6 might list Queue1 in the WLM configuration, and service_class 7 might list Queue2. In your output, the service_class entries 6-13 include the user-defined queues. If your query is canceled with this error message, then run the following query to check the user-defined queues: select * from stl_wlm_query where query= "ERROR: Query (500104) canceled on user's request and ran out of wlm queues for restart." If a query is hopped but no matching queues are available, then the canceled query returns the following error message: Note: You can hop queries only in a manual WLM configuration. For more information, see Properties for the wlm_json_configuration parameter. A canceled query isn't reassigned to the default queue. If the query doesn't match a queue definition, then the query is canceled. When a query is hopped, WLM attempts to route the query to the next matching queue based on the WLM queue assignment rules. If your query ID is listed in the output, then increase the time limit in the WLM QMR parameter.Įxample 2: No available queues for the query to be hoppedĪ query can be hopped if the "hop" action is specified in the query monitoring rule. The query output lists all queries that are canceled by the "abort" action. To identify whether a query was canceled because of an "abort" action, run the following query: select * from STL_WLM_RULE_ACTION where action = 'abort' "ERROR: Query (500029) cancelled by WLM abort action of Query Monitoring Rule "testrule"." If a query is canceled because of the abort action that's specified in a query monitoring rule, then the query returns the following error: For example, create a rule that cancels queries that run for more than a 60-second threshold.Įxample 1: Abort action specified in the query monitoring rule Or, specify the actions that Amazon Redshift takes when a query exceeds the WLM time limits. Resolution Setup of Amazon Redshift WLM query monitoring rulesĬreate WLM query monitoring rules (QMRs) to define metrics-based performance boundaries for your queues.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |