2개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
3
Please note that the query in Amazon Redshift can abort for the following reasons:
-
Due to Amazon Redshift workload management (WLM) query monitoring rules implemented on cluster.
-
Timeout settings
-
ABORT, CANCEL, or TERMINATE requests by user/ admin.
-
Network issues.
-
Cluster maintenance upgrades.
-
Internal processing errors.
-
ASSERT errors.
You can prevent the query from being aborted, by some of the approaches mentioned below
-
Increase your timeout parameter.
-
Update your WLM QMR rules [ If you have found out which rule is aborting your query]
-
Schedule long-running operations outside of maintenance windows.
0
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.
관련 콘텐츠
- AWS 공식업데이트됨 한 달 전
- AWS 공식업데이트됨 2년 전
- AWS 공식업데이트됨 2년 전
- AWS 공식업데이트됨 일 년 전