Upgrade failed in 0.46.1

percyfong · April 27, 2023, 8:52am

we found fail to upgrade for release 0.46.1.

TonyC · April 27, 2023, 10:30am

Share Diagnostic Info and Logs

percyfong · May 4, 2023, 12:51am

Warning: environ value jdk-11.0.19+7 for key :java-version has been overwritten with 11.0.19
2023-05-04 08:35:14,901 INFO metabase.util :: Maximum memory available to JVM: 1.9 GB
2023-05-04 08:35:16,928 WARN db.env :: e[31mWARNING: Using Metabase with an H2 application database is not recommended for production deployments. For production deployments, we highly recommend using Postgres, MySQL, or MariaDB instead. If you decide to continue to use H2, please be sure to back up the database file regularly. For more information, see https://metabase.com/docs/latest/operations-guide/migrating-from-h2.htmle[0m
2023-05-04 08:35:17,137 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance.
For more information, see Redirecting…
..instrumented #'metabase.util.malli/with-api-error-message
..instrumented #'metabase.util.honey-sql-2/identifier
..instrumented #'metabase.util.honey-sql-2/normalize-type-info
..instrumented #'metabase.util.honey-sql-2/with-database-type-info
..instrumented #'metabase.util.honey-sql-2/cast
..instrumented #'metabase.util.honey-sql-2/quoted-cast
..instrumented #'metabase.util.honey-sql-2/maybe-cast
..instrumented #'metabase.models.permissions/classify-path
..instrumented #'metabase.models.permissions/classify-data-path
..instrumented #'metabase.models.permissions/generate-graph
..instrumented #'metabase.models.permissions/->v2-path
..instrumented #'metabase.models.permissions/update-db-data-access-permissions!
..instrumented #'metabase.models.permissions/update-group-permissions!
..instrumented #'metabase.models.permissions/update-data-perms-graph!
..instrumented #'metabase.models.parameter-card/upsert-or-delete-from-parameters!
..instrumented #'metabase.query-processor.middleware.permissions/check-query-permissions*
..instrumented #'metabase.driver.sql-jdbc.sync.describe-database/simple-select-probe-query
2023-05-04 08:35:25,054 INFO driver.impl :: e[34mRegistered abstract driver :sqle[0m
2023-05-04 08:35:25,058 INFO metabase.util :: e[36m ⮦ Load driver :sql took 96.3 mse[0m
2023-05-04 08:35:25,063 INFO driver.impl :: e[34mRegistered abstract driver :sql-jdbce[0m (parents: [:sql])
2023-05-04 08:35:25,066 INFO metabase.util :: e[32mLoad driver :sql-jdbc took 107.9 mse[0m
2023-05-04 08:35:25,067 INFO driver.impl :: e[34mRegistered driver :h2e[0m (parents: [:sql-jdbc])
..instrumented #'metabase.driver.h2/classify-query
2023-05-04 08:35:25,113 INFO driver.impl :: e[34mRegistered driver :mysqle[0m (parents: [:sql-jdbc])
2023-05-04 08:35:25,143 INFO driver.impl :: e[34mRegistered driver :postgrese[0m (parents: [:sql-jdbc])
..instrumented #'metabase.models.params.custom-values/values-from-card
..instrumented #'metabase.api.card/param-values
..instrumented #'metabase.api.dashboard/chain-filter
..instrumented #'metabase.api.setup/state-for-checklist
..instrumented #'metabase.api.setup/checklist-items
2023-05-04 08:35:27,028 INFO metabase.core ::
Metabase v0.46.2 (8967c94 release-x.46.x)

Metabase Enterprise Edition extensions are NOT PRESENT.
2023-05-04 08:35:27,038 INFO metabase.core :: Starting Metabase in STANDALONE mode
2023-05-04 08:35:27,100 INFO metabase.server :: Launching Embedded Jetty Webserver with config:
{:port 3000, :host "0.0.0.0"}

2023-05-04 08:35:27,171 INFO metabase.core :: Starting Metabase version v0.46.2 (8967c94 release-x.46.x) ...
2023-05-04 08:35:27,192 INFO metabase.core :: System info:
{"file.encoding" "UTF-8",
"java.runtime.name" "OpenJDK Runtime Environment",
"java.runtime.version" "11.0.19+7",
"java.vendor" "Eclipse Adoptium",
"java.vendor.url" "https://adoptium.net/",
"java.version" "11.0.19",
"java.vm.name" "OpenJDK 64-Bit Server VM",
"java.vm.version" "11.0.19+7",
"os.name" "Linux",
"os.version" "4.15.0-208-generic",
"user.language" "en",
"user.timezone" "Asia/Hong_Kong"}

2023-05-04 08:35:27,194 INFO metabase.plugins :: Loading plugins in /plugins...
2023-05-04 08:35:27,363 INFO util.files :: Extract file /modules/sparksql.metabase-driver.jar -> /plugins/sparksql.metabase-driver.jar
2023-05-04 08:35:27,426 INFO util.files :: Extract file /modules/athena.metabase-driver.jar -> /plugins/athena.metabase-driver.jar
2023-05-04 08:35:27,523 INFO util.files :: Extract file /modules/sqlserver.metabase-driver.jar -> /plugins/sqlserver.metabase-driver.jar
2023-05-04 08:35:27,533 INFO util.files :: Extract file /modules/presto-jdbc.metabase-driver.jar -> /plugins/presto-jdbc.metabase-driver.jar
2023-05-04 08:35:27,594 INFO util.files :: Extract file /modules/sqlite.metabase-driver.jar -> /plugins/sqlite.metabase-driver.jar
2023-05-04 08:35:27,623 INFO util.files :: Extract file /modules/vertica.metabase-driver.jar -> /plugins/vertica.metabase-driver.jar
2023-05-04 08:35:27,625 INFO util.files :: Extract file /modules/redshift.metabase-driver.jar -> /plugins/redshift.metabase-driver.jar
2023-05-04 08:35:27,632 INFO util.files :: Extract file /modules/druid.metabase-driver.jar -> /plugins/druid.metabase-driver.jar
2023-05-04 08:35:27,636 INFO util.files :: Extract file /modules/mongo.metabase-driver.jar -> /plugins/mongo.metabase-driver.jar
2023-05-04 08:35:27,656 INFO util.files :: Extract file /modules/oracle.metabase-driver.jar -> /plugins/oracle.metabase-driver.jar
2023-05-04 08:35:27,658 INFO util.files :: Extract file /modules/snowflake.metabase-driver.jar -> /plugins/snowflake.metabase-driver.jar
2023-05-04 08:35:27,854 INFO util.files :: Extract file /modules/googleanalytics.metabase-driver.jar -> /plugins/googleanalytics.metabase-driver.jar
2023-05-04 08:35:27,867 INFO util.files :: Extract file /modules/bigquery-cloud-sdk.metabase-driver.jar -> /plugins/bigquery-cloud-sdk.metabase-driver.jar
2023-05-04 08:35:28,061 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :bigquery-cloud-sdk...e[0m
2023-05-04 08:35:28,062 INFO driver.impl :: e[34mRegistered driver :bigquery-cloud-sdke[0m (parents: [:sql])
2023-05-04 08:35:28,069 INFO plugins.dependencies :: e[31mMetabase cannot initialize plugin Metabase Vertica Driver due to required dependencies.e[0m Metabase requires the Vertica JDBC driver in order to connect to Vertica databases, but we can't ship it as part of Metabase due to licensing restrictions. See Redirecting… for more details.

2023-05-04 08:35:28,070 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
2023-05-04 08:35:28,071 INFO plugins.dependencies :: e[33mPlugins with unsatisfied deps: ["Metabase Vertica Driver"]e[0m
2023-05-04 08:35:28,074 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :sqlite...e[0m
2023-05-04 08:35:28,074 INFO driver.impl :: e[34mRegistered driver :sqlitee[0m (parents: [:sql-jdbc])
2023-05-04 08:35:28,082 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :hive-like...e[0m
2023-05-04 08:35:28,082 INFO driver.impl :: e[34mRegistered abstract driver :hive-likee[0m (parents: [:sql-jdbc])
2023-05-04 08:35:28,083 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :sparksql...e[0m
2023-05-04 08:35:28,083 INFO driver.impl :: e[34mRegistered driver :sparksqle[0m (parents: [:hive-like])
2023-05-04 08:35:28,086 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :druid...e[0m
2023-05-04 08:35:28,086 INFO driver.impl :: e[34mRegistered driver :druide[0m
2023-05-04 08:35:28,099 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :athena...e[0m
2023-05-04 08:35:28,099 INFO driver.impl :: e[34mRegistered driver :athenae[0m (parents: [:sql-jdbc])
2023-05-04 08:35:28,112 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :presto-jdbc...e[0m
2023-05-04 08:35:28,112 INFO driver.impl :: e[34mRegistered driver :presto-jdbce[0m (parents: [:sql-jdbc])
2023-05-04 08:35:28,119 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :mongo...e[0m
2023-05-04 08:35:28,120 INFO driver.impl :: e[34mRegistered driver :mongoe[0m
2023-05-04 08:35:28,124 INFO plugins.dependencies :: e[31mMetabase cannot initialize plugin Metabase Oracle Driver due to required dependencies.e[0m Metabase requires the Oracle JDBC driver in order to connect to Oracle databases, but we can't ship it as part of Metabase due to licensing restrictions. See Redirecting… for more details.

2023-05-04 08:35:28,125 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
2023-05-04 08:35:28,125 INFO plugins.dependencies :: e[33mPlugins with unsatisfied deps: ["Metabase Vertica Driver" "Metabase Oracle Driver"]e[0m
2023-05-04 08:35:28,128 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :redshift...e[0m
2023-05-04 08:35:28,128 INFO driver.impl :: e[34mRegistered driver :redshifte[0m (parents: [:postgres])
2023-05-04 08:35:28,131 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :sqlserver...e[0m
2023-05-04 08:35:28,131 INFO driver.impl :: e[34mRegistered driver :sqlservere[0m (parents: [:sql-jdbc])
2023-05-04 08:35:28,150 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :snowflake...e[0m
2023-05-04 08:35:28,150 INFO driver.impl :: e[34mRegistered driver :snowflakee[0m (parents: [:sql-jdbc])
2023-05-04 08:35:28,154 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :googleanalytics...e[0m
2023-05-04 08:35:28,154 INFO driver.impl :: e[34mRegistered driver :googleanalyticse[0m
2023-05-04 08:35:28,154 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
2023-05-04 08:35:28,158 INFO db.setup :: e[36mVerifying h2 Database Connection ...e[0m
2023-05-04 08:35:28,198 INFO db.update-h2 :: H2 v1 database detected, updating...
2023-05-04 08:35:28,198 INFO db.update-h2 :: Downloading https://repo1.maven.org/maven2/com/h2database/h2/1.4.197/h2-1.4.197.jar
2023-05-04 08:35:30,097 INFO db.update-h2 :: Creating v1 database backup at /tmp/metabase-migrate-h2-db-v1-v2.sql
2023-05-04 08:36:05,552 INFO db.update-h2 :: Moving old app database to /metabase.db/metabase.db.v1-backup.mv.db
2023-05-04 08:36:05,624 INFO db.update-h2 :: Restoring backup into v2 database
2023-05-04 08:36:38,100 INFO metabase.core :: Metabase Shutting Down ...
2023-05-04 08:36:38,102 INFO metabase.server :: Shutting Down Embedded Jetty Webserver
2023-05-04 08:36:38,150 INFO metabase.core :: Metabase Shutdown COMPLETE
Warning: environ value jdk-11.0.19+7 for key :java-version has been overwritten with 11.0.19
2023-05-04 08:36:45,088 INFO metabase.util :: Maximum memory available to JVM: 1.9 GB
2023-05-04 08:36:46,942 WARN db.env :: e[31mWARNING: Using Metabase with an H2 application database is not recommended for production deployments. For production deployments, we highly recommend using Postgres, MySQL, or MariaDB instead. If you decide to continue to use H2, please be sure to back up the database file regularly. For more information, see https://metabase.com/docs/latest/operations-guide/migrating-from-h2.htmle[0m
2023-05-04 08:36:47,166 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance.
For more information, see Redirecting…
..instrumented #'metabase.util.malli/with-api-error-message
..instrumented #'metabase.util.honey-sql-2/identifier
..instrumented #'metabase.util.honey-sql-2/normalize-type-info
..instrumented #'metabase.util.honey-sql-2/with-database-type-info
..instrumented #'metabase.util.honey-sql-2/cast
..instrumented #'metabase.util.honey-sql-2/quoted-cast
..instrumented #'metabase.util.honey-sql-2/maybe-cast
..instrumented #'metabase.models.permissions/classify-path
..instrumented #'metabase.models.permissions/classify-data-path
..instrumented #'metabase.models.permissions/generate-graph
..instrumented #'metabase.models.permissions/->v2-path
..instrumented #'metabase.models.permissions/update-db-data-access-permissions!
..instrumented #'metabase.models.permissions/update-group-permissions!
..instrumented #'metabase.models.permissions/update-data-perms-graph!
..instrumented #'metabase.models.parameter-card/upsert-or-delete-from-parameters!
..instrumented #'metabase.query-processor.middleware.permissions/check-query-permissions*
..instrumented #'metabase.driver.sql-jdbc.sync.describe-database/simple-select-probe-query
2023-05-04 08:36:53,095 INFO driver.impl :: e[34mRegistered abstract driver :sqle[0m
2023-05-04 08:36:53,099 INFO metabase.util :: e[36m ⮦ Load driver :sql took 97.6 mse[0m
2023-05-04 08:36:53,105 INFO driver.impl :: e[34mRegistered abstract driver :sql-jdbce[0m (parents: [:sql])
2023-05-04 08:36:53,108 INFO metabase.util :: e[32mLoad driver :sql-jdbc took 110.5 mse[0m
2023-05-04 08:36:53,108 INFO driver.impl :: e[34mRegistered driver :h2e[0m (parents: [:sql-jdbc])
..instrumented #'metabase.driver.h2/classify-query
2023-05-04 08:36:53,156 INFO driver.impl :: e[34mRegistered driver :mysqle[0m (parents: [:sql-jdbc])
2023-05-04 08:36:53,185 INFO driver.impl :: e[34mRegistered driver :postgrese[0m (parents: [:sql-jdbc])
..instrumented #'metabase.models.params.custom-values/values-from-card
..instrumented #'metabase.api.card/param-values
..instrumented #'metabase.api.dashboard/chain-filter
..instrumented #'metabase.api.setup/state-for-checklist
..instrumented #'metabase.api.setup/checklist-items
2023-05-04 08:36:54,985 INFO metabase.core ::
Metabase v0.46.2 (8967c94 release-x.46.x)

Metabase Enterprise Edition extensions are NOT PRESENT.
2023-05-04 08:36:54,996 INFO metabase.core :: Starting Metabase in STANDALONE mode
2023-05-04 08:36:55,071 INFO metabase.server :: Launching Embedded Jetty Webserver with config:
{:port 3000, :host "0.0.0.0"}

2023-05-04 08:36:55,136 INFO metabase.core :: Starting Metabase version v0.46.2 (8967c94 release-x.46.x) ...
2023-05-04 08:36:55,158 INFO metabase.core :: System info:
{"file.encoding" "UTF-8",
"java.runtime.name" "OpenJDK Runtime Environment",
"java.runtime.version" "11.0.19+7",
"java.vendor" "Eclipse Adoptium",
"java.vendor.url" "https://adoptium.net/",
"java.version" "11.0.19",
"java.vm.name" "OpenJDK 64-Bit Server VM",
"java.vm.version" "11.0.19+7",
"os.name" "Linux",
"os.version" "4.15.0-208-generic",
"user.language" "en",
"user.timezone" "Asia/Hong_Kong"}

2023-05-04 08:36:55,160 INFO metabase.plugins :: Loading plugins in /plugins...
2023-05-04 08:36:55,576 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :bigquery-cloud-sdk...e[0m
2023-05-04 08:36:55,577 INFO driver.impl :: e[34mRegistered driver :bigquery-cloud-sdke[0m (parents: [:sql])
2023-05-04 08:36:55,583 INFO plugins.dependencies :: e[31mMetabase cannot initialize plugin Metabase Vertica Driver due to required dependencies.e[0m Metabase requires the Vertica JDBC driver in order to connect to Vertica databases, but we can't ship it as part of Metabase due to licensing restrictions. See Redirecting… for more details.

2023-05-04 08:36:55,585 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
2023-05-04 08:36:55,585 INFO plugins.dependencies :: e[33mPlugins with unsatisfied deps: ["Metabase Vertica Driver"]e[0m
2023-05-04 08:36:55,589 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :sqlite...e[0m
2023-05-04 08:36:55,589 INFO driver.impl :: e[34mRegistered driver :sqlitee[0m (parents: [:sql-jdbc])
2023-05-04 08:36:55,597 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :hive-like...e[0m
2023-05-04 08:36:55,598 INFO driver.impl :: e[34mRegistered abstract driver :hive-likee[0m (parents: [:sql-jdbc])
2023-05-04 08:36:55,598 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :sparksql...e[0m
2023-05-04 08:36:55,599 INFO driver.impl :: e[34mRegistered driver :sparksqle[0m (parents: [:hive-like])
2023-05-04 08:36:55,602 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :druid...e[0m
2023-05-04 08:36:55,603 INFO driver.impl :: e[34mRegistered driver :druide[0m
2023-05-04 08:36:55,615 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :athena...e[0m
2023-05-04 08:36:55,615 INFO driver.impl :: e[34mRegistered driver :athenae[0m (parents: [:sql-jdbc])
2023-05-04 08:36:55,628 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :presto-jdbc...e[0m
2023-05-04 08:36:55,628 INFO driver.impl :: e[34mRegistered driver :presto-jdbce[0m (parents: [:sql-jdbc])
2023-05-04 08:36:55,635 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :mongo...e[0m
2023-05-04 08:36:55,635 INFO driver.impl :: e[34mRegistered driver :mongoe[0m
2023-05-04 08:36:55,640 INFO plugins.dependencies :: e[31mMetabase cannot initialize plugin Metabase Oracle Driver due to required dependencies.e[0m Metabase requires the Oracle JDBC driver in order to connect to Oracle databases, but we can't ship it as part of Metabase due to licensing restrictions. See Redirecting… for more details.

2023-05-04 08:36:55,640 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
2023-05-04 08:36:55,641 INFO plugins.dependencies :: e[33mPlugins with unsatisfied deps: ["Metabase Vertica Driver" "Metabase Oracle Driver"]e[0m
2023-05-04 08:36:55,644 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :redshift...e[0m
2023-05-04 08:36:55,645 INFO driver.impl :: e[34mRegistered driver :redshifte[0m (parents: [:postgres])
2023-05-04 08:36:55,648 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :sqlserver...e[0m
2023-05-04 08:36:55,648 INFO driver.impl :: e[34mRegistered driver :sqlservere[0m (parents: [:sql-jdbc])
2023-05-04 08:36:55,668 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :snowflake...e[0m
2023-05-04 08:36:55,668 INFO driver.impl :: e[34mRegistered driver :snowflakee[0m (parents: [:sql-jdbc])
2023-05-04 08:36:55,672 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :googleanalytics...e[0m
2023-05-04 08:36:55,673 INFO driver.impl :: e[34mRegistered driver :googleanalyticse[0m
2023-05-04 08:36:55,674 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
2023-05-04 08:36:55,677 INFO db.setup :: e[36mVerifying h2 Database Connection ...e[0m
2023-05-04 08:36:57,855 INFO db.setup :: Successfully verified H2 2.1.212 (2022-04-09) application database connection.
2023-05-04 08:36:57,857 INFO db.setup :: Running Database Migrations...
2023-05-04 08:36:57,858 INFO db.setup :: Setting up Liquibase...
2023-05-04 08:36:58,146 INFO db.setup :: Liquibase is ready.
2023-05-04 08:36:58,147 INFO db.liquibase :: Checking if Database has unrun migrations...
2023-05-04 08:36:59,842 INFO db.liquibase :: Database has unrun migrations. Waiting for migration lock to be cleared...
2023-05-04 08:37:00,100 INFO db.liquibase :: Migration lock is cleared. Running migrations...
2023-05-04 08:37:00,603 ERROR metabase.core :: Metabase Initialization FAILED
liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set migrations/000_migrations.yaml::v46.00-000::snoe:
Reason: liquibase.exception.DatabaseException: Table "ACTION" not found; SQL statement:
CREATE TABLE "PUBLIC"."IMPLICIT_ACTION" ("ACTION_ID" INT NOT NULL, "KIND" CLOB NOT NULL, CONSTRAINT "FK_IMPLICIT_ACTION_ACTION_ID" FOREIGN KEY ("ACTION_ID") REFERENCES "PUBLIC"."ACTION"("ID") ON DELETE CASCADE) [42102-212] [Failed SQL: (42102) CREATE TABLE "PUBLIC"."IMPLICIT_ACTION" ("ACTION_ID" INT NOT NULL, "KIND" CLOB NOT NULL, CONSTRAINT "FK_IMPLICIT_ACTION_ACTION_ID" FOREIGN KEY ("ACTION_ID") REFERENCES "PUBLIC"."ACTION"("ID") ON DELETE CASCADE)]
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:126)
at liquibase.Liquibase.lambda$null$0(Liquibase.java:265)
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.Scope.child(Scope.java:243)
at liquibase.Liquibase.lambda$update$1(Liquibase.java:264)
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.update(Liquibase.java:211)
at liquibase.Liquibase.update(Liquibase.java:197)
at liquibase.Liquibase.update(Liquibase.java:193)
at metabase.db.liquibase$migrate_up_if_needed_BANG_.invokeStatic(liquibase.clj:147)
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: liquibase.exception.MigrationFailedException: Migration failed for change set migrations/000_migrations.yaml::v46.00-000::snoe:
Reason: liquibase.exception.DatabaseException: Table "ACTION" not found; SQL statement:
CREATE TABLE "PUBLIC"."IMPLICIT_ACTION" ("ACTION_ID" INT NOT NULL, "KIND" CLOB NOT NULL, CONSTRAINT "FK_IMPLICIT_ACTION_ACTION_ID" FOREIGN KEY ("ACTION_ID") REFERENCES "PUBLIC"."ACTION"("ID") ON DELETE CASCADE) [42102-212] [Failed SQL: (42102) CREATE TABLE "PUBLIC"."IMPLICIT_ACTION" ("ACTION_ID" INT NOT NULL, "KIND" CLOB NOT NULL, CONSTRAINT "FK_IMPLICIT_ACTION_ACTION_ID" FOREIGN KEY ("ACTION_ID") REFERENCES "PUBLIC"."ACTION"("ID") ON DELETE CASCADE)]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:696)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:56)
at liquibase.changelog.ChangeLogIterator$2.lambda$null$0(ChangeLogIterator.java:113)
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.changelog.ChangeLogIterator$2.lambda$run$1(ChangeLogIterator.java:112)
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.Scope.child(Scope.java:243)
at liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:93)
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.Scope.child(Scope.java:243)
at liquibase.Scope.child(Scope.java:247)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:65)
... 54 more
Caused by: liquibase.exception.DatabaseException: Table "ACTION" not found; SQL statement:
CREATE TABLE "PUBLIC"."IMPLICIT_ACTION" ("ACTION_ID" INT NOT NULL, "KIND" CLOB NOT NULL, CONSTRAINT "FK_IMPLICIT_ACTION_ACTION_ID" FOREIGN KEY ("ACTION_ID") REFERENCES "PUBLIC"."ACTION"("ID") ON DELETE CASCADE) [42102-212] [Failed SQL: (42102) CREATE TABLE "PUBLIC"."IMPLICIT_ACTION" ("ACTION_ID" INT NOT NULL, "KIND" CLOB NOT NULL, CONSTRAINT "FK_IMPLICIT_ACTION_ACTION_ID" FOREIGN KEY ("ACTION_ID") REFERENCES "PUBLIC"."ACTION"("ID") ON DELETE CASCADE)]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:397)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:83)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:151)
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1279)
at metabase.db.liquibase.h2.proxy$liquibase.database.core.H2Database$ff19274a.execute(Unknown Source)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1261)
at metabase.db.liquibase.h2.proxy$liquibase.database.core.H2Database$ff19274a.executeStatements(Unknown Source)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:661)
... 74 more
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACTION" not found; SQL statement:
CREATE TABLE "PUBLIC"."IMPLICIT_ACTION" ("ACTION_ID" INT NOT NULL, "KIND" CLOB NOT NULL, CONSTRAINT "FK_IMPLICIT_ACTION_ACTION_ID" FOREIGN KEY ("ACTION_ID") REFERENCES "PUBLIC"."ACTION"("ID") ON DELETE CASCADE) [42102-212]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:502)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
at org.h2.message.DbException.get(DbException.java:223)
at org.h2.message.DbException.get(DbException.java:199)
at org.h2.command.ddl.AlterTableAddConstraint.tryUpdate(AlterTableAddConstraint.java:203)
at org.h2.command.ddl.AlterTableAddConstraint.update(AlterTableAddConstraint.java:72)
at org.h2.command.ddl.AlterTable.update(AlterTable.java:46)
at org.h2.command.ddl.CommandWithColumns.createConstraints(CommandWithColumns.java:83)
at org.h2.command.ddl.CreateTable.update(CreateTable.java:131)
at org.h2.command.CommandContainer.update(CommandContainer.java:174)
at org.h2.command.Command.executeUpdate(Command.java:252)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:252)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:223)
at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:393)
... 81 more
2023-05-04 08:37:00,616 INFO metabase.core :: Metabase Shutting Down ...
2023-05-04 08:37:00,619 INFO metabase.server :: Shutting Down Embedded Jetty Webserver
2023-05-04 08:37:00,629 INFO metabase.core :: Metabase Shutdown COMPLETE

percyfong · May 4, 2023, 12:52am

After upgraded, it can't start the docker again.

TonyC · May 4, 2023, 11:37am

Again share Share Diagnostic Info (Admin -> Troubleshooting -> Diagnostic Info) ... form which version where you upgrading?

Luiggi · May 4, 2023, 11:48am

Clearly the migrations didn’t run, are you using postgres or mysql for the app db?

percyfong · May 5, 2023, 4:01am

0.45.3 -> 0.46.2

percyfong · May 5, 2023, 4:22am

We failed to start the docker of metebase container, we restore the backup for previous version (0.45.3). We didn't see the log from (Admin -> Troubleshooting -> Diagnostic Info).

percyfong · May 5, 2023, 4:27am

{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.18+10",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.18",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.18+10",
"os.name": "Linux",
"os.version": "4.15.0-210-generic",
"user.language": "en",
"user.timezone": "Asia/Hong_Kong"
},
"metabase-info": {
"databases": [
"postgres",
"sqlserver",
"h2"
],
"hosting-env": "unknown",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "1.4.197 (2018-03-18)"
},
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "1.4.197 (2018-03-18)"
}
},
"run-mode": "prod",
"version": {
"date": "2023-02-19",
"tag": "v0.45.3",
"branch": "release-x.45.x",
"hash": "070f57b"
},
"settings": {
"report-timezone": "Asia/Hong_Kong"
}
}
}

percyfong · May 5, 2023, 4:28am

"application-database": "h2". The app db should be H2.

TonyC · May 5, 2023, 7:00am

IT's very easy that an H2 DB gets corrupted, please migrate away from H2:

percyfong · May 10, 2023, 3:57am

[

Docker: how to migrate from H2 to your production application database

](Migrating to a production application database)

You must use the same version of Metabase throughout the migration process.

Metabase provides a custom migration command for migrating to a new application database. Here’s what you’ll do:

percyfong · May 10, 2023, 4:05am

For step 4 run migration,
export MB_DB_TYPE=postgres
export MB_DB_CONNECTION_URI="jdbc:postgresql://:5432/metabase?user=&password="
java -jar metabase.jar load-from-h2 /path/to/metabase.db # do not include .mv.db

what is username and password for the URI?

percyfong · May 10, 2023, 6:05am

Here is my step for upgrade:
Step 1

sudo docker pull metabase/metabase:latest

Step 2

sudo mkdir temp # or whatever folder name you want; you need to use sudo since you are going to be doing cp operations with sudo
sudo docker cp metabase:/metabase.db ./temp/metabase.db.backup
sudo docker stop metabase

Step 3

sudo docker rename metabase metabase_old

Step 4
sudo docker run -d --network host -e "JAVA_TIMEZONE=Asia/Hong_Kong" --name metabase metabase/metabase

Step 5
sudo docker cp temp/metabase.db.backup/metabase.db.mv.db metabase:/metabase.db/metabase.db.mv.db
sudo docker cp temp/metabase.db.backup/metabase.db.trace.db metabase:/metabase.db/metabase.db.trace.db

Step 6
sudo docker restart metabase

** check docker
sudo docker ps -a

Step 7
sudo rm -rf temp/metabase.db
sudo docker rm metabase_old

percyfong · May 10, 2023, 6:07am

It's OK upgrade to v0.45.3 but failed to upgrade to v0.46.1.

TonyC · May 10, 2023, 7:16am

What's the error you are getting on the upgrade failure?

percyfong · May 10, 2023, 7:24am

No error after proceed all 7 steps but after docker restart metabase about 20 seconds, the status of the docker container become exit.

TonyC · May 10, 2023, 7:35am

Are you sure the docker is able to connect with the new database you created? ... Can you still share the logs, maybe there is something we are missing