Failed upgrade to .46. Liquibase.yaml issue

Get Help
1

Attempted to upgrade to .46 and received the following error (Metabase will not start now).

2023-04-18 10:42:34,396 INFO db.liquibase :: Checking if Database has unrun migrations...
2023-04-18 10:42:35,564 ERROR metabase.core :: Metabase Initialization FAILED
liquibase.exception.ChangeLogParseException: Error parsing liquibase.yaml
        at liquibase.parser.core.yaml.YamlChangeLogParser.parse(YamlChangeLogParser.java:89)
        at liquibase.Liquibase.getDatabaseChangeLog(Liquibase.java:369)
        at liquibase.Liquibase$16.run(Liquibase.java:1982)
        at liquibase.Scope.lambda$child$0(Scope.java:180)
        at liquibase.Scope.child(Scope.java:189)
        at liquibase.Scope.child(Scope.java:179)
        at liquibase.Scope.child(Scope.java:158)
        at liquibase.Liquibase.runInScope(Liquibase.java:2405)
        at liquibase.Liquibase.listUnrunChangeSets(Liquibase.java:1978)
        at liquibase.Liquibase.listUnrunChangeSets(Liquibase.java:1969)
        at metabase.db.liquibase$has_unrun_migrations_QMARK_.invokeStatic(liquibase.clj:114)
        at metabase.db.liquibase$has_unrun_migrations_QMARK_.invoke(liquibase.clj:104)
        at metabase.db.liquibase$migrate_up_if_needed_BANG_.invokeStatic(liquibase.clj:139)
        at metabase.db.liquibase$migrate_up_if_needed_BANG_.invoke(liquibase.clj:135)
        at metabase.db.setup$fn__50118$migrate_BANG___50123$fn__50124$fn__50125.invoke(setup.clj:79)
        at metabase.db.liquibase$fn__46055$do_with_liquibase__46060$fn__46061.invoke(liquibase.clj:64)
        at metabase.db.liquibase$fn__46055$do_with_liquibase__46060.invoke(liquibase.clj:56)
        at metabase.db.setup$fn__50118$migrate_BANG___50123$fn__50124.invoke(setup.clj:74)
        at metabase.db.setup$fn__50118$migrate_BANG___50123.doInvoke(setup.clj:52)
        at clojure.lang.RestFn.invoke(RestFn.java:445)
        at metabase.db.setup$fn__50182$run_schema_migrations_BANG___50187$fn__50188.invoke(setup.clj:132)
        at metabase.db.setup$fn__50182$run_schema_migrations_BANG___50187.invoke(setup.clj:126)
        at metabase.db.setup$fn__50235$setup_db_BANG___50240$fn__50241$fn__50244$fn__50245.invoke(setup.clj:157)
        at metabase.util.jvm$do_with_us_locale.invokeStatic(jvm.clj:239)
        at metabase.util.jvm$do_with_us_locale.invoke(jvm.clj:225)
        at metabase.db.setup$fn__50235$setup_db_BANG___50240$fn__50241$fn__50244.invoke(setup.clj:153)
        at metabase.db.setup$fn__50235$setup_db_BANG___50240$fn__50241.invoke(setup.clj:152)
        at metabase.db.setup$fn__50235$setup_db_BANG___50240.invoke(setup.clj:146)
        at metabase.db$setup_db_BANG_$fn__50270.invoke(db.clj:66)
        at metabase.db$setup_db_BANG_.invokeStatic(db.clj:61)
        at metabase.db$setup_db_BANG_.invoke(db.clj:52)
        at metabase.core$init_BANG__STAR_.invokeStatic(core.clj:104)
        at metabase.core$init_BANG__STAR_.invoke(core.clj:90)
        at metabase.core$init_BANG_.invokeStatic(core.clj:144)
        at metabase.core$init_BANG_.invoke(core.clj:139)
        at metabase.core$start_normally.invokeStatic(core.clj:156)
        at metabase.core$start_normally.invoke(core.clj:150)
        at metabase.core$_main.invokeStatic(core.clj:189)
        at metabase.core$_main.doInvoke(core.clj:183)
        at clojure.lang.RestFn.invoke(RestFn.java:397)
        at clojure.lang.AFn.applyToHelper(AFn.java:152)
        at clojure.lang.RestFn.applyTo(RestFn.java:132)
        at clojure.lang.Var.applyTo(Var.java:705)
        at clojure.core$apply.invokeStatic(core.clj:667)
        at clojure.core$apply.invoke(core.clj:662)
        at metabase.bootstrap$_main.invokeStatic(bootstrap.clj:31)
        at metabase.bootstrap$_main.doInvoke(bootstrap.clj:28)
        at clojure.lang.RestFn.invoke(RestFn.java:397)
        at clojure.lang.AFn.applyToHelper(AFn.java:152)
        at clojure.lang.RestFn.applyTo(RestFn.java:132)
        at metabase.bootstrap.main(Unknown Source)
Caused by: java.io.IOException: Found 3 files that match liquibase.yaml: jar:file:/home/metabase/metabase.jar!/liquibase.yaml, jar:file:/home/metabase/plugins/metabase_new.jar!/liquibase.yaml, jar:file:/home/metabase/plugins/metabase.jar!/liquibase.yaml
        at liquibase.resource.AbstractResourceAccessor.openStream(AbstractResourceAccessor.java:25)
        at liquibase.parser.core.yaml.YamlChangeLogParser.parse(YamlChangeLogParser.java:25)
        ... 50 more
2023-04-18 10:42:35,588 INFO metabase.core :: Metabase Shutting Down ...

Please let me know if anyone can help!

2

Well... I was able to solve it.

I had to run it using SUDO in order to solve some permission problems. That then created the migration database using root credentials.

I had to chown the database files to the metabase user, then chmod them to R/W for user and group, then re-run metabase again.

All good and upgraded!

Hope this helps someone in the future.

3

Well I spoke too soon... while I am able to run Metabase from the command line, I cannot get it to start as a service. I always get the same error (above) when trying to run metabase as a service.

I followed the steps contained in Running Metabase on Debian as a service with nginx to set it up as a service. It worked until this upgrade.

Running Ubuntu 20.04

4

you seem to have 3 JARs in different folders
/home/metabase/metabase.jar
/home/metabase/plugins/metabase_new.jar
/home/metabase/plugins/metabase.jar

the process is finding 3 migration files and trying to execute those 3, please organize the files first and then try to migrate

5

Hello,
No idea how those other jar files were created. I'm running ir from /home/metabase/metabase.jar

Can I just delete those other .jar files?

Thank you for your help!

6

You should delete all those but be careful, you need to know which one is the one you’re using right now

7

This did the trick. Removed all other jar files and now things are working.

Successfully upgraded, moved to MySQL and got the service running.

Many thanks for the input!