SQL workbench Error while connecting to Redshift
I'm using SQL Workbench, and by default autocommit is off. I run the SQL command below to turn on autocommit, otherwise the transaction will not be committed to database. Just for your reference.
SET autocommit ON
Set Autocommit to TRUE in SQL Workbench connection window. See attached image:
Unless you start one explicitly, every Redshift query you make is wrapped in a transaction: http://docs.aws.amazon.com/redshift/latest/dg/r_BEGIN.html
To fix this issue when it arises again, enter ROLLBACK; on a line by itself and run it. This should bring your connection back to working order.