I am deploying a metabase for the first time and hope to use it to store application data. However, the server startup failed and I saw an error message. The database connection is not a problem, and I have already written most of the tables to the database. The error message is about migration. What is the reason for this
JDK version
java -version
openjdk version "11.0.2" 2019-01-15
OpenJDK Runtime Environment 18.9 (build 11.0.2+9)
OpenJDK 64-Bit Server VM 18.9 (build 11.0.2+9, mixed mode)
metabase 0.50.27
2024-10-02 01:52:10,500 ERROR cmd.copy :: [FAIL]
clojure.lang.ExceptionInfo: ERROR Set up mysql target database and run migrations...: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset migrations/001_update_migrations.yaml::v49.00-059::qnkhuat:
Reason: clojure.lang.ExceptionInfo: (conn=1741278) SAVEPOINT 49887537-12d0-4d22-98b8-42e7fcc2b109 does not exist {:toucan2/context-trace [["resolve connection" {:toucan2.connection/connectable org.mariadb.jdbc.MariaDbConnection}] ["resolve connection" {:toucan2.connection/connectable nil}]]} {}
at metabase.cmd.copy$do_step$fn__98295.invoke(copy.clj:34)
at metabase.cmd.copy$do_step.invokeStatic(copy.clj:30)
at metabase.cmd.copy$do_step.invoke(copy.clj:28)
at metabase.cmd.copy$copy_BANG_.invokeStatic(copy.clj:397)
at metabase.cmd.copy$copy_BANG_.invoke(copy.clj:382)
at metabase.cmd.load_from_h2$load_from_h2_BANG_.invokeStatic(load_from_h2.clj:35)
at metabase.cmd.load_from_h2$load_from_h2_BANG_.invoke(load_from_h2.clj:25)
at clojure.lang.Var.invoke(Var.java:384)
at metabase.cmd$load_from_h2.invokeStatic(cmd.clj:74)
at metabase.cmd$load_from_h2.invoke(cmd.clj:68)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$apply.invoke(core.clj:662)
at metabase.cmd$run_cmd$fn__105986.invoke(cmd.clj:315)
at metabase.cmd$run_cmd.invokeStatic(cmd.clj:312)
at metabase.cmd$run_cmd.invoke(cmd.clj:302)
at clojure.lang.Var.invoke(Var.java:393)
at metabase.core$run_cmd.invokeStatic(core.clj:193)
at metabase.core$run_cmd.invoke(core.clj:191)
at metabase.core$entrypoint.invokeStatic(core.clj:215)
at metabase.core$entrypoint.doInvoke(core.clj:210)
at clojure.lang.RestFn.applyTo(RestFn.java:137)
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.applyTo(RestFn.java:137)
at metabase.bootstrap.main(Unknown Source)
Caused by: liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset migrations/001_update_migrations.yaml::v49.00-059::qnkhuat:
Reason: clojure.lang.ExceptionInfo: (conn=1741278) SAVEPOINT 49887537-12d0-4d22-98b8-42e7fcc2b109 does not exist {:toucan2/context-trace [["resolve connection" {:toucan2.connection/connectable org.mariadb.jdbc.MariaDbConnection}] ["resolve connection" {:toucan2.connection/connectable nil}]]}
at liquibase.command.CommandScope.execute(CommandScope.java:253)
at liquibase.Liquibase.lambda$update$0(Liquibase.java:245)
at liquibase.Scope.lambda$child$0(Scope.java:186)
at liquibase.Scope.child(Scope.java:195)
at liquibase.Scope.child(Scope.java:185)
at liquibase.Scope.child(Scope.java:164)
at liquibase.Liquibase.runInScope(Liquibase.java:1419)
at liquibase.Liquibase.update(Liquibase.java:234)
at liquibase.Liquibase.update(Liquibase.java:212)
at liquibase.Liquibase.update(Liquibase.java:194)
at metabase.db.liquibase$migrate_up_if_needed_BANG$fn__44284.invoke(liquibase.clj:360)
at metabase.db.liquibase$run_in_scope_locked$reify__44280.run(liquibase.clj:325)
at liquibase.Scope.lambda$child$0(Scope.java:186)
at liquibase.Scope.child(Scope.java:195)
at liquibase.Scope.child(Scope.java:185)
at liquibase.Scope.child(Scope.java:164)
at metabase.db.liquibase$run_in_scope_locked.invokeStatic(liquibase.clj:318)
at metabase.db.liquibase$run_in_scope_locked.invoke(liquibase.clj:301)
at metabase.db.liquibase$migrate_up_if_needed_BANG.invokeStatic(liquibase.clj:349)
at metabase.db.liquibase$migrate_up_if_needed_BANG_.invoke(liquibase.clj:342)
at metabase.db.setup$migrate_BANG_$fn__54290.invoke(setup.clj:84)
at metabase.db.liquibase$do_with_liquibase$f_STAR___44221.invoke(liquibase.clj:140)
at metabase.db.liquibase$do_with_liquibase.invokeStatic(liquibase.clj:143)
at metabase.db.liquibase$do_with_liquibase.invoke(liquibase.clj:131)
at metabase.db.setup$migrate_BANG_.invokeStatic(setup.clj:73)
at metabase.db.setup$migrate_BANG_.doInvoke(setup.clj:55)
at clojure.lang.RestFn.invoke(RestFn.java:425)
at metabase.db.setup$run_schema_migrations_BANG_.invokeStatic(setup.clj:149)
at metabase.db.setup$run_schema_migrations_BANG_.invoke(setup.clj:144)
at metabase.db.setup$setup_db_BANG_$fn__54318$fn__54319.invoke(setup.clj:167)
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$setup_db_BANG_$fn__54318.invoke(setup.clj:161)
at metabase.db.setup$setup_db_BANG_.invokeStatic(setup.clj:160)
at metabase.db.setup$setup_db_BANG_.invoke(setup.clj:153)
at metabase.cmd.copy$copy_BANG_$fn__98489.invoke(copy.clj:398)
at metabase.cmd.copy$do_step$fn__98295.invoke(copy.clj:31)
... 29 more
Caused by: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset migrations/001_update_migrations.yaml::v49.00-059::qnkhuat:
Reason: clojure.lang.ExceptionInfo: (conn=1741278) SAVEPOINT 49887537-12d0-4d22-98b8-42e7fcc2b109 does not exist {:toucan2/context-trace [["resolve connection" {:toucan2.connection/connectable org.mariadb.jdbc.MariaDbConnection}] ["resolve connection" {:toucan2.connection/connectable nil}]]}
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:151)
at liquibase.command.core.AbstractUpdateCommandStep.lambda$run$0(AbstractUpdateCommandStep.java:110)
at liquibase.Scope.lambda$child$0(Scope.java:186)
at liquibase.Scope.child(Scope.java:195)
at liquibase.Scope.child(Scope.java:185)
at liquibase.Scope.child(Scope.java:164)
at liquibase.command.core.AbstractUpdateCommandStep.run(AbstractUpdateCommandStep.java:108)
at liquibase.command.core.UpdateCommandStep.run(UpdateCommandStep.java:105)
at liquibase.command.CommandScope.execute(CommandScope.java:217)
... 65 more
Caused by: liquibase.exception.MigrationFailedException: Migration failed for changeset migrations/001_update_migrations.yaml::v49.00-059::qnkhuat:
Reason: clojure.lang.ExceptionInfo: (conn=1741278) SAVEPOINT 49887537-12d0-4d22-98b8-42e7fcc2b109 does not exist {:toucan2/context-trace [["resolve connection" {:toucan2.connection/connectable org.mariadb.jdbc.MariaDbConnection}] ["resolve connection" {:toucan2.connection/connectable nil}]]}
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:797)
at liquibase.changelog.visitor.UpdateVisitor.executeAcceptedChange(UpdateVisitor.java:119)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:68)
at liquibase.changelog.ChangeLogIterator$2.lambda$run$0(ChangeLogIterator.java:133)
at liquibase.Scope.lambda$child$0(Scope.java:186)
at liquibase.Scope.child(Scope.java:195)
at liquibase.Scope.child(Scope.java:185)
at liquibase.Scope.child(Scope.java:164)
at liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:122)
at liquibase.Scope.lambda$child$0(Scope.java:186)
at liquibase.Scope.child(Scope.java:195)
at liquibase.Scope.child(Scope.java:185)
at liquibase.Scope.child(Scope.java:164)
at liquibase.Scope.child(Scope.java:252)
at liquibase.Scope.child(Scope.java:256)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:89)
... 73 more
Caused by: clojure.lang.ExceptionInfo: (conn=1741278) SAVEPOINT 49887537-12d0-4d22-98b8-42e7fcc2b109 does not exist {:toucan2/context-trace [["resolve connection" {:toucan2.connection/connectable org.mariadb.jdbc.MariaDbConnection}] ["resolve connection" {:toucan2.connection/connectable nil}]]}
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158)
at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:262)
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:362)
at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:500)
at org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:784)
at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1007)
at metabase.db.connection$do_transaction$thunk__42418.invoke(connection.clj:146)
at metabase.db.connection$do_transaction.invokeStatic(connection.clj:155)
at metabase.db.connection$do_transaction.invoke(connection.clj:136)
at metabase.db.connection$do_with_transaction_primary_method_java_sql_Connection.invokeStatic(connection.clj:189)
at metabase.db.connection$do_with_transaction_primary_method_java_sql_Connection.invoke(connection.clj:162)
at methodical.impl.combo.common$partial_STAR_$fn__18182.invoke(common.clj:13)
at methodical.util.FnWithMeta.invoke(util.clj:46)
at toucan2.connection$do_with_transaction_around_method_toucan2_connection_default.invokeStatic(connection.clj:249)
at toucan2.connection$do_with_transaction_around_method_toucan2_connection_default.invoke(connection.clj:245)
at methodical.impl.combo.common$partial_STAR_$fn__18182.invoke(common.clj:13)
at methodical.util.FnWithMeta.invoke(util.clj:46)
at methodical.impl.standard$invoke_multifn.invokeStatic(standard.clj:58)
at methodical.impl.standard$invoke_multifn.invoke(standard.clj:47)
at methodical.impl.standard.StandardMultiFn.invoke(standard.clj:212)
at metabase.db.custom_migrations.UnifyTimeColumnsType$with_connection_STAR___43810.invoke(custom_migrations.clj:1030)
at toucan2.connection$bind_current_connectable_fn$fn__21277.invoke(connection.clj:104)
at toucan2.connection$bind_current_connectable_fn$fn__21277.invoke(connection.clj:104)
at toucan2.jdbc.connection$do_with_connection_primary_method_java_sql_Connection.invokeStatic(connection.clj:13)
at toucan2.jdbc.connection$do_with_connection_primary_method_java_sql_Connection.invoke(connection.clj:11)
at methodical.impl.combo.common$partial_STAR_$fn__18182.invoke(common.clj:12)
at methodical.util.FnWithMeta.invoke(util.clj:46)
at toucan2.connection$do_with_connection_around_method_toucan2_connection_default.invokeStatic(connection.clj:118)
at toucan2.connection$do_with_connection_around_method_toucan2_connection_default.invoke(connection.clj:106)
at methodical.impl.combo.common$partial_STAR_$fn__18182.invoke(common.clj:12)
at methodical.util.FnWithMeta.invoke(util.clj:46)
at methodical.impl.standard$invoke_multifn.invokeStatic(standard.clj:55)
at methodical.impl.standard$invoke_multifn.invoke(standard.clj:47)
at methodical.impl.standard.StandardMultiFn.invoke(standard.clj:210)
at toucan2.connection$do_with_connection_primary_method_.invokeStatic(connection.clj:204)
at toucan2.connection$do_with_connection_primary_method_.invoke(connection.clj:194)
at methodical.impl.combo.common$partial_STAR_$fn__18182.invoke(common.clj:12)
at methodical.util.FnWithMeta.invoke(util.clj:46)
at toucan2.connection$do_with_connection_around_method_toucan2_connection_default.invokeStatic(connection.clj:118)
at toucan2.connection$do_with_connection_around_method_toucan2_connection_default.invoke(connection.clj:106)
at methodical.impl.combo.common$partial_STAR_$fn__18182.invoke(common.clj:12)
at methodical.util.FnWithMeta.invoke(util.clj:46)
at methodical.impl.standard$invoke_multifn.invokeStatic(standard.clj:55)
at methodical.impl.standard$invoke_multifn.invoke(standard.clj:47)
at methodical.impl.standard.StandardMultiFn.invoke(standard.clj:210)
at metabase.db.custom_migrations.UnifyTimeColumnsType.execute(custom_migrations.clj:1030)
at liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:170)
at liquibase.executor.AbstractExecutor.execute(AbstractExecutor.java:133)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1285)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:755)
... 88 more
Caused by: java.sql.SQLSyntaxErrorException: (conn=1741278) SAVEPOINT 49887537-12d0-4d22-98b8-42e7fcc2b109 does not exist
... 139 more
Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: SAVEPOINT 49887537-12d0-4d22-98b8-42e7fcc2b109 does not exist
at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:195)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:263)
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:356)
... 135 more
Caused by: java.sql.SQLException: SAVEPOINT 49887537-12d0-4d22-98b8-42e7fcc2b109 does not exist
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1693)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1555)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1518)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:257)
... 136 more
Command failed with exception: ERROR Set up mysql target database and run migrations...: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset migrations/001_update_migrations.yaml::v49.00-059::qnkhuat:
Reason: clojure.lang.ExceptionInfo: (conn=1741278) SAVEPOINT 49887537-12d0-4d22-98b8-42e7fcc2b109 does not exist {:toucan2/context-trace [["resolve connection" {:toucan2.connection/connectable org.mariadb.jdbc.MariaDbConnection}] ["resolve connection" {:toucan2.connection/connectable nil}]]}