Broken updateSQL functionality

Liquibase Development
1


Generate SQL fails on 3.0.8/3.1.1 when the database is created from scratch(applying all changes on empty database). 


It works well on 3.0.3. 


Command : liquibase --logLevel=info  --changeLogFile=“changelog/changelog-master.xml” updateSQL


Trace:


INFO 1/30/14 11:21 AM:liquibase: Shutting down derby connection: jdbc:derby:/home/rraj/workspace/xyz;shutdown=true

Liquibase updateSQL Failed: liquibase.exception.DatabaseException: Error executing SQL select min(locked) as test from APP.DATABASECHANGELOGLOCK fetch first row only: Table/View ‘APP.DATABASECHANGELOGLOCK’ does not exist.

SEVERE 1/30/14 11:21 AM:liquibase: liquibase.exception.DatabaseException: Error executing SQL select min(locked) as test from APP.DATABASECHANGELOGLOCK fetch first row only: Table/View ‘APP.DATABASECHANGELOGLOCK’ does not exist.

liquibase.exception.LockException: liquibase.exception.DatabaseException: Error executing SQL select min(locked) as test from APP.DATABASECHANGELOGLOCK fetch first row only: Table/View ‘APP.DATABASECHANGELOGLOCK’ does not exist.

… 17 more


2

Thanks for the report. I created https://liquibase.jira.com/browse/CORE-1744 to track the bug.


Nathan

3

Jetzt ist wohl der Fehler wieder im Programmcode? Beim absetzen in eine leere Db2 Datenbank.

Liquibase Community 4.2.2 by Datical
####################################################

_ _ _ _

| | () () |

| | _ __ _ _ _ | |_ __ _ ___ ___

| | | |/ _ | | | | | '_ \ / _ / __|/ _ \

| || | (| | || | | |) | (| _ \ __/

_/|_, |_,||./ _,|/__|

| |

|_|

Get documentation at docs.liquibase.com

Get certified courses at learn.liquibase.com

Free schema change activity reports at

xxx

####################################################
Starting Liquibase at 14:12:35 (version 4.2.2 #36 built at 2020-12-09 20:07+0000)
Unexpected error running Liquibase: Error executing SQL SELECT MIN(locked) AS test FROM “LIQUIBASE”.DATABASECHANGELOGLOCK FETCH FIRST ROW ONLY: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=LIQUIBASE.DATABASECHANGELOGLOCK, DRIVER=4.25.23
For more information, please use the --logLevel flag

4

Looks like the same issue I just raised for → updateSQL on DB2 trying to delete DATABASECHANGELOGLOCK

5

Yes, this Error is the same. I hope Liquibase will fix them.