Uploaded image for project: 'Liquibase Core'
  1. CORE-3382

changelogSchemaName ignored by Maven plugin on Postgres

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects versions: 3.6.2
    • Fix versions: None
    • Components: Maven
    • Environment:

      Ubuntu, Java 8, PostgreSQL 9.6

    • Sprint:

      Description

      Similar to CORE-1878, when I run mvn liquibase:update and I specify changelogSchemaName in my liquibase.properties, it seems that the Maven plugin doesn't take the configuration correctly since I'm getting the following error:

      [INFO] Starting Liquibase at Mon, 11 Feb 2019 15:33:06 EST (version 3.6.2 built at 2018-07-03 11:28:09)
      [INFO] SET SEARCH_PATH TO my_schema
      [INFO] Executing on Database: jdbc:postgresql://localhost:5432/my_db
      [INFO] SELECT COUNT FROM databasechangeloglock
      [INFO] CREATE TABLE databasechangeloglock (ID INTEGER NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP WITHOUT TIME ZONE, LOCKEDBY VARCHAR(255), CONSTRAINT DATABASECHANGELOGLOCK_PKEY PRIMARY KEY (ID))
      [ERROR] Failed to execute goal org.liquibase:liquibase-maven-plugin:3.6.2:update (default-cli) on project my_project: Error setting up or running Liquibase: liquibase.exception.DatabaseException: ERROR: permission denied for schema public
      [ERROR] Position: 14 [Failed SQL: CREATE TABLE databasechangeloglock (ID INTEGER NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP WITHOUT TIME ZONE, LOCKEDBY VARCHAR(255), CONSTRAINT DATABASECHANGELOGLOCK_PKEY PRIMARY KEY (ID))]

      The CREATE TABLE should include the schema name my_schema.databasechangeloglock.

      Unless I missed something.

      Thanks!

        Attachments

          Activity

            People

            • Reporter:
              christian.gendreau Christian Gendreau
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: