Solved: ERROR: current transaction is aborted – Redshift

Problem:-

[Amazon](500310) Invalid operation: current transaction is aborted, commands ignored until end of transaction block;

Solution:-

If you are getting the above error while you are connected to Redshift, ensure that you have checked the “Autocommit” box below the “Password” box in SQL Workbench/J connection window. (refer image below)

Enjoy the gift of learning! Find your next course for as low as $11.99

Once you check the “Autocommit” box try connecting to the Redshift cluster again.

 

One Reply to “Solved: ERROR: current transaction is aborted – Redshift”

  1. Hi! I’m at work browsing your blog from my new iphone! Just wanted to say I love reading through your blog and look forward to all your posts! Carry on the superb work!

Leave a Reply

Your email address will not be published. Required fields are marked *