Liquibase creating changelogs and not executing them

Support
#1

Dear Supportteam

I have a project with the following build definition
image

Each time I debug the application, there is a changelog file created, as I did update several entities but the changelog get never executed.

2025-10-17T08:00:01.074+02:00  INFO 4648 --- [4.0] [           main] liquibase.database                       : Set default schema name to dbo
2025-10-17T08:00:01.573+02:00  INFO 4648 --- [4.0] [           main] liquibase.changelog                      : Reading from DATABASECHANGELOG
2025-10-17T08:00:01.713+02:00  INFO 4648 --- [4.0] [           main] liquibase.ui                             : Database is up to date, no changesets to execute
2025-10-17T08:00:01.715+02:00  INFO 4648 --- [4.0] [           main] liquibase.changelog                      : Reading from DATABASECHANGELOG
2025-10-17T08:00:01.735+02:00  INFO 4648 --- [4.0] [           main] liquibase.util                           : UPDATE SUMMARY
2025-10-17T08:00:01.735+02:00  INFO 4648 --- [4.0] [           main] liquibase.util                           : Run:                          0
2025-10-17T08:00:01.735+02:00  INFO 4648 --- [4.0] [           main] liquibase.util                           : Previously run:              21
2025-10-17T08:00:01.735+02:00  INFO 4648 --- [4.0] [           main] liquibase.util                           : Filtered out:                15
2025-10-17T08:00:01.735+02:00  INFO 4648 --- [4.0] [           main] liquibase.util                           : -------------------------------
2025-10-17T08:00:01.735+02:00  INFO 4648 --- [4.0] [           main] liquibase.util                           : Total change sets:           36
2025-10-17T08:00:01.735+02:00  INFO 4648 --- [4.0] [           main] liquibase.util                           : FILTERED CHANGE SETS SUMMARY
2025-10-17T08:00:01.735+02:00  INFO 4648 --- [4.0] [           main] liquibase.util                           : DBMS mismatch:               15
2025-10-17T08:00:01.737+02:00  INFO 4648 --- [4.0] [           main] liquibase.util                           : Update summary generated
2025-10-17T08:00:01.738+02:00  INFO 4648 --- [4.0] [           main] liquibase.command                        : Command execution complete

If I try to update it manually
image

I get the simple message
image

which is not true !

Somehow liquibase see the difference, as it is generating over and over changelogs, but I have no chance to execute these updates ;/

How to solve this issue ?

Regards
Felix

#2

Hello,

I may have a suggestion, it happens to me sometimes during development, when I change databases, or restore them from backup … a desync happens between Liquibase changesets and the data in the Liquibase tables in databases.

In your database, you can find these 2 tables:

1 What is the DATABASECHANGELOG table? - Liquibase
Liquibase tracks which changesets have been run by using the DATABASECHANGELOG (DBCL) table. If the table does not exist in the database, Liquibase creates one automatically.

  1. What is the DATABASECHANGELOGLOCK table? - Liquibase
Liquibase uses the DATABASECHANGELOGLOCK (DBCLL) table to ensure only one instance of Liquibase runs at a time. If the table does not exist in the database, Liquibase creates one automaticall
Liquibase

So Liquibase thinks that it made the changes. You can generate Jmix views and put them in some admin menu to see what’s in there, and delete the entry from databasechangelog so it will apply it.

Kind regards,
Mladen

#3

Hi @mbucan

My databasechangelog contains records from 2025-04-29 until 2025-05-28 where I have the changelog.xml’s.

After disabling Liquibase because of too many problems, I did reactivate it and liquibase is generating a correct changelog file each time I start the application …

image

But it does not execute these changelog files !

It is writing to the log
2025-10-17T14:35:51.694+02:00 INFO 21404 — [4.0] [ main] liquibase.util : DBMS mismatch: 15

How is it possible to execute manually one of these changelog.xml, so it does not get generated over and over and the application is not working correctly ?

Best regards
Felix