Liquibase failing to create a table on redshift from ADO pipelines

General Discussion
1

Hi ,
We are in process of managing the DB deployments using Liquibase and as in the process we are trying to test our code for a simple table creation . Although liquibase updateSQL stage is passed in the pipeline its getting failed dering table creation with following error ::

2023-08-16T17:38:43.1348603Z [2023-08-16 17:38:43] FINE [liquibase.executor] CREATE TABLE liquibase.DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED datetime, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))
2023-08-16T17:38:43.1413877Z [2023-08-16 17:38:43] FINE [liquibase.lockservice] Failed to create or initialize the lock table, trying again, iteration 1 of 10
2023-08-16T17:38:43.1415586Z liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: ERROR: current transaction is aborted, commands ignored until end of transaction block [Failed SQL: (0) CREATE TABLE liquibase.DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED datetime, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))]

Could someone help me in resolving this . If you need more info please feel free to ask i can provide as much s i can .

2

I’m not familiar with Redshift, but the error you are getting is related to Liquibase creating it’s tracking table (liquibase.DATABASECHANGELOGLOCK). Does the “liquibase” schema (or user) have the ability to create this table, and insert a row into it? I would start there.