Liquibase Redshift v4.30 - Error executing SQL SELECT * FROM public.databasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC: ERROR: current transaction is aborted, commands ignored until end of transaction block

General Discussion
1

We’re getting the below issue on Liquibase v4.30 with Redshift. Same changelogs work when using v4.27 before. extensions are also placed correctly.

  • /usr/bin/internal/lib/liquibase-redshift-4.30.0.jar
  • /usr/bin/internal/lib/redshift-jdbc42-2.1.0.30.jar
Starting Liquibase at 18:34:36 using Java 21.0.5 (version 4.30.0 #4943 built at 2024-10-31 17:00+0000)
[2024-12-18 18:34:38] INFO [liquibase.ui] ERROR: Exception Details
ERROR: Exception Primary Class:  RedshiftException
[2024-12-18 18:34:38] INFO [liquibase.ui] ERROR: Exception Primary Class:  RedshiftException
ERROR: Exception Primary Reason:  ERROR: current transaction is aborted, commands ignored until end of transaction block
[2024-12-18 18:34:38] INFO [liquibase.ui] ERROR: Exception Primary Reason:  ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: Exception Primary Source:  Redshift 8.0.2
[2024-12-18 18:34:38] INFO [liquibase.ui] ERROR: Exception Primary Source:  Redshift 8.0.2