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)

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

1 comment:

  1. Hello,

    I had this issue. While I was expecting an error like "SQL Error [500310] [42703]: [Amazon](500310) Invalid operation: column "<>" does not exist in...", Sql Workbench/J was reporting "[Amazon](500310) Invalid operation: current transaction is aborted"

    Setting "Auto Commit" to ON solved my issue. Thanks.

    Though I am not sure why the driver looks at a parameter related to commit, for running a "Select".

    Thanks.

    ReplyDelete