V4.0.0 genChangeLog diff history commands fail

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

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

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

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

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?

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

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.

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

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 https://www.liquibase.org/get-started/using-the-liquibase-installer
if your issue persists let me know.

Try to pass all param like:

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

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

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

BR

1 Like

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