I did not find other queries that conflict with this conflict.
I tried:
>Use AWS charts/indicators in the online console.
>View STL_TR_CONFLICT
> STL_QUERY to select the query that runs while I fail.
p>
None of these options help me understand the problem. I found that some queries are running at the same time, but they are not using the same table.
Restarting the query after a few minutes works fine.
p>
< p>> drop / create my_schema.my_table as …> Grant select option on all tables in schema my_schema<-this one failed
I encountered this error: Unable to complete due to conflicts with concurrent transactions.
I did not find other queries that conflict with this conflict.
I tried:
> Use AWS charts/metrics in the online console.
>View STL_TR_CONFLICT
> STL_QUERY select the query that runs while I fail.
None of these options help me understand the problem. I found Some queries are running at the same time, but they are not using the same table.
Restarting the query after a few minutes worked fine.
I I found that I encountered this problem when the following transactions were running at the same time:
> drop / create my_schema.my_table as …> Grant the select option on all tables in the schema my_schema<-this one failed