First time configuration for Liquibase Redshift
Attempting to issue ‘liquibase status’ I encounter the below error.
Summary of the liquibase.properties file:# Type of database
driver: com.amazon.redshift.jdbc.Driver
conn details
url: yyy
username: yyy
password: yyy
liquibase details
classpath: redshift-jdbc42-2.1.0.14.jar
changeLogFile=rsDbPermissionsChangelog.sql
Actual error:
####################################################
_ _ _ _
| | () () |
| | _ __ _ _ _ | |_ __ _ ___ ___
| | | |/ _ | | | | | '_ \ / _
/ __|/ _ \
| || | (| | || | | |) | (| _ \ __/
_/|_, |_,||./ _,|/__|
| |
|_|
Get documentation at docs.liquibase.com
Get certified courses at learn.liquibase.com
####################################################
Starting Liquibase at 17:35:52 (version 4.23.1 #12042 built at 2023-08-10 13:48+0000)
Liquibase Version: 4.23.1
Liquibase Open Source 4.23.1 by Liquibase
Unexpected error running Liquibase: ERROR: current transaction is aborted, commands ignored until end of transaction block
- Caused by: ERROR: syntax error at end of input
Position: 20
The command is a simple create role, and works from dbeaver / command line.
Also to add I have the following jar files in the liquibase lib directory:
liquibase-redshift-4.22.0
redshift-jdbc42-2.1.0.14
The changelog file is a .sql file issuing a create role xxx; command
Any advice / suggestions very welcome.