ERROR: current transaction is aborted, commands ignored until end of transaction block --- export data from Aqua studio

Question

I am trying to export one table from Aquastudio into CSV file. The table has approximately 4.4 million rows. When I am trying to use the export window function in the aqua studio, I am facing the following error:

Error: ERROR: current transaction is aborted, commands ignored until end of transaction block

I am not understanding what the problem is. I read few articles regarding this error and found that this is happening due to some error in the last postgreSQL command. I did not use any SQL commands for this export and I dont know how to debug this. I am also unable to view the log files.

Answer 1

Use rollback to cancel the previous query. After that, you will be able to execute your current query.

Answer 2

You probably shouldn't be exporting millions of rows through a JDBC/ODBC connection, especially for Redshift.

For Redshift, please use the UNLOAD command documented here. You'll have to UNLOAD the file to S3 and download it from there.

For Postgres, use COPY TO as documented here.