search

liquibase / liquibase

Main Liquibase Source
https://www.liquibase.org
Apache License 2.0
4.64k stars 1.84k forks source link

Liquibase-core 4.28.0 (Maven) throws SQL Connection is closed error on Postgres 16.3 #6098

Open vnairr opened 2 months ago

vnairr commented 2 months ago

Search first

Description

When we tried to run our Liquibase setup against Postgres 16.3 version, we got an error: SQL Connection is closed Further we could see, Liquibase stucks at creating databasechangeloglock table. When we tried to manually create this table and then Liquibase was able to run remaining steps.

Used https://mvnrepository.com/artifact/org.liquibase/liquibase-core/4.28.0 for our Spring Boot app to setup SpringLiquibase.

Steps To Reproduce

  1. Create a Spring Boot project and include the dependency https://mvnrepository.com/artifact/org.liquibase/liquibase-core/4.28.0
  2. Create a SpringLiquibase bean as

@ Bean public SpringLiquibase liquibase(final DataSource dataSource) { final SpringLiquibase liquibase = new SpringLiquibase(); liquibase.setChangeLog("classpath:db/changelog/changelog-master.xml"); liquibase.setDataSource(dataSource); return liquibase; }

  1. Spinup a Postgres 16.3 version (we used Azure Flexible DB)
  2. Run the App. Liquibase will start and fail with above mentioned error.

Expected/Desired Behavior

Liquibase should run fine. The same setup was working fine Postgres 13.15

Liquibase Version

https://mvnrepository.com/artifact/org.liquibase/liquibase-core/4.28.0

Database Vendor & Version

Postgres 16.3

Liquibase Integration

Maven

Liquibase Extensions

NA

OS and/or Infrastructure Type/Provider

Linux

Additional Context

No response

Are you willing to submit a PR?

tati-qalified commented 1 month ago

Hi @vnairr, thank you for reporting this issue. Could you provide the error logs / stack trace? Thank you, Tatiana

adarmada commented 1 month ago

Hi @vnairr, thank you for reporting this issue. Could you provide the error logs / stack trace? Thank you, Tatiana

Peer of @vnairr . Here is some additional information plus stack trace of my attempt to do a simple liquibase status check. PostgreSQL version Azure Database for PostgreSQL flexible server Version 16.3.

Here are the privileges of the role I am using on the database I am testing against:

SELECT 
    grantee,
    privilege_type
FROM 
    information_schema.role_table_grants
WHERE 
    table_catalog = 'repro-db';
  grantee  | privilege_type 
-----------+----------------
 repro-role | INSERT
 repro-role | SELECT
 repro-role | UPDATE
 repro-role | DELETE
 repro-role | TRUNCATE
 repro-role | REFERENCES
 repro-role | TRIGGER
 repro-role | INSERT
 repro-role | SELECT
 repro-role | UPDATE
 repro-role | DELETE
 repro-role | TRUNCATE
 repro-role | REFERENCES
 repro-role | TRIGGER
 repro-role | INSERT
 repro-role | SELECT
 repro-role | UPDATE
 repro-role | DELETE
 repro-role | TRUNCATE
 repro-role | REFERENCES
 repro-role | TRIGGER
 repro-role | INSERT
 repro-role | SELECT
 repro-role | UPDATE
 repro-role | DELETE
 repro-role | TRUNCATE
 repro-role | REFERENCES
 repro-role | TRIGGER
 repro-role | INSERT
 repro-role | SELECT
 repro-role | UPDATE
 repro-role | DELETE
 repro-role | TRUNCATE
 repro-role | REFERENCES
 repro-role | TRIGGER
 repro-role | INSERT
 repro-role | SELECT
 repro-role | UPDATE
 repro-role | DELETE
 repro-role | TRUNCATE
 repro-role | REFERENCES
 repro-role | TRIGGER
 repro-role | INSERT
 repro-role | SELECT
 repro-role | UPDATE
 repro-role | DELETE
 repro-role | TRUNCATE
 repro-role | REFERENCES
 repro-role | TRIGGER
(49 rows)

I have the following changelog file:

% cat changelog.xml 
<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
    xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
    xmlns:pro="http://www.liquibase.org/xml/ns/pro"
    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
        http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd
        http://www.liquibase.org/xml/ns/pro http://www.liquibase.org/xml/ns/pro/liquibase-pro-latest.xsd">

    <changeSet id="1" author="ad@armada.ai">
        <createTable tableName="test_table">
            <column name="test_id" type="int">
                <constraints primaryKey="true" nullable="false" />
            </column>
            <column name="test_column" type="int"/>
        </createTable>
    </changeSet>

</databaseChangeLog>

I am trying status command against a database I own. Here's the results with FINE logging level:

% liquibase status --url="jdbc:postgresql://alz-psql-westus3.postgres.database.azure.com:5432/$DB_NAME" --username="$DB_USER" --password="$DB_PW" --changelog-file changelog.xml --log-level=FINE
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for directory /Users/andrewdettmer/liquibase-testing/new-stage-debug
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.searchPath found
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for file /opt/homebrew/opt/liquibase/libexec/internal/lib/liquibase-core.jar
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for directory /opt/homebrew/opt/liquibase/libexec/lib
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for file /opt/homebrew/opt/liquibase/libexec/internal/lib/jaybird.jar
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for file /opt/homebrew/opt/liquibase/libexec/internal/lib/ojdbc8.jar
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for file /opt/homebrew/opt/liquibase/libexec/internal/lib/snakeyaml.jar
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for file /opt/homebrew/opt/liquibase/libexec/internal/lib/snowflake-jdbc.jar
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for file /opt/homebrew/opt/liquibase/libexec/internal/lib/picocli.jar
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for file /opt/homebrew/opt/liquibase/libexec/internal/lib/jaxb-runtime.jar
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for file /opt/homebrew/opt/liquibase/libexec/internal/lib/commons-io.jar
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for file /opt/homebrew/opt/liquibase/libexec/internal/lib/jaxb-api.jar
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for file /opt/homebrew/opt/liquibase/libexec/internal/lib/jaxb-core.jar
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for file /opt/homebrew/opt/liquibase/libexec/internal/lib/hsqldb.jar
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for file /opt/homebrew/opt/liquibase/libexec/internal/lib/mssql-jdbc.jar
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for file /opt/homebrew/opt/liquibase/libexec/internal/lib/h2.jar
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for file /opt/homebrew/opt/liquibase/libexec/internal/lib/mariadb-java-client.jar
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for file /opt/homebrew/opt/liquibase/libexec/internal/lib/liquibase-commercial.jar
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for file /opt/homebrew/opt/liquibase/libexec/internal/lib/commons-lang3.jar
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for file /opt/homebrew/opt/liquibase/libexec/internal/lib/postgresql.jar
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for file /opt/homebrew/opt/liquibase/libexec/internal/lib/sqlite-jdbc.jar
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for file /opt/homebrew/opt/liquibase/libexec/internal/lib/opencsv.jar
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for file /opt/homebrew/opt/liquibase/libexec/internal/lib/commons-text.jar
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for file /opt/homebrew/opt/liquibase/libexec/internal/lib/commons-collections4.jar
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for file /opt/homebrew/opt/liquibase/libexec/internal/lib/jcc.jar
[2024-08-06 17:30:42] FINE [liquibase.resource] Creating resourceAccessor for directory /opt/homebrew/opt/liquibase/libexec/internal/lib
[2024-08-06 17:30:42] FINE [liquibase.resource] Overall search path: 
  - /Users/andrewdettmer/liquibase-testing/new-stage-debug
  - /opt/homebrew/opt/liquibase/libexec/internal/lib/liquibase-core.jar
  - /opt/homebrew/opt/liquibase/libexec/lib
  - /opt/homebrew/opt/liquibase/libexec/internal/lib/jaybird.jar
  - /opt/homebrew/opt/liquibase/libexec/internal/lib/ojdbc8.jar
  - /opt/homebrew/opt/liquibase/libexec/internal/lib/snakeyaml.jar
  - /opt/homebrew/opt/liquibase/libexec/internal/lib/snowflake-jdbc.jar
  - /opt/homebrew/opt/liquibase/libexec/internal/lib/picocli.jar
  - /opt/homebrew/opt/liquibase/libexec/internal/lib/jaxb-runtime.jar
  - /opt/homebrew/opt/liquibase/libexec/internal/lib/commons-io.jar
  - /opt/homebrew/opt/liquibase/libexec/internal/lib/jaxb-api.jar
  - /opt/homebrew/opt/liquibase/libexec/internal/lib/jaxb-core.jar
  - /opt/homebrew/opt/liquibase/libexec/internal/lib/hsqldb.jar
  - /opt/homebrew/opt/liquibase/libexec/internal/lib/mssql-jdbc.jar
  - /opt/homebrew/opt/liquibase/libexec/internal/lib/h2.jar
  - /opt/homebrew/opt/liquibase/libexec/internal/lib/mariadb-java-client.jar
  - /opt/homebrew/opt/liquibase/libexec/internal/lib/liquibase-commercial.jar
  - /opt/homebrew/opt/liquibase/libexec/internal/lib/commons-lang3.jar
  - /opt/homebrew/opt/liquibase/libexec/internal/lib/postgresql.jar
  - /opt/homebrew/opt/liquibase/libexec/internal/lib/sqlite-jdbc.jar
  - /opt/homebrew/opt/liquibase/libexec/internal/lib/opencsv.jar
  - /opt/homebrew/opt/liquibase/libexec/internal/lib/commons-text.jar
  - /opt/homebrew/opt/liquibase/libexec/internal/lib/commons-collections4.jar
  - /opt/homebrew/opt/liquibase/libexec/internal/lib/jcc.jar
  - /opt/homebrew/opt/liquibase/libexec/internal/lib
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.uiService found
[2024-08-06 17:30:42] FINE [liquibase.configuration] Configuration liquibase.uiService is using the default value of CONSOLE
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.mirrorConsoleMessagesToLog found
[2024-08-06 17:30:42] FINE [liquibase.configuration] Configuration liquibase.mirrorConsoleMessagesToLog is using the default value of true
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.shouldRun aka should.run found
[2024-08-06 17:30:42] FINE [liquibase.configuration] Configuration liquibase.shouldRun is using the default value of true
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.showBanner found
[2024-08-06 17:30:42] FINE [liquibase.configuration] Configuration liquibase.showBanner is using the default value of true
####################################################
##   _     _             _ _                      ##
##  | |   (_)           (_) |                     ##
##  | |    _  __ _ _   _ _| |__   __ _ ___  ___   ##
##  | |   | |/ _` | | | | | '_ \ / _` / __|/ _ \  ##
##  | |___| | (_| | |_| | | |_) | (_| \__ \  __/  ##
##  \_____/_|\__, |\__,_|_|_.__/ \__,_|___/\___|  ##
##              | |                               ##
##              |_|                               ##
##                                                ## 
##  Get documentation at docs.liquibase.com       ##
##  Get certified courses at learn.liquibase.com  ## 
##                                                ##
####################################################
Starting Liquibase at 17:30:42 (version 4.28.0 #2272 built at 2024-05-16 19:00+0000)
[2024-08-06 17:30:42] INFO [liquibase.ui] ####################################################
##   _     _             _ _                      ##
##  | |   (_)           (_) |                     ##
##  | |    _  __ _ _   _ _| |__   __ _ ___  ___   ##
##  | |   | |/ _` | | | | | '_ \ / _` / __|/ _ \  ##
##  | |___| | (_| | |_| | | |_) | (_| \__ \  __/  ##
##  \_____/_|\__, |\__,_|_|_.__/ \__,_|___/\___|  ##
##              | |                               ##
##              |_|                               ##
##                                                ## 
##  Get documentation at docs.liquibase.com       ##
##  Get certified courses at learn.liquibase.com  ## 
##                                                ##
####################################################
Starting Liquibase at 17:30:42 (version 4.28.0 #2272 built at 2024-05-16 19:00+0000)
Liquibase Version: 4.28.0
[2024-08-06 17:30:42] INFO [liquibase.ui] Liquibase Version: 4.28.0
Liquibase Open Source 4.28.0 by Liquibase
[2024-08-06 17:30:42] INFO [liquibase.ui] Liquibase Open Source 4.28.0 by Liquibase
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.monitorPerformance found
[2024-08-06 17:30:42] FINE [liquibase.configuration] Configuration liquibase.monitorPerformance is using the default value of false
[2024-08-06 17:30:42] FINE [liquibase.integration] Performance monitoring disabled
[2024-08-06 17:30:42] INFO [liquibase.integration] Starting command execution.
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.outputFile found
[2024-08-06 17:30:42] FINE [liquibase.servicelocator] Loaded liquibase.io.OutputFileHandler instance liquibase.io.StandardOutputFileHandler
[2024-08-06 17:30:42] FINE [liquibase.servicelocator] Loaded liquibase.io.OutputFileHandler instance com.datical.liquibase.ext.io.ProOutputFileHandler
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.strict found
[2024-08-06 17:30:42] FINE [liquibase.configuration] Configuration liquibase.strict is using the default value of false
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.status.changelogFile found
[2024-08-06 17:30:42] FINE [liquibase.configuration] Found 'liquibase.command.changelogFile' configuration of 'changelog.xml'
    command argument '--changelog-file' of 'changelog.xml'
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.status.changelogParameters found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.changelogParameters found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.status.contextFilter aka liquibase.command.status.contexts found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.contextFilter aka liquibase.command.contexts found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.status.database found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.database found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.status.databaseChangelog found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.databaseChangelog found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.status.defaultCatalogName found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.defaultCatalogName found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.status.defaultSchemaName found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.defaultSchemaName found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.status.driver found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.driver found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.status.driverPropertiesFile found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.driverPropertiesFile found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.status.labelFilter aka liquibase.command.status.labels found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.labelFilter aka liquibase.command.labels found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.status.password found
[2024-08-06 17:30:42] FINE [liquibase.configuration] Found 'liquibase.command.password' configuration of '*****'
    command argument '--password' of '*****'
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.status.skipDatabaseStep found
[2024-08-06 17:30:42] FINE [liquibase.configuration] Configuration liquibase.command.status.skipDatabaseStep is using the default value of false
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.skipDatabaseStep found
[2024-08-06 17:30:42] FINE [liquibase.configuration] Configuration liquibase.command.skipDatabaseStep is using the default value of false
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.status.updateNullChecksums found
[2024-08-06 17:30:42] FINE [liquibase.configuration] Configuration liquibase.command.status.updateNullChecksums is using the default value of false
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.updateNullChecksums found
[2024-08-06 17:30:42] FINE [liquibase.configuration] Configuration liquibase.command.updateNullChecksums is using the default value of false
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.status.url found
[2024-08-06 17:30:42] FINE [liquibase.servicelocator] Loaded liquibase.database.jvm.ConnectionPatterns instance liquibase.database.jvm.JdbcConnectionPatterns
[2024-08-06 17:30:42] FINE [liquibase.configuration] Found 'liquibase.command.url' configuration of 'jdbc:postgresql://alz-psql-westus3.postgres.database.azure.com:5432/repro-db'
    command argument '--url' of '*****'
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.status.username found
[2024-08-06 17:30:42] FINE [liquibase.configuration] Found 'liquibase.command.username' configuration of 'repro-role'
    command argument '--username' of 'repro-role'
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.status.verbose found
[2024-08-06 17:30:42] FINE [liquibase.configuration] Configuration liquibase.command.status.verbose is using the default value of true
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.command.verbose found
[2024-08-06 17:30:42] FINE [liquibase.configuration] Configuration liquibase.command.verbose is using the default value of true
[2024-08-06 17:30:42] FINE [liquibase.command] Pipeline for command 'status: liquibase.command.core.helpers.DbUrlConnectionArgumentsCommandStep then liquibase.command.core.helpers.DbUrlConnectionCommandStep then liquibase.command.core.helpers.DatabaseChangelogCommandStep then liquibase.command.core.StatusCommandStep
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.outputFileEncoding found
[2024-08-06 17:30:42] FINE [liquibase.configuration] Configuration liquibase.outputFileEncoding is using the default value of UTF-8
[2024-08-06 17:30:42] FINE [liquibase.command] Writing output with encoding 'UTF-8'
[2024-08-06 17:30:42] FINE [liquibase.command] Executing internal command dbUrlConnectionArguments
[2024-08-06 17:30:42] FINE [liquibase.command] Executing internal command dbUrlConnectionCommandStep
[2024-08-06 17:30:42] FINE [liquibase.configuration] Configuration liquibase.command.status.skipDatabaseStep is using the default value of false
[2024-08-06 17:30:42] FINE [liquibase.configuration] Configuration liquibase.command.skipDatabaseStep is using the default value of false
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.driver found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.liquibaseCatalogName aka liquibase.catalogName found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.liquibaseSchemaName aka liquibase.schemaName found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.databaseClass found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.propertyProviderClass found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.liquibaseTablespaceName aka liquibase.databaseChangeLogTablespaceName aka liquibase.liquibaseTableSpaceName found
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.databaseChangelogLockTableName aka liquibase.databaseChangeLogLockTableName found
[2024-08-06 17:30:42] FINE [liquibase.configuration] Configuration liquibase.databaseChangelogLockTableName is using the default value of DATABASECHANGELOGLOCK
[2024-08-06 17:30:42] FINE [liquibase.configuration] No configuration value for liquibase.databaseChangelogTableName aka liquibase.databaseChangeLogTableName found
[2024-08-06 17:30:42] FINE [liquibase.configuration] Configuration liquibase.databaseChangelogTableName is using the default value of DATABASECHANGELOG
[2024-08-06 17:30:42] FINE [liquibase.database] Properties:
[2024-08-06 17:30:42] FINE [liquibase.database] Key:'password' Value:'**********'
[2024-08-06 17:30:42] FINE [liquibase.database] Key:'user' Value:'repro-role'
[2024-08-06 17:30:42] FINE [liquibase.database] Connecting to the URL:'jdbc:postgresql://alz-psql-westus3.postgres.database.azure.com:5432/repro-db' using driver:'org.postgresql.Driver'
[2024-08-06 17:30:42] FINE [liquibase.servicelocator] Loaded liquibase.database.DatabaseConnection instance liquibase.database.jvm.JdbcConnection
[2024-08-06 17:30:42] FINE [liquibase.servicelocator] Loaded liquibase.database.DatabaseConnection instance com.datical.liquibase.ext.database.jvm.ProJdbcConnection
[2024-08-06 17:30:43] FINE [liquibase.database] Connection has been created
[2024-08-06 17:30:43] FINE [liquibase.database] Connected to repro-role@jdbc:postgresql://alz-psql-westus3.postgres.database.azure.com:5432/repro-db
[2024-08-06 17:30:43] FINE [liquibase.database] Setting auto commit to false from true
[2024-08-06 17:30:43] FINE [liquibase.configuration] No configuration value for liquibase.preserveSchemaCase found
[2024-08-06 17:30:43] FINE [liquibase.configuration] Configuration liquibase.preserveSchemaCase is using the default value of false
[2024-08-06 17:30:43] FINE [liquibase.command] Executing internal command changelogCommandStep
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.executor.Executor instance liquibase.executor.jvm.JdbcExecutor
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.executor.Executor instance liquibase.executor.jvm.SnowflakeJdbcExecutor
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.executor.Executor instance com.datical.liquibase.ext.tools.OracleSqlPlusExecutor
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.executor.Executor instance com.datical.liquibase.ext.tools.MssqlSqlcmdExecutor
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.executor.Executor instance com.datical.liquibase.ext.tools.PsqlExecutor
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddAutoIncrementGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddAutoIncrementGeneratorDB2
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddAutoIncrementGeneratorHsqlH2
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddAutoIncrementGeneratorInformix
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddAutoIncrementGeneratorMySQL
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddAutoIncrementGeneratorSQLite
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddColumnGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddColumnGeneratorDefaultClauseBeforeNotNull
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddColumnGeneratorSQLite
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorDerby
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorInformix
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorMSSQL
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorMySQL
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorOracle
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorPostgres
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorSQLite
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorSybase
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorSybaseASA
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddForeignKeyConstraintGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddPrimaryKeyGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddPrimaryKeyGeneratorInformix
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddUniqueConstraintGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddUniqueConstraintGeneratorInformix
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddUniqueConstraintGeneratorTDS
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AlterSequenceGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.BatchDmlExecutablePreparedStatementGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.ClearDatabaseChangeLogTableGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CommentGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CopyRowsGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateDatabaseChangeLogLockTableGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateDatabaseChangeLogTableGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateDatabaseChangeLogTableGeneratorSybase
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateIndexGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateIndexGeneratorFirebird
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateIndexGeneratorPostgres
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateProcedureGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateSequenceGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateTableGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateTableGeneratorInformix
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateViewGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateViewGeneratorInformix
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DeleteGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropColumnGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropDefaultValueGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropForeignKeyConstraintGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropIndexGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropPrimaryKeyGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropProcedureGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropSequenceGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropTableGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropUniqueConstraintGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropViewGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetNextChangeSetSequenceValueGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorDB2
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorDerby
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorFirebird
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorHsql
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorInformix
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorMSSQL
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorOracle
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorPostgres
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorSybase
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorSybaseASA
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InitializeDatabaseChangeLogLockTableGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertDataChangeGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorDB2
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorH2
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorHsql
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorInformix
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorMSSQL
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorMySQL
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorOracle
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorPostgres
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorSQLite
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorSybaseASA
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertSetGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.LockDatabaseChangeLogGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.MarkChangeSetRanGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.ModifyDataTypeGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RawParameterizedSqlGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RawSqlGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.ReindexGeneratorSQLite
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RemoveChangeSetRanStatusGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RenameColumnGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RenameSequenceGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RenameTableGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RenameViewGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.ReorganizeTableGeneratorDB2
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RuntimeGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.SelectFromDatabaseChangeLogGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.SelectFromDatabaseChangeLogLockGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.SetColumnRemarksGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.SetNullableGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.SetTableRemarksGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.SetViewRemarksGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.StoredProcedureGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.TableIsEmptyGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.TableRowCountGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.TagDatabaseGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.UnlockDatabaseChangeLogGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.UpdateChangeSetChecksumGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.UpdateDataChangeGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.UpdateGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateSequenceGeneratorSnowflake
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropDefaultValueGeneratorSnowflake
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropProcedureGeneratorSnowflake
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorSnowflake
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RenameTableGeneratorSnowflake
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RenameViewGeneratorSnowflake
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.SetColumnRemarksGeneratorSnowflake
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.SetTableRemarksGeneratorSnowflake
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorSnowflake
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.appdba.synonym.change.CreateSynonymGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.appdba.synonym.change.DropSynonymGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.appdba.markunused.change.MarkUnusedGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.function.change.CreateFunctionGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.function.change.DropFunctionGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.checkconstraint.change.EnableCheckConstraintGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.checkconstraint.change.DisableCheckConstraintGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.checkconstraint.change.DropCheckConstraintGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.checkconstraint.change.AddCheckConstraintGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.databasepackage.change.CreatePackageGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.databasepackage.change.CreatePackageBodyGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.databasepackage.change.DropPackageGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.databasepackage.change.DropPackageBodyGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.trigger.change.DropTriggerGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.trigger.change.CreateTriggerGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.trigger.change.DisableTriggerGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.trigger.change.RenameTriggerGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.trigger.change.EnableTriggerGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.sqlgenerator.SelectFromDatabaseChangeLogHistoryGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.sqlgenerator.InsertDatabaseChangeLogHistoryGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.sqlgenerator.CreateDatabaseChangeLogHistoryTableGenerator
[2024-08-06 17:30:44] INFO [liquibase.database] Set default schema name to public
[2024-08-06 17:30:44] FINE [liquibase.configuration] No configuration value for liquibase.supportPropertyEscaping aka enableEscaping found
[2024-08-06 17:30:44] FINE [liquibase.configuration] Configuration liquibase.supportPropertyEscaping is using the default value of false
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.parser.ChangeLogParser instance liquibase.parser.core.formattedsql.FormattedSqlChangeLogParser
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.parser.ChangeLogParser instance liquibase.parser.core.json.JsonChangeLogParser
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.parser.ChangeLogParser instance liquibase.parser.core.sql.SqlChangeLogParser
[2024-08-06 17:30:44] FINE [liquibase.configuration] No configuration value for liquibase.validateXmlChangelogFiles found
[2024-08-06 17:30:44] FINE [liquibase.configuration] Configuration liquibase.validateXmlChangelogFiles is using the default value of true
[2024-08-06 17:30:44] FINE [liquibase.configuration] No configuration value for liquibase.secureParsing found
[2024-08-06 17:30:44] FINE [liquibase.configuration] Configuration liquibase.secureParsing is using the default value of true
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.parser.ChangeLogParser instance liquibase.parser.core.xml.XMLChangeLogSAXParser
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.parser.ChangeLogParser instance liquibase.parser.core.yaml.YamlChangeLogParser
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.parser.ChangeLogParser instance com.datical.liquibase.ext.parser.ProFormattedSqlChangeLogParser
[2024-08-06 17:30:44] FINE [liquibase.parser] Matched file 'changelog.xml' to parser 'XMLChangeLogSAXParser'
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.CustomPreconditionWrapper
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.AndPrecondition
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.ChangeLogPropertyDefinedPrecondition
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.ChangeSetExecutedPrecondition
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.ColumnExistsPrecondition
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.DBMSPrecondition
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.ForeignKeyExistsPrecondition
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.IndexExistsPrecondition
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.NotPrecondition
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.ObjectQuotingStrategyPrecondition
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.OrPrecondition
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.PreconditionContainer
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.PrimaryKeyExistsPrecondition
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.RowCountPrecondition
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.RunningAsPrecondition
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.SequenceExistsPrecondition
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.SqlPrecondition
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.TableExistsPrecondition
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.TableIsEmptyPrecondition
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.UniqueConstraintExistsPrecondition
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.ViewExistsPrecondition
[2024-08-06 17:30:44] FINE [liquibase.parser] Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd'
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.changeset.ChangeSetService instance liquibase.changeset.StandardChangeSetService
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.changeset.ChangeSetService instance com.datical.liquibase.ext.changeset.ProChangeSetService
[2024-08-06 17:30:44] FINE [liquibase.configuration] Configuration liquibase.command.status.updateNullChecksums is using the default value of false
[2024-08-06 17:30:44] FINE [liquibase.configuration] Configuration liquibase.command.updateNullChecksums is using the default value of false
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.changelog.ChangeLogHistoryService instance liquibase.changelog.MockChangeLogHistoryService
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.changelog.ChangeLogHistoryService instance liquibase.changelog.StandardChangeLogHistoryService
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.CatalogSnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.ColumnSnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.ColumnSnapshotGeneratorH2
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.ColumnSnapshotGeneratorInformix
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.ColumnSnapshotGeneratorOracle
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.DataSnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.ForeignKeySnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.IndexSnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.PrimaryKeySnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.SchemaSnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.SequenceSnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.TableSnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.UniqueConstraintSnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.ViewSnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.SchemaSnapshotGeneratorSnowflake
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.SequenceSnapshotGeneratorSnowflake
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.UniqueConstraintSnapshotGeneratorSnowflake
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance com.datical.liquibase.ext.appdba.synonym.SynonymSnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance com.datical.liquibase.ext.storedlogic.checkconstraint.CheckConstraintSnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance com.datical.liquibase.ext.storedlogic.checkconstraint.postgres.PostgresCheckConstraintSnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance com.datical.liquibase.ext.storedlogic.databasepackage.PackageBodySnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance com.datical.liquibase.ext.storedlogic.databasepackage.PackageSnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance com.datical.liquibase.ext.storedlogic.function.FunctionSnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance com.datical.liquibase.ext.storedlogic.function.postgres.EDBPostgresFunctionSnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance com.datical.liquibase.ext.storedlogic.function.postgres.PostgresFunctionSnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance com.datical.liquibase.ext.storedlogic.function.mysql.MySQLFunctionSnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance com.datical.liquibase.ext.storedlogic.storedproc.PostgresStoredProcedureSnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance com.datical.liquibase.ext.storedlogic.storedproc.MySQLStoredProcedureSnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance com.datical.liquibase.ext.storedlogic.storedproc.SnowflakeStoredProcedureSnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance com.datical.liquibase.ext.storedlogic.storedproc.StoredProcedureSnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance com.datical.liquibase.ext.storedlogic.trigger.TriggerSnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.snapshot.SnapshotGenerator instance com.datical.liquibase.ext.storedlogic.trigger.postgres.PostgresTriggerSnapshotGenerator
[2024-08-06 17:30:44] FINE [liquibase.util] Computed checksum for 1722990644249 as 117ae414a936c447cd695e7717ab6c95
[2024-08-06 17:30:44] FINE [liquibase.executor] Create Database Change Log Table
[2024-08-06 17:30:44] INFO [liquibase.changelog] Creating database history table with name: public.databasechangelog
[2024-08-06 17:30:44] FINE [liquibase.configuration] No configuration value for liquibase.sql.alwaysSetFetchSize found
[2024-08-06 17:30:44] FINE [liquibase.configuration] Configuration liquibase.sql.alwaysSetFetchSize is using the default value of true
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.BigIntType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.BlobType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.BooleanType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.CharType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.ClobType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.CurrencyType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.DatabaseFunctionType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.DateTimeType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.DateType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.DecimalType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.DoubleType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.FloatType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.IntType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.MediumIntType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.NCharType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.NVarcharType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.NumberType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.SmallIntType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.TimeType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.TimestampType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.TinyIntType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.UUIDType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.UnknownType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.VarcharType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.XMLType
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.TextDataTypeSnowflake
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.TimestampNTZTypeSnowflake
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.DoubleDataTypeSnowflake
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.BinaryTypeSnowflake
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.ClobTypeSnowflake
[2024-08-06 17:30:44] FINE [liquibase.configuration] No configuration value for liquibase.includeCatalogInSpecification found
[2024-08-06 17:30:44] FINE [liquibase.configuration] Configuration liquibase.includeCatalogInSpecification is using the default value of false
[2024-08-06 17:30:44] FINE [liquibase.configuration] No configuration value for liquibase.sql.logLevel found
[2024-08-06 17:30:44] FINE [liquibase.configuration] Configuration liquibase.sql.logLevel is using the default value of FINE
[2024-08-06 17:30:44] FINE [liquibase.executor] CREATE TABLE public.databasechangelog (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED TIMESTAMP WITHOUT TIME ZONE NOT NULL, ORDEREXECUTED INTEGER NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35), DESCRIPTION VARCHAR(255), COMMENTS VARCHAR(255), TAG VARCHAR(255), LIQUIBASE VARCHAR(20), CONTEXTS VARCHAR(255), LABELS VARCHAR(255), DEPLOYMENT_ID VARCHAR(10))
[2024-08-06 17:30:44] FINE [liquibase.executor] 0 row(s) affected
[2024-08-06 17:30:44] FINE [liquibase.executor] Changelog query completed.
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.lockservice.LockService instance liquibase.lockservice.LockServiceImpl
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.lockservice.LockService instance liquibase.lockservice.MockLockService
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.lockservice.LockService instance liquibase.lockservice.OfflineLockService
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.lockservice.LockService instance liquibase.lockservice.StandardLockService
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.database.LiquibaseTableNames instance liquibase.database.StandardLiquibaseTableNames
[2024-08-06 17:30:44] FINE [liquibase.servicelocator] Loaded liquibase.database.LiquibaseTableNames instance com.datical.liquibase.ext.database.ProLiquibaseTableNames
[2024-08-06 17:30:44] FINE [liquibase.configuration] No configuration value for liquibase.dbclhistory.tableName aka databasechangeloghistory.tableName found
[2024-08-06 17:30:44] FINE [liquibase.configuration] Configuration liquibase.dbclhistory.tableName is using the default value of DATABASECHANGELOGHISTORY
[2024-08-06 17:30:44] FINE [liquibase.configuration] No configuration value for liquibase.sql.showSqlWarnings found
[2024-08-06 17:30:44] FINE [liquibase.configuration] Configuration liquibase.sql.showSqlWarnings is using the default value of true
[2024-08-06 17:30:44] FINE [liquibase.lockservice] Failed to create or initialize the lock table, trying again, iteration 1 of 10
liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.DatabaseException: Error executing SQL SHOW SEARCH_PATH: This connection has been closed.
    at liquibase.lockservice.StandardLockService.isDatabaseChangeLogLockTableCreated(StandardLockService.java:245)
    at liquibase.lockservice.StandardLockService.init(StandardLockService.java:118)
    at liquibase.command.core.helpers.DatabaseChangelogCommandStep.checkLiquibaseTables(DatabaseChangelogCommandStep.java:145)
    at liquibase.command.core.helpers.DatabaseChangelogCommandStep.run(DatabaseChangelogCommandStep.java:91)
    at liquibase.command.CommandScope.execute(CommandScope.java:219)
    at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:51)
    at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:21)
    at picocli.CommandLine.executeUserObject(CommandLine.java:2041)
    at picocli.CommandLine.access$1500(CommandLine.java:148)
    at picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2461)
    at picocli.CommandLine$RunLast.handle(CommandLine.java:2453)
    at picocli.CommandLine$RunLast.handle(CommandLine.java:2415)
    at picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2273)
    at picocli.CommandLine$RunLast.execute(CommandLine.java:2417)
    at picocli.CommandLine.execute(CommandLine.java:2170)
    at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$2(LiquibaseCommandLine.java:387)
    at liquibase.Scope.child(Scope.java:200)
    at liquibase.Scope.child(Scope.java:176)
    at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$3(LiquibaseCommandLine.java:362)
    at liquibase.Scope.child(Scope.java:200)
    at liquibase.Scope.child(Scope.java:176)
    at liquibase.integration.commandline.LiquibaseCommandLine.execute(LiquibaseCommandLine.java:359)
    at liquibase.integration.commandline.LiquibaseCommandLine.main(LiquibaseCommandLine.java:96)
    at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
    at java.base/java.lang.reflect.Method.invoke(Method.java:580)
    at liquibase.integration.commandline.LiquibaseLauncher.main(LiquibaseLauncher.java:116)
Caused by: liquibase.exception.DatabaseException: Error executing SQL SHOW SEARCH_PATH: This connection has been closed.
    at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
    at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:230)
    at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:238)
    at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:246)
    at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:261)
    at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:256)
    at liquibase.database.core.DatabaseUtils.initializeDatabase(DatabaseUtils.java:41)
    at liquibase.database.core.PostgresDatabase.rollback(PostgresDatabase.java:404)
    at liquibase.snapshot.SnapshotGeneratorFactory.has(SnapshotGeneratorFactory.java:117)
    at liquibase.snapshot.SnapshotGeneratorFactory.hasDatabaseChangeLogLockTable(SnapshotGeneratorFactory.java:296)
    at liquibase.lockservice.StandardLockService.isDatabaseChangeLogLockTableCreated(StandardLockService.java:243)
    ... 25 more
Caused by: org.postgresql.util.PSQLException: This connection has been closed.
    at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:1009)
    at org.postgresql.jdbc.PgConnection.createStatement(PgConnection.java:1852)
    at org.postgresql.jdbc.PgConnection.createStatement(PgConnection.java:529)
    at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:77)
    ... 35 more

[2024-08-06 17:30:44] WARNING [liquibase.database] Failed to restore the auto commit to true
[2024-08-06 17:30:44] WARNING [liquibase.command] The database connection could not be closed properly. The following steps might fail.
liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: This connection has been closed.
    at liquibase.database.jvm.JdbcConnection.setAutoCommit(JdbcConnection.java:487)
    at liquibase.database.AbstractJdbcDatabase.close(AbstractJdbcDatabase.java:1129)
    at liquibase.command.core.helpers.AbstractDatabaseConnectionCommandStep.cleanUp(AbstractDatabaseConnectionCommandStep.java:116)
    at liquibase.command.CommandScope.execute(CommandScope.java:242)
    at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:51)
    at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:21)
    at picocli.CommandLine.executeUserObject(CommandLine.java:2041)
    at picocli.CommandLine.access$1500(CommandLine.java:148)
    at picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2461)
    at picocli.CommandLine$RunLast.handle(CommandLine.java:2453)
    at picocli.CommandLine$RunLast.handle(CommandLine.java:2415)
    at picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2273)
    at picocli.CommandLine$RunLast.execute(CommandLine.java:2417)
    at picocli.CommandLine.execute(CommandLine.java:2170)
    at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$2(LiquibaseCommandLine.java:387)
    at liquibase.Scope.child(Scope.java:200)
    at liquibase.Scope.child(Scope.java:176)
    at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$3(LiquibaseCommandLine.java:362)
    at liquibase.Scope.child(Scope.java:200)
    at liquibase.Scope.child(Scope.java:176)
    at liquibase.integration.commandline.LiquibaseCommandLine.execute(LiquibaseCommandLine.java:359)
    at liquibase.integration.commandline.LiquibaseCommandLine.main(LiquibaseCommandLine.java:96)
    at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
    at java.base/java.lang.reflect.Method.invoke(Method.java:580)
    at liquibase.integration.commandline.LiquibaseLauncher.main(LiquibaseLauncher.java:116)
Caused by: org.postgresql.util.PSQLException: This connection has been closed.
    at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:1009)
    at org.postgresql.jdbc.PgConnection.setAutoCommit(PgConnection.java:938)
    at liquibase.database.jvm.JdbcConnection.setAutoCommit(JdbcConnection.java:485)
    ... 24 more

[2024-08-06 17:30:44] INFO [liquibase.command] Logging exception.
ERROR: Exception Details
[2024-08-06 17:30:44] INFO [liquibase.ui] ERROR: Exception Details
ERROR: Exception Primary Class:  PSQLException
[2024-08-06 17:30:44] INFO [liquibase.ui] ERROR: Exception Primary Class:  PSQLException
ERROR: Exception Primary Reason:  This connection has been closed.
[2024-08-06 17:30:44] INFO [liquibase.ui] ERROR: Exception Primary Reason:  This connection has been closed.
ERROR: Exception Primary Source:  postgresql
[2024-08-06 17:30:44] INFO [liquibase.ui] ERROR: Exception Primary Source:  postgresql
[2024-08-06 17:30:44] INFO [liquibase.command] Command execution complete
[2024-08-06 17:30:44] SEVERE [liquibase.integration] Error executing SQL SHOW SEARCH_PATH: This connection has been closed.
liquibase.exception.CommandExecutionException: liquibase.exception.DatabaseException: Error executing SQL SHOW SEARCH_PATH: This connection has been closed.
    at liquibase.command.CommandScope.execute(CommandScope.java:257)
    at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:51)
    at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:21)
    at picocli.CommandLine.executeUserObject(CommandLine.java:2041)
    at picocli.CommandLine.access$1500(CommandLine.java:148)
    at picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2461)
    at picocli.CommandLine$RunLast.handle(CommandLine.java:2453)
    at picocli.CommandLine$RunLast.handle(CommandLine.java:2415)
    at picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2273)
    at picocli.CommandLine$RunLast.execute(CommandLine.java:2417)
    at picocli.CommandLine.execute(CommandLine.java:2170)
    at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$2(LiquibaseCommandLine.java:387)
    at liquibase.Scope.child(Scope.java:200)
    at liquibase.Scope.child(Scope.java:176)
    at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$3(LiquibaseCommandLine.java:362)
    at liquibase.Scope.child(Scope.java:200)
    at liquibase.Scope.child(Scope.java:176)
    at liquibase.integration.commandline.LiquibaseCommandLine.execute(LiquibaseCommandLine.java:359)
    at liquibase.integration.commandline.LiquibaseCommandLine.main(LiquibaseCommandLine.java:96)
    at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
    at java.base/java.lang.reflect.Method.invoke(Method.java:580)
    at liquibase.integration.commandline.LiquibaseLauncher.main(LiquibaseLauncher.java:116)
Caused by: liquibase.exception.DatabaseException: Error executing SQL SHOW SEARCH_PATH: This connection has been closed.
    at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
    at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:230)
    at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:238)
    at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:246)
    at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:261)
    at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:256)
    at liquibase.database.core.DatabaseUtils.initializeDatabase(DatabaseUtils.java:41)
    at liquibase.database.core.PostgresDatabase.rollback(PostgresDatabase.java:404)
    at liquibase.lockservice.StandardLockService.init(StandardLockService.java:155)
    at liquibase.command.core.helpers.DatabaseChangelogCommandStep.checkLiquibaseTables(DatabaseChangelogCommandStep.java:145)
    at liquibase.command.core.helpers.DatabaseChangelogCommandStep.run(DatabaseChangelogCommandStep.java:91)
    at liquibase.command.CommandScope.execute(CommandScope.java:219)
    ... 21 more
Caused by: org.postgresql.util.PSQLException: This connection has been closed.
    at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:1009)
    at org.postgresql.jdbc.PgConnection.createStatement(PgConnection.java:1852)
    at org.postgresql.jdbc.PgConnection.createStatement(PgConnection.java:529)
    at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:77)
    ... 32 more

Unexpected error running Liquibase: Error executing SQL SHOW SEARCH_PATH: This connection has been closed.

liquibase.exception.CommandExecutionException: liquibase.exception.DatabaseException: Error executing SQL SHOW SEARCH_PATH: This connection has been closed.
    at liquibase.command.CommandScope.execute(CommandScope.java:257)
    at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:51)
    at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:21)
    at picocli.CommandLine.executeUserObject(CommandLine.java:2041)
    at picocli.CommandLine.access$1500(CommandLine.java:148)
    at picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2461)
    at picocli.CommandLine$RunLast.handle(CommandLine.java:2453)
    at picocli.CommandLine$RunLast.handle(CommandLine.java:2415)
    at picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2273)
    at picocli.CommandLine$RunLast.execute(CommandLine.java:2417)
    at picocli.CommandLine.execute(CommandLine.java:2170)
    at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$2(LiquibaseCommandLine.java:387)
    at liquibase.Scope.child(Scope.java:200)
    at liquibase.Scope.child(Scope.java:176)
    at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$3(LiquibaseCommandLine.java:362)
    at liquibase.Scope.child(Scope.java:200)
    at liquibase.Scope.child(Scope.java:176)
    at liquibase.integration.commandline.LiquibaseCommandLine.execute(LiquibaseCommandLine.java:359)
    at liquibase.integration.commandline.LiquibaseCommandLine.main(LiquibaseCommandLine.java:96)
    at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
    at java.base/java.lang.reflect.Method.invoke(Method.java:580)
    at liquibase.integration.commandline.LiquibaseLauncher.main(LiquibaseLauncher.java:116)
Caused by: liquibase.exception.DatabaseException: Error executing SQL SHOW SEARCH_PATH: This connection has been closed.
    at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
    at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:230)
    at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:238)
    at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:246)
    at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:261)
    at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:256)
    at liquibase.database.core.DatabaseUtils.initializeDatabase(DatabaseUtils.java:41)
    at liquibase.database.core.PostgresDatabase.rollback(PostgresDatabase.java:404)
    at liquibase.lockservice.StandardLockService.init(StandardLockService.java:155)
    at liquibase.command.core.helpers.DatabaseChangelogCommandStep.checkLiquibaseTables(DatabaseChangelogCommandStep.java:145)
    at liquibase.command.core.helpers.DatabaseChangelogCommandStep.run(DatabaseChangelogCommandStep.java:91)
    at liquibase.command.CommandScope.execute(CommandScope.java:219)
    ... 21 more
Caused by: org.postgresql.util.PSQLException: This connection has been closed.
    at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:1009)
    at org.postgresql.jdbc.PgConnection.createStatement(PgConnection.java:1852)
    at org.postgresql.jdbc.PgConnection.createStatement(PgConnection.java:529)
    at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:77)
    ... 32 more

As you can see, able to create the databasechangelog table, but some error with the SQL SHOW SEARCH_PATH when trying to create the databasechangeloglock table.

I believe with the same role & privileges I am able to manually construct the databasechangeloglock table. Our Spring projects do not have trouble initializing when that table is manually created for them (but this is not ideal for our deployment process)

tati-qalified commented 1 month ago

Hi @adarmada, thank you for your response. I can see from the logs that the execution (from beginning to failure) takes around two seconds, so I think we can rule out a timeout problem.

Would you be able to test the following scenario and let me know what happens?

With the databasechangelog table created by Liquibase, and the databasechangeloglock table created manually, run liquibase status again. Does it fail?

adarmada commented 1 month ago

Hi @adarmada, thank you for your response. I can see from the logs that the execution (from beginning to failure) takes around two seconds, so I think we can rule out a timeout problem.

Would you be able to test the following scenario and let me know what happens?

With the databasechangelog table created by Liquibase, and the databasechangeloglock table created manually, run liquibase status again. Does it fail?

Hi Tatiana. Yes I can confirm that after manually creating the databasechangeloglock table, liquibase status command succeeds. I was able to create the table using the same role as described in my previous comment

tati-qalified commented 1 month ago

@vnairr I noticed that, right before the exception message, the logs show this line: [2024-08-06 17:30:44] FINE [liquibase.lockservice] Failed to create or initialize the lock table, trying again, iteration 1 of 10. Does your environment have a restriction on the amount of attempts allowed for the same operation?

Apart from that, could you update to the latest Liquibase version 4.29.1 and try again?

Let me know how it goes. Thank you, Tatiana