Metabase won't start after upgrading to v0.44

Hello,

Please advise. I attempted to upgrade Metabase from v0.37 to v0.44. We run the default H2 database and local jar file on a Windows 2016 Server. After the backup and replacing the jar file with the latest version, I attempted to start up (java -jar metabase.jar). It has been stuck on this step since yesterday and I am not sure where to go from here.

Please see the console output below:

D:\metabase>java -jar metabase.jar
Warning: protocol #'java-time.core/Amount is overwriting function abs
WARNING: abs already refers to: #'clojure.core/abs in namespace: java-time.core, being replaced by: #'java-time.core/abs
WARNING: abs already refers to: #'clojure.core/abs in namespace: java-time, being replaced by: #'java-time/abs
WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.
2022-09-08 15:38:03,545 INFO metabase.util :: Maximum memory available to JVM: 27.9 GB
2022-09-08 15:38:04,764 WARN db.env :: WARNING: 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.html
2022-09-08 15:38:08,514 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance.
 For more information, see https://metabase.com/docs/latest/operations-guide/encrypting-database-details-at-rest.html
WARNING: abs already refers to: #'clojure.core/abs in namespace: taoensso.encore, being replaced by: #'taoensso.encore/abs
WARNING: abs already refers to: #'clojure.core/abs in namespace: kixi.stats.math, being replaced by: #'kixi.stats.math/abs
WARNING: abs already refers to: #'clojure.core/abs in namespace: kixi.stats.test, being replaced by: #'kixi.stats.math/abs
WARNING: abs already refers to: #'clojure.core/abs in namespace: kixi.stats.distribution, being replaced by: #'kixi.stats.math/abs
2022-09-08 15:38:14,998 INFO driver.impl :: Registered abstract driver :sql
2022-09-08 15:38:15,014 INFO metabase.util ::  ? Load driver :sql took 117.3 ms
2022-09-08 15:38:15,014 INFO driver.impl :: Registered abstract driver :sql-jdbc (parents: [:sql])
2022-09-08 15:38:15,029 INFO metabase.util :: Load driver :sql-jdbc took 136.3 ms
2022-09-08 15:38:15,029 INFO driver.impl :: Registered driver :h2 (parents: [:sql-jdbc])
2022-09-08 15:38:15,061 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc])
2022-09-08 15:38:15,092 INFO driver.impl :: Registered driver :postgres (parents: [:sql-jdbc])
2022-09-08 15:38:16,982 INFO metabase.core ::
Metabase v0.44.2 (8d9de8a release-x.44.x)

Copyright ⌐ 2022 Metabase, Inc.

Metabase Enterprise Edition extensions are NOT PRESENT.
2022-09-08 15:38:16,998 INFO metabase.core :: Starting Metabase in STANDALONE mode
2022-09-08 15:38:17,029 INFO metabase.server :: Launching Embedded Jetty Webserver with config:
 {:port 3000}

2022-09-08 15:38:17,076 INFO metabase.core :: Starting Metabase version v0.44.2 (8d9de8a release-x.44.x) ...
2022-09-08 15:38:17,123 INFO metabase.core :: System info:
 {"file.encoding" "Cp1252",
 "java.runtime.name" "OpenJDK Runtime Environment",
 "java.runtime.version" "17.0.4.1+1",
 "java.vendor" "Eclipse Adoptium",
 "java.vendor.url" "https://adoptium.net/",
 "java.version" "17.0.4.1",
 "java.vm.name" "OpenJDK 64-Bit Server VM",
 "java.vm.version" "17.0.4.1+1",
 "os.name" "Windows Server 2016",
 "os.version" "10.0",
 "user.language" "en",
 "user.timezone" "America/New_York"}

2022-09-08 15:38:17,123 INFO metabase.plugins :: Loading plugins in D:\metabase\plugins...
2022-09-08 15:38:17,436 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :bigquery-cloud-sdk...
2022-09-08 15:38:17,451 INFO driver.impl :: Registered driver :bigquery-cloud-sdk (parents: [:sql])
2022-09-08 15:38:17,467 INFO plugins.dependencies :: Plugin 'Metabase BigQuery Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
2022-09-08 15:38:17,467 INFO plugins.dependencies :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? false
2022-09-08 15:38:17,467 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase BigQuery Driver"]
2022-09-08 15:38:17,482 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :druid...
2022-09-08 15:38:17,482 INFO driver.impl :: Registered driver :druid
2022-09-08 15:38:17,482 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :google...
2022-09-08 15:38:17,482 INFO driver.impl :: Registered abstract driver :google
2022-09-08 15:38:17,498 INFO plugins.dependencies :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
2022-09-08 15:38:17,498 DEBUG plugins.initialize :: Dependencies satisfied; these plugins will now be loaded: ["Metabase BigQuery Driver"]
2022-09-08 15:38:17,498 WARN plugins.lazy-loaded-driver :: Warning: plugin manifest for :bigquery does not include connection properties
2022-09-08 15:38:17,498 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :bigquery...
2022-09-08 15:38:17,498 INFO driver.impl :: Registered driver :bigquery (parents: [:sql :google])
2022-09-08 15:38:17,514 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :googleanalytics...
2022-09-08 15:38:17,514 INFO driver.impl :: Registered driver :googleanalytics
2022-09-08 15:38:17,529 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :mongo...
2022-09-08 15:38:17,529 INFO driver.impl :: Registered driver :mongo
2022-09-08 15:38:17,545 INFO plugins.dependencies :: Metabase cannot initialize plugin Metabase Oracle Driver due to required dependencies. 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 https://metabase.com/docs/latest/administration-guide/databases/oracle.html for more details.

2022-09-08 15:38:17,545 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
2022-09-08 15:38:17,576 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Oracle Driver"]
2022-09-08 15:38:17,592 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto-common...
2022-09-08 15:38:17,592 INFO driver.impl :: Registered abstract driver :presto-common
2022-09-08 15:38:17,607 INFO plugins.dependencies :: Plugin 'Metabase Presto JDBC Driver' depends on plugin 'Presto Common Driver'
2022-09-08 15:38:17,623 INFO plugins.dependencies :: Metabase Presto JDBC Driver dependency {:plugin Presto Common Driver} satisfied? true
2022-09-08 15:38:17,623 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto-jdbc...
2022-09-08 15:38:17,623 INFO driver.impl :: Registered driver :presto-jdbc (parents: [:presto-common])
2022-09-08 15:38:17,639 INFO plugins.dependencies :: Plugin 'Metabase Presto Driver' depends on plugin 'Presto Common Driver'
2022-09-08 15:38:17,639 INFO plugins.dependencies :: Metabase Presto Driver dependency {:plugin Presto Common Driver} satisfied? true
2022-09-08 15:38:17,670 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto...
2022-09-08 15:38:17,686 INFO driver.impl :: Registered driver :presto (parents: [:presto-common])
2022-09-08 15:38:17,686 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :redshift...
2022-09-08 15:38:17,686 INFO driver.impl :: Registered driver :redshift (parents: [:postgres])
2022-09-08 15:38:17,732 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :snowflake...
2022-09-08 15:38:17,732 INFO driver.impl :: Registered driver :snowflake (parents: [:sql-jdbc])
2022-09-08 15:38:17,795 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :hive-like...
2022-09-08 15:38:17,795 INFO driver.impl :: Registered abstract driver :hive-like (parents: [:sql-jdbc])
2022-09-08 15:38:17,795 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sparksql...
2022-09-08 15:38:17,795 INFO driver.impl :: Registered driver :sparksql (parents: [:hive-like])
2022-09-08 15:38:17,811 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlite...
2022-09-08 15:38:17,811 INFO driver.impl :: Registered driver :sqlite (parents: [:sql-jdbc])
2022-09-08 15:38:17,826 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlserver...
2022-09-08 15:38:17,826 INFO driver.impl :: Registered driver :sqlserver (parents: [:sql-jdbc])
2022-09-08 15:38:17,826 INFO plugins.dependencies :: Metabase cannot initialize plugin Metabase Vertica Driver due to required dependencies. 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 https://metabase.com/docs/latest/administration-guide/databases/vertica.html for more details.

2022-09-08 15:38:17,826 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
2022-09-08 15:38:17,842 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Oracle Driver" "Metabase Vertica Driver"]
2022-09-08 15:38:17,842 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
2022-09-08 15:38:17,842 INFO db.setup :: Verifying h2 Database Connection ...
2022-09-08 15:38:19,104 INFO db.setup :: Successfully verified H2 1.4.197 (2018-03-18) application database connection.
2022-09-08 15:38:19,120 INFO db.setup :: Running Database Migrations...
2022-09-08 15:38:19,120 INFO db.setup :: Setting up Liquibase...
2022-09-08 15:38:19,736 INFO db.setup :: Liquibase is ready.
2022-09-08 15:38:19,736 INFO db.liquibase :: Checking if Database has unrun migrations...
2022-09-08 15:38:24,205 INFO db.liquibase :: Database has unrun migrations. Waiting for migration lock to be cleared...
2022-09-08 15:38:25,002 INFO db.liquibase :: Migration lock is cleared. Running migrations...

Any ideas on what may be causing this? (We do not use Vertica)
Here is the output for this command in the server (java -version)

openjdk version "17.0.4.1" 2022-08-12
OpenJDK Runtime Environment Temurin-17.0.4.1+1 (build 17.0.4.1+1)
OpenJDK 64-Bit Server VM Temurin-17.0.4.1+1 (build 17.0.4.1+1, mixed mode, sharing)

Please advise.

Hi @LawrenceO
Revert to 37 and your backup H2.
Then migrate away from H2, which you should not use in production:
https://www.metabase.com/docs/latest/installation-and-operation/migrating-from-h2
And when you are not using H2 anymore, then you can upgrade.

Thanks for the prompt response. How do I revert back to 37?

@LawrenceO So you didn't make a backup of the JAR? Remember to do that in the future.
https://downloads.metabase.com/v0.37.9/metabase.jar

No, I did. I have a backup of the jar file. So it's as simple as putting back the old jar?

Thanks,
Lawrence

@LawrenceO So you never did a backup of the H2 application database? Well, then you'll have to cross fingers that it's not corrupted. I cannot provide much more help than that if you never backed up the Metabase application database.

If you have a backup of everything, then I don't understand your question. Revert to your backup, meaning restore your backup.