How to fix timeout error when refreshing dataset in redshift SPICE

Question & Answer
1

Hi Quicksight team, I constantly received timeout error message recently when refreshing datasets, though it went well before. Could you let me know what the key cause is? the dataset was built in redshift SPICE.

Ingestion Id

e7c16f38-ee0e-45ad-9963-179486bfff00

Error type:

SQL_EXCEPTION Learn more

This is a general SQL error. This can be caused by query timeouts, resource constraints, unexpected DDL alterations before or during a query, and other database errors. Check your database settings and your query, and try again.

Error details:

ERROR: Query (53460765) cancelled on user’s request

2

Hi Jing,
how much time the data refresh was taken place before it shows the timeout error message?
did you check if there are any error message in the query executed in Redshift?
Also, how big is the data size and number of rows?

3

thank, the capacity went back to normal now.