Liquibase Issue in 2.15.x.Final

[brentcrammond]

It appears that something has changed in 2.15.1.Final that breaks liquibase, the 0001_create_database.sql exists and is working when I put it back to 2.14.3.Final. It could be something to do with my configuration but it has been working yup until now.

Stacktrace:

    2022-12-22 08:58:15,433 ERROR [io.qua.run.Application] (Quarkus Main Thread) Failed to start application (with profile dev): java.io.FileNotFoundException: The file classpath:db/change_logs/0001_create_database.sql was not found in the configured search path:
    More locations can be added with the 'searchPath' parameter.
        at liquibase.resource.ResourceAccessor.getExisting(ResourceAccessor.java:162)
        at liquibase.parser.core.sql.SqlChangeLogParser.parse(SqlChangeLogParser.java:40)
        at liquibase.changelog.DatabaseChangeLog.include(DatabaseChangeLog.java:717)
        at liquibase.changelog.DatabaseChangeLog.handleChildNode(DatabaseChangeLog.java:411)
        at liquibase.changelog.DatabaseChangeLog.load(DatabaseChangeLog.java:364)
        at liquibase.parser.core.yaml.YamlChangeLogParser.parse(YamlChangeLogParser.java:84)
        at liquibase.Liquibase.getDatabaseChangeLog(Liquibase.java:408)
        at liquibase.Liquibase.validate(Liquibase.java:2323)
        at io.quarkus.liquibase.runtime.LiquibaseRecorder.doStartActions(LiquibaseRecorder.java:67)
        at io.quarkus.deployment.steps.LiquibaseProcessor$startLiquibase763757012.deploy_0(Unknown Source)
        at io.quarkus.deployment.steps.LiquibaseProcessor$startLiquibase763757012.deploy(Unknown Source)
        at io.quarkus.runner.ApplicationImpl.doStart(Unknown Source)
        at io.quarkus.runtime.Application.start(Application.java:101)
        at io.quarkus.runtime.ApplicationLifecycleManager.run(ApplicationLifecycleManager.java:109)
        at io.quarkus.runtime.Quarkus.run(Quarkus.java:71)
        at io.quarkus.runtime.Quarkus.run(Quarkus.java:44)
        at nz.aphg.hst.loader.Main.main(Main.java:10)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:568)
        at io.quarkus.runner.bootstrap.StartupActionImpl$1.run(StartupActionImpl.java:104)
        at java.base/java.lang.Thread.run(Thread.java:833)

resources/db/change_log.json:

    {
      "databaseChangeLog": [
        {
          "include": {
            "file": "classpath:db/change_logs/0001_create_database.sql"
          }
        }
      ]
    }

[quarkus-bot[bot]]

/cc @andrejpetras(liquibase), @geoand(liquibase), @gsmet(liquibase)

[geoand]

Can you please attach a sample application that exhibits this problem?

[brentcrammond]

Hi

As requested here is a very simplified example application.

Attached is a simple example, it needs a mysql database schema lq-test (you will need to check the application.properties). It works with 2.14.3 but not with 2.15.1. I tested it running a 2.14.3 first then switch to 2.15.1 and run again and the error will occur.

Macbook Pro M1
Adoptium 17
MySQL 8

liquibase-test.zip

[geoand]

🙏🏼

[geoand]

I don't know if this is a bug in Liquibase or if things have changed their intentionaly. It seems like the classpath:/ prefix no longer works in the include block. If you remove it, everything works as expected

[brentcrammond]

Hi Georgios Thanks.

On Fri, 23 Dec 2022 at 00:31, Georgios Andrianakis ***@***.***> wrote: I don't know if this is a bug in Liquibase or if things have changed their intentionaly. It seems like the classpath:/ prefix no longer works in the include block. If you remove it, everything works as expected — Reply to this email directly, view it on GitHub <#30014 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABPYWIQPIA35YLLFHKRF7XLWOQ3ZBANCNFSM6AAAAAATF7U6RQ> . You are receiving this because you authored the thread.Message ID: ***@***.***>

-- — Brent Crammond Anameg Consulting Ltd MBA, BSc (CompSci) Mobile: +64 21 228 5366