V4.0.0 genChangeLog diff history commands fail

General Discussion
1

Hi,
I started to study the product.
The update and rollback commands work well, but I have some problems with :

  • genChangeLog
  • all diff commands
  • history.
    All these commands fail with :
    “java.lang.NullPointerException
    at com.datical.liquibase.ext.command.RollbackOneChangeSetCommand.getPriority(Unknown Source)”

My database : Postgres 15 (org.postgresql.Driver, postgresql-42.2.16.jar)
OS: Windows 10
JDK : 14.0.2
Liquibase : Community 4.0.0

My liquibase.properties file :
changeLogFile: dbchangelog.xml
url: jdbc:postgresql://localhost:5432/tle_01
username: postgres
password: MyPwd
defaultSchemaName: public
driver: org.postgresql.Driver
classpath: postgresql-42.2.16.jar
referenceUrl: jdbc:postgresql://localhost:5432/tle
referenceUsername: postgres
referencePassword: MyPwd
referenceDefaultSchemaName: public
referenceDriver: org.postgresql.Driver

Actions :

  1. create 2 databases tle_01 (test) and tle (target)
  2. liquibase update -> for tle_01, from my dbchangelog.xml -> it runs well
  3. liquibase --changeLogFile=dbchangelog_gen.sql --logLevel=debug generateChangeLog -> it fails

Thank you in advance for your assistance

BR

2

Hi @msics!

Welcome, sorry you are having issues. Would you please post the exact error? I am guessing the changelog file format naming is wrong and should be *.postgresql.sql or similar.

But that is just a wild guess w/o seeing the exact error output (thanks for including your command ran and contents of your properties file!).

-Ronak

3

Hi
for : liquibase --changeLogFile=dbchangelog.postgresql.sql --logLevel=debug generateChangeLog
here is the first part of output

D:_projets\SYSAT\LiquibasePostgreSql>liquibase --changeLogFile=dbchangelog.postgresql.sql --logLevel=debug generateChangeLog
[2020-09-30 18:17:21] INFO [liquibase.servicelocator] Cannot load service: liquibase.license.LicenseService: Provider liquibase.pro.license.keymgr.DaticalTrueLicenseService could not be instantiated
Starting Liquibase at 18:17:21 (version 4.0.0 #19 built at 2020-07-13 19:45+0000)
[2020-09-30 18:17:21] FINE [liquibase.integration] Adding ‘file:/D:/_projets/SYSAT/LiquibasePostgreSql/postgresql-42.2.16.jar’ to the Java classpath.
[2020-09-30 18:17:21] FINE [liquibase.resource] Adding path D:_projets\SYSAT\LiquibasePostgreSql. to resourceAccessor liquibase.resource.FileSystemResourceAccessor
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.DB2Database
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.Db2zDatabase
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.DerbyDatabase
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.Firebird3Database
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.FirebirdDatabase
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.H2Database
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.HsqlDatabase
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.InformixDatabase
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.Ingres9Database
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.MSSQLDatabase
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.MariaDBDatabase
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.MockDatabase
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.MySQLDatabase
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.OracleDatabase
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.PostgresDatabase
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.SQLiteDatabase
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.SybaseASADatabase
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.SybaseDatabase
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.UnsupportedDatabase
[2020-09-30 18:17:21] FINE [liquibase.database] Properties:
[2020-09-30 18:17:21] FINE [liquibase.database] Key:‘password’ Value:’**********’
[2020-09-30 18:17:21] FINE [liquibase.database] Key:‘user’ Value:‘postgres’
[2020-09-30 18:17:21] FINE [liquibase.database] Connecting to the URL:‘jdbc:postgresql://localhost:5432/tle_01’ using driver:‘org.postgresql.Driver’
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.database.DatabaseConnection instance liquibase.database.jvm.JdbcConnection
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.database.DatabaseConnection instance com.datical.liquibase.ext.database.jvm.ProJdbcConnection
[2020-09-30 18:17:21] FINE [org.postgresql.Driver loadDefaultProperties] Loading driver configuration via classloader java.net.URLClassLoader@64f6106c
[2020-09-30 18:17:21] FINE [org.postgresql.Driver connect] Connecting with URL: jdbc:postgresql://localhost:5432/tle_01
[2020-09-30 18:17:21] FINE [org.postgresql.jdbc.PgConnection ] PostgreSQL JDBC Driver 42.2.16
[2020-09-30 18:17:21] FINE [org.postgresql.jdbc.PgConnection setDefaultFetchSize] setDefaultFetchSize = 0
[2020-09-30 18:17:21] FINE [org.postgresql.jdbc.PgConnection setPrepareThreshold] setPrepareThreshold = 5
[2020-09-30 18:17:21] FINE [org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl] Trying to establish a protocol version 3 connection to localhost:5432
[2020-09-30 18:17:21] FINE [org.postgresql.core.v3.ConnectionFactoryImpl tryConnect] Receive Buffer Size is 65?536
[2020-09-30 18:17:21] FINE [org.postgresql.core.v3.ConnectionFactoryImpl tryConnect] Send Buffer Size is 65?536
[2020-09-30 18:17:21] FINE [liquibase.database] Connection has been created
[2020-09-30 18:17:21] FINE [liquibase.database] Connected to postgres@jdbc:postgresql://localhost:5432/tle_01
[2020-09-30 18:17:21] FINE [liquibase.database] Setting auto commit to false from true
[2020-09-30 18:17:21] FINE [org.postgresql.jdbc.PgConnection setAutoCommit] setAutoCommit = false
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.executor.Executor instance liquibase.executor.jvm.JdbcExecutor
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.executor.Executor instance com.datical.liquibase.ext.OracleSqlPlusExecutor
[2020-09-30 18:17:21] FINE [liquibase.executor] Executing with the ‘jdbc’ executor
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddAutoIncrementGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddAutoIncrementGeneratorDB2
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddAutoIncrementGeneratorHsqlH2
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddAutoIncrementGeneratorInformix
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddAutoIncrementGeneratorMySQL
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddAutoIncrementGeneratorSQLite
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddColumnGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddColumnGeneratorDefaultClauseBeforeNotNull
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddColumnGeneratorSQLite
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorDerby
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorInformix
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorMSSQL
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorMySQL
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorOracle
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorPostgres
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorSQLite
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorSybase
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorSybaseASA
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddForeignKeyConstraintGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddPrimaryKeyGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddPrimaryKeyGeneratorInformix
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddUniqueConstraintGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddUniqueConstraintGeneratorInformix
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddUniqueConstraintGeneratorTDS
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AlterSequenceGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.BatchDmlExecutablePreparedStatementGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.ClearDatabaseChangeLogTableGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CommentGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CopyRowsGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateDatabaseChangeLogLockTableGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateDatabaseChangeLogTableGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateDatabaseChangeLogTableGeneratorSybase
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateIndexGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateIndexGeneratorFirebird
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateIndexGeneratorPostgres
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateProcedureGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateSequenceGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateTableGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateTableGeneratorInformix
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateViewGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateViewGeneratorInformix
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DeleteGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropColumnGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropDefaultValueGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropForeignKeyConstraintGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropIndexGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropPrimaryKeyGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropProcedureGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropSequenceGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropTableGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropUniqueConstraintGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropViewGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetNextChangeSetSequenceValueGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorDB2
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorDerby
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorFirebird
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorHsql
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorInformix
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorMSSQL
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorOracle
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorPostgres
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorSybase
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorSybaseASA
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InitializeDatabaseChangeLogLockTableGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertDataChangeGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorDB2
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorH2
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorHsql
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorInformix
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorMSSQL
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorMySQL
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorOracle
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorPostgres
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorSQLite
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorSybaseASA
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertSetGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.LockDatabaseChangeLogGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.MarkChangeSetRanGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.ModifyDataTypeGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RawSqlGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.ReindexGeneratorSQLite
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RemoveChangeSetRanStatusGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RenameColumnGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RenameSequenceGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RenameTableGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RenameViewGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.ReorganizeTableGeneratorDB2
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RuntimeGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.SelectFromDatabaseChangeLogGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.SelectFromDatabaseChangeLogLockGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.SetColumnRemarksGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.SetNullableGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.SetTableRemarksGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.StoredProcedureGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.TableRowCountGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.TagDatabaseGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.UnlockDatabaseChangeLogGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.UpdateChangeSetChecksumGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.UpdateDataChangeGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.UpdateGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.appdba.markunused.change.MarkUnusedGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.appdba.synonym.change.CreateSynonymGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.appdba.synonym.change.DropSynonymGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.checkconstraint.change.AddCheckConstraintGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.checkconstraint.change.DisableCheckConstraintGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.checkconstraint.change.DropCheckConstraintGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.checkconstraint.change.EnableCheckConstraintGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.databasepackage.change.CreatePackageBodyGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.databasepackage.change.CreatePackageGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.databasepackage.change.DropPackageBodyGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.databasepackage.change.DropPackageGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.function.change.CreateFunctionGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.function.change.DropFunctionGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.trigger.change.CreateTriggerGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.trigger.change.DisableTriggerGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.trigger.change.DropTriggerGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.trigger.change.EnableTriggerGenerator
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.trigger.change.RenameTriggerGenerator
[2020-09-30 18:17:21] FINE [liquibase.executor] 0 row(s) affected
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.structure.DatabaseObject instance liquibase.structure.core.Catalog
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.structure.DatabaseObject instance liquibase.structure.core.Column
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.structure.DatabaseObject instance liquibase.structure.core.Data
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.structure.DatabaseObject instance liquibase.structure.core.ForeignKey
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.structure.DatabaseObject instance liquibase.structure.core.Index
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.structure.DatabaseObject instance liquibase.structure.core.PrimaryKey
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.structure.DatabaseObject instance liquibase.structure.core.Schema
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.structure.DatabaseObject instance liquibase.structure.core.Sequence
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.structure.DatabaseObject instance liquibase.structure.core.StoredProcedure
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.structure.DatabaseObject instance liquibase.structure.core.Table
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.structure.DatabaseObject instance liquibase.structure.core.UniqueConstraint
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.structure.DatabaseObject instance liquibase.structure.core.View
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.structure.DatabaseObject instance com.datical.liquibase.ext.appdba.synonym.Synonym
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.structure.DatabaseObject instance com.datical.liquibase.ext.storedlogic.checkconstraint.CheckConstraint
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.structure.DatabaseObject instance com.datical.liquibase.ext.storedlogic.databasepackage.DatabasePackage
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.structure.DatabaseObject instance com.datical.liquibase.ext.storedlogic.databasepackage.DatabasePackageBody
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.structure.DatabaseObject instance com.datical.liquibase.ext.storedlogic.function.Function
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.structure.DatabaseObject instance com.datical.liquibase.ext.storedlogic.trigger.Trigger
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.command.LiquibaseCommand instance liquibase.command.core.DiffCommand
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.command.LiquibaseCommand instance liquibase.command.core.DiffToChangeLogCommand
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.command.LiquibaseCommand instance liquibase.command.core.DropAllCommand
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.command.LiquibaseCommand instance liquibase.command.core.ExecuteSqlCommand
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.command.LiquibaseCommand instance liquibase.command.core.GenerateChangeLogCommand
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.command.LiquibaseCommand instance liquibase.command.core.HistoryCommand
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.command.LiquibaseCommand instance liquibase.command.core.SnapshotCommand
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.command.LiquibaseCommand instance liquibase.sdk.convert.ConvertCommand
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.command.LiquibaseCommand instance com.datical.liquibase.ext.command.FormattedDiffCommand
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.command.LiquibaseCommand instance com.datical.liquibase.ext.command.RollbackOneChangeSetCommand
[2020-09-30 18:17:21] FINE [liquibase.servicelocator] Loaded liquibase.command.LiquibaseCommand instance com.datical.liquibase.ext.command.RollbackOneUpdateCommand
[2020-09-30 18:17:21] FINE [liquibase.executor] Executing with the ‘jdbc’ executor
[2020-09-30 18:17:21] FINE [liquibase.executor] 0 row(s) affected
[2020-09-30 18:17:21] FINE [org.postgresql.jdbc.PgConnection setAutoCommit] setAutoCommit = true

BR

4

Hi
for : liquibase --changeLogFile=dbchangelog.postgresql.sql --logLevel=debug generateChangeLog
here is the next part of output (contains error msg)

Unexpected error running Liquibase: Unknown reason
For more information, please use the --logLevel flag
[2020-09-30 18:17:21] SEVERE [liquibase.integration] Unexpected error running Liquibase: Unknown reason
java.lang.NullPointerException
at com.datical.liquibase.ext.command.RollbackOneChangeSetCommand.getPriority(Unknown Source)
at liquibase.command.CommandFactory$1.compare(CommandFactory.java:49)
at liquibase.command.CommandFactory$1.compare(CommandFactory.java:46)
at java.base/java.util.TimSort.binarySort(TimSort.java:296)
at java.base/java.util.TimSort.sort(TimSort.java:221)
at java.base/java.util.Arrays.sort(Arrays.java:1306)
at java.base/java.util.ArrayList.sort(ArrayList.java:1721)
at java.base/java.util.Collections.sort(Collections.java:179)
at liquibase.command.CommandFactory.getCommand(CommandFactory.java:55)
at liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:233)
at liquibase.integration.commandline.Main.doMigration(Main.java:1359)
at liquibase.integration.commandline.Main$1.lambda$run$0(Main.java:316)
at liquibase.Scope.lambda$child$0(Scope.java:159)
at liquibase.Scope.child(Scope.java:170)
at liquibase.Scope.child(Scope.java:158)
at liquibase.Scope.child(Scope.java:137)
at liquibase.Scope.child(Scope.java:183)
at liquibase.Scope.child(Scope.java:187)
at liquibase.integration.commandline.Main$1.run(Main.java:315)
at liquibase.integration.commandline.Main$1.run(Main.java:166)
at liquibase.Scope.child(Scope.java:170)
at liquibase.Scope.child(Scope.java:144)
at liquibase.integration.commandline.Main.run(Main.java:166)
at liquibase.integration.commandline.Main.main(Main.java:145)

BR

5

I don’t get an error when I run that command but I am on a Mac, and using java 8.
What does liquibase history command output?

6

What does liquibase history command output?

it’s exactly the same error : RollbackOneChangeSetCommand.getPriority
the output starts with :
D:_projets\SYSAT\LiquibasePostgreSql>liquibase --logLevel=debug history
[2020-09-29 16:06:53] INFO [liquibase.servicelocator] Cannot load service: liquibase.license.LicenseService: Provider liquibase.pro.license.keymgr.DaticalTrueLicenseService could not be instantiated
Starting Liquibase at 16:06:53 (version 4.0.0 #19 built at 2020-07-13 19:45+0000)
[2020-09-29 16:06:53] FINE [liquibase.integration] Adding ‘file:/D:/_projets/SYSAT/LiquibasePostgreSql/postgresql-42.2.16.jar’ to the Java classpath.
[2020-09-29 16:06:53] FINE [liquibase.resource] Adding path D:_projets\SYSAT\LiquibasePostgreSql. to resourceAccessor liquibase.resource.FileSystemResourceAccessor
[2020-09-29 16:06:53] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.DB2Database

then all is “FINE” … and it ends with :

[2020-09-29 16:06:53] FINE [liquibase.servicelocator] Loaded liquibase.command.LiquibaseCommand instance com.datical.liquibase.ext.command.RollbackOneUpdateCommand
[2020-09-29 16:06:53] FINE [liquibase.executor] Executing with the ‘jdbc’ executor
[2020-09-29 16:06:53] FINE [liquibase.executor] 0 row(s) affected
[2020-09-29 16:06:53] FINE [org.postgresql.jdbc.PgConnection setAutoCommit] setAutoCommit = true
Unexpected error running Liquibase: Unknown reason
For more information, please use the --logLevel flag
[2020-09-29 16:06:53] SEVERE [liquibase.integration] Unexpected error running Liquibase: Unknown reason
java.lang.NullPointerException
at com.datical.liquibase.ext.command.RollbackOneChangeSetCommand.getPriority(Unknown Source)
at liquibase.command.CommandFactory$1.compare(CommandFactory.java:49)
at liquibase.command.CommandFactory$1.compare(CommandFactory.java:46)
at java.base/java.util.TimSort.binarySort(TimSort.java:296)
at java.base/java.util.TimSort.sort(TimSort.java:221)
at java.base/java.util.Arrays.sort(Arrays.java:1306)
at java.base/java.util.ArrayList.sort(ArrayList.java:1721)
at java.base/java.util.Collections.sort(Collections.java:179)
at liquibase.command.CommandFactory.getCommand(CommandFactory.java:55)
at liquibase.integration.commandline.Main.doMigration(Main.java:1650)
at liquibase.integration.commandline.Main$1.lambda$run$0(Main.java:316)
at liquibase.Scope.lambda$child$0(Scope.java:159)
at liquibase.Scope.child(Scope.java:170)
at liquibase.Scope.child(Scope.java:158)
at liquibase.Scope.child(Scope.java:137)
at liquibase.Scope.child(Scope.java:183)
at liquibase.Scope.child(Scope.java:187)
at liquibase.integration.commandline.Main$1.run(Main.java:315)
at liquibase.integration.commandline.Main$1.run(Main.java:166)
at liquibase.Scope.child(Scope.java:170)
at liquibase.Scope.child(Scope.java:144)
at liquibase.integration.commandline.Main.run(Main.java:166)
at liquibase.integration.commandline.Main.main(Main.java:145)

My java version is :
java version “1.8.0_231”
Java™ SE Runtime Environment (build 1.8.0_231-b11)
Java HotSpot™ 64-Bit Server VM (build 25.231-b11, mixed mode)

BR

7

Hi @msics,
i tried all commands on postgresql instances and everything was completed successfully.
liquibase --changeLogFile=dbchangelog_gen.sql --logLevel=debug generateChangeLog
the changeLogFile must be *.postgresql.sql
or one of this:
Available database short names for serialization:
firebird
oracle
sybase
sqlite
hsqldb
db2z
h2
informix
mariadb
unsupported
postgresql
db2
ingres
asany
derby
mysql
mssql
I used the same configuration and, i can’t replicate your errors. On my side each command was completed successfully.

Please try again with Java 11.

8

Thanks for your interest, as you can see above, I’ve the same error with “–changeLogFile=dbchangelog.postgres.sql”

My PATH starts with
“C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Program Files\Java\jdk-14.0.2;”

Could you tell me how is defined your path for java please (jre/JDK) ?
Actually, the most recent JDK is JDK SE 15, would you suggest however that I use JDK SE 11 ?

BR

9

Hi @msics

This is my JAVA_HOME env var:
C:\Program Files\RedHat\java-11-openjdk-11.0.8-2
Try with java 11 and check if your env is set correctly.

I tested with:
My database : Postgres 15 (org.postgresql.Driver, postgresql-42.2.16.jar)
OS: Windows 10
JDK : 11
Liquibase : Community 4.1.0

Try to start again from Tutorial for Beginners | Using the Liquibase Installer | Liquibase.org
if your issue persists let me know.

Try to pass all param like:

10

Hi,
after the new installation, it works … better :slight_smile:

OK : history, diff and generateChangeLog
KO : liquibase --outputFile=mySnapshot.xml snapshot -snapshotFormat=xml -> fails with ‘No serializers associated with the filename or extension …’ It fails for XML and SQL format

I found another post about it but without replay …
What’s wrong with this command?

BR

11

Hi @msics,

Looking at the documentation:

I believe the arguments need to be all before the command, so:

liquibase --outputFile=mySnapshot.xml snapshot -snapshotFormat=xml

should be
liquibase --outputFile=mySnapshot.xml --snapshotFormat=xml snapshot

Also note the command quoted above was missing a dash before the snapshotFormat arg.

HTH,

Ronak

1 Like
12

You’re right : it runs well now
Thanks a lot

BR

1 Like
13

Yay! Awesome @msics! Okay, I’ll close this issue. Holla if you run into anymore problems.