Amazon Redshift

Question

Hi Amazon Redshift cluster is erroring out "ERROR: Query (2842874) cancelled on user's request".  We are using Redshift query editor v2. Is there any script or query we can check or logs which will tell us why this is happening. If there is any setting which we need to change please let know, Thanks in advance.

Answer

Please note that the query in Amazon Redshift can abort for the following reasons:

1.     Due to Amazon Redshift workload management (WLM) query monitoring rules implemented on cluster.
2.     Timeout settings
3.     ABORT, CANCEL, or TERMINATE requests by user/ admin.
4.     Network issues.
5.     Cluster maintenance upgrades.
6.     Internal processing errors.
7.     ASSERT errors.

You can prevent the query from being aborted, by some of the approaches mentioned below
1.     Increase your timeout parameter.
2.     Update your WLM QMR rules [ If you have found out which rule is aborting your query]
3.     Schedule long-running operations outside of maintenance windows.

Answer

This could be anywhere from user actually cancelling query to firewall rules disconnecting web sockets. Best recourse is to log a support ticket and have it investigated.

Amazon Redshift

Conteúdo relevante