Amazon-Redshift – Redshift: Unable to complete due to concurrent transactions

I encountered this error: Unable to complete due to conflict with concurrent transaction.

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>

I found that I encountered this problem when the following transactions were running at the same time:

< 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

WordPress database error: [Table 'yf99682.wp_s6mz6tyggq_comments' doesn't exist]
SELECT SQL_CALC_FOUND_ROWS wp_s6mz6tyggq_comments.comment_ID FROM wp_s6mz6tyggq_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 1870 ORDER BY wp_s6mz6tyggq_comments.comment_date_gmt ASC, wp_s6mz6tyggq_comments.comment_ID ASC

Leave a Comment

Your email address will not be published.