1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
0
Hello,
In this context, to check whether the error is indeed due to MV being refreshed at the time of the query, you can co-relate the timings that you are facing this error with the information from the system table SVL_MV_REFRESH_STATUS. The SVL_MV_REFRESH_STATUS view contains a row for the refresh activity of materialized views.
[+] https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_MV_REFRESH_STATUS.html
Sample query to view the refresh status of materialized views -
select * from svl_mv_refresh_status;
You can compare the starttime, endtime columns with the time of the occurrence of the error.
That being said, if you would like resource based troubleshooting, please raise a support case with AWS for further information. If a support case has already been created please be assured that we will get back to you and assist you in the best way possible.
répondu il y a un an
Contenus pertinents
- demandé il y a un an
- demandé il y a 2 mois
- demandé il y a 6 mois
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 2 ans