Issue with Upgrading Metabase from 0.48.13 to 0.49.xx or higher

Get Help
1

Dear Metabase Support Team,
I am currently facing difficulties in updating Metabase from version 0.48.13 to the latest 0.50.10. Even when I update to 0.49.xx is problem. After the upgrade, when I run Metabase, it only runs for a short while, displaying the Metabase splash screens. It gets stuck at this point and does not proceed to the login page. Shortly after, the Metabase service sometimes stops on its own, or it continues running but remains stuck without reaching the login page.

WhatsApp Image 2024-07-09 at 13.53.30_6d0ef855
WhatsApp Image 2024-07-09 at 13.53.30_6d0ef8551298×649 341 KB

fail to update
fail to update810×591 28.7 KB

The operating system I am using is Ubuntu 20.04 Server LTS, and the database is MariaDB 10.3.

I would appreciate any assistance you can provide to resolve this issue.

Thank you for your help.
Taufik Singgih

2

Can you upgrade the application database? Also, can you move to 50.11? We made a lot of performance fixes for MySQL there

3

Hi Luigi,
Thank you for your response.
What is the minimum version of MariaDB for Metabase 0.50.11?

Best Regards
Taufik Singgih

4

Hi Luigi,
Thank you for your response.
What is the minimum version of MariaDB for Metabase 0.50.11?

Best Regards
Taufik Singgih

5

Hey taufik

We recommend PostgreSQL, but you can also use MySQL or MariaDB. The minimum recommended version is MySQL 8.0.17 or MariaDB 10.2.2, and the utf8mb4 character set is required.

Thanks.

6

(post deleted by author)

7

hi Metabase Support Team,

i have the same problem here, my metabase version 0.48.13 can not upgrade to 0.49.0
i'm using metabase.jar , mariadb has been upgraded to " mariadb Ver 15.1 Distrib 10.6.18-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 "

but still can not upgrade, the metabase service was running but not accessible " this site can't be reached " .

please advice,

Regards,

8

hi Metabase Support Team,

i have the same problem here, my metabase version 0.48.13 can not upgrade to 0.49.0
i'm using metabase.jar , mariadb has been upgraded to mariadb Ver 15.1 Distrib 10.6

but still can not upgrade, the metabase service was running but not accessible " this site can't be reached " .

please advice,

Regards,

9

Hi,

I'm having trouble upgrading as well, going from v0.48.4 to v0.50.13. Any help is appreciated!

OS: Amazon Linux 2023
DB: PostgreSQL v16.1 (on RDS)
Running on Docker version 25.0.3, build 4debf41
Docker Compose version v2.28.1, yaml file config:

version: '3'
services:
  metabase:
    image: metabase/metabase:latest
    container_name: metabase
    ports:
      - "3000:3000"
    environment:
    [...]
    healthcheck:
      test: ["CMD", "curl", "-f", "http://localhost:3000/api/health"]
      interval: 1m
      timeout: 10s
      retries: 3
      start_period: 40s
    restart: unless-stopped

Here's what I'm seeing in the logs:

Warning: environ value jdk-11.0.23+9 for key :java-version has been overwritten with 11.0.23
2024-07-20 06:57:33,829 INFO metabase.util :: Maximum memory available to JVM: 476.0 MB
2024-07-20 06:57:39,561 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
2024-07-20 06:57:52,081 INFO driver.impl :: Registered abstract driver :sql  🚚
2024-07-20 06:57:52,095 INFO driver.impl :: Registered abstract driver :sql-jdbc (parents: [:sql]) 🚚
2024-07-20 06:57:52,106 INFO metabase.util :: Load driver :sql-jdbc took 87.6 ms
2024-07-20 06:57:52,107 INFO driver.impl :: Registered driver :h2 (parents: [:sql-jdbc]) 🚚
2024-07-20 06:57:52,581 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc]) 🚚
2024-07-20 06:57:52,642 INFO driver.impl :: Registered driver :postgres (parents: [:sql-jdbc]) 🚚
2024-07-20 06:57:56,928 INFO metabase.core ::
Metabase v0.50.13 (2086968)

Copyright © 2024 Metabase, Inc.

Metabase Enterprise Edition extensions are NOT PRESENT.
2024-07-20 06:57:56,939 INFO metabase.core :: Starting Metabase in STANDALONE mode
2024-07-20 06:57:57,071 INFO metabase.server :: Launching Embedded Jetty Webserver with config:
 {:port 3000, :host "0.0.0.0"}

2024-07-20 06:57:57,247 INFO metabase.core :: Starting Metabase version v0.50.13 (2086968) ...
2024-07-20 06:57:57,262 INFO metabase.core :: System info:
 {"file.encoding" "UTF-8",
 "java.runtime.name" "OpenJDK Runtime Environment",
 "java.runtime.version" "11.0.23+9",
 "java.vendor" "Eclipse Adoptium",
 "java.vendor.url" "https://adoptium.net/",
 "java.version" "11.0.23",
 "java.vm.name" "OpenJDK 64-Bit Server VM",
 "java.vm.version" "11.0.23+9",
 "os.name" "Linux",
 "os.version" "6.1.96-102.177.amzn2023.x86_64",
 "user.language" "en",
 "user.timezone" "GMT"}

2024-07-20 06:57:57,266 INFO metabase.plugins :: Loading plugins in /plugins...
2024-07-20 06:57:58,021 INFO util.files :: Extract file /modules/snowflake.metabase-driver.jar -> /plugins/snowflake.metabase-driver.jar
2024-07-20 06:57:58,847 INFO util.files :: Extract file /modules/sqlite.metabase-driver.jar -> /plugins/sqlite.metabase-driver.jar
2024-07-20 06:57:58,929 INFO util.files :: Extract file /modules/bigquery-cloud-sdk.metabase-driver.jar -> /plugins/bigquery-cloud-sdk.metabase-driver.jar
2024-07-20 06:57:59,410 INFO util.files :: Extract file /modules/sqlserver.metabase-driver.jar -> /plugins/sqlserver.metabase-driver.jar
2024-07-20 06:57:59,438 INFO util.files :: Extract file /modules/presto-jdbc.metabase-driver.jar -> /plugins/presto-jdbc.metabase-driver.jar
2024-07-20 06:57:59,543 INFO util.files :: Extract file /modules/druid.metabase-driver.jar -> /plugins/druid.metabase-driver.jar
2024-07-20 06:57:59,551 INFO util.files :: Extract file /modules/sparksql.metabase-driver.jar -> /plugins/sparksql.metabase-driver.jar
2024-07-20 06:57:59,695 INFO util.files :: Extract file /modules/oracle.metabase-driver.jar -> /plugins/oracle.metabase-driver.jar
2024-07-20 06:57:59,700 INFO util.files :: Extract file /modules/mongo.metabase-driver.jar -> /plugins/mongo.metabase-driver.jar
2024-07-20 06:57:59,750 INFO util.files :: Extract file /modules/redshift.metabase-driver.jar -> /plugins/redshift.metabase-driver.jar
2024-07-20 06:57:59,781 INFO util.files :: Extract file /modules/vertica.metabase-driver.jar -> /plugins/vertica.metabase-driver.jar
2024-07-20 06:57:59,798 INFO util.files :: Extract file /modules/athena.metabase-driver.jar -> /plugins/athena.metabase-driver.jar
2024-07-20 06:57:59,929 INFO util.files :: Extract file /modules/druid-jdbc.metabase-driver.jar -> /plugins/druid-jdbc.metabase-driver.jar
2024-07-20 06:58:00,758 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :snowflake...
2024-07-20 06:58:00,759 INFO driver.impl :: Registered driver :snowflake (parents: [:sql-jdbc]) 🚚
2024-07-20 06:58:00,777 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlite...
2024-07-20 06:58:00,777 INFO driver.impl :: Registered driver :sqlite (parents: [:sql-jdbc]) 🚚
2024-07-20 06:58:00,878 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :bigquery-cloud-sdk...
2024-07-20 06:58:00,892 INFO driver.impl :: Registered driver :bigquery-cloud-sdk (parents: [:sql]) 🚚
2024-07-20 06:58:00,913 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlserver...
2024-07-20 06:58:00,914 INFO driver.impl :: Registered driver :sqlserver (parents: [:sql-jdbc]) 🚚
2024-07-20 06:58:00,969 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto-jdbc...
2024-07-20 06:58:00,981 INFO driver.impl :: Registered driver :presto-jdbc (parents: [:sql-jdbc]) 🚚
2024-07-20 06:58:00,986 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :druid...
2024-07-20 06:58:00,986 INFO driver.impl :: Registered driver :druid  🚚
2024-07-20 06:58:01,023 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :hive-like...
2024-07-20 06:58:01,024 INFO driver.impl :: Registered abstract driver :hive-like (parents: [:sql-jdbc]) 🚚
2024-07-20 06:58:01,025 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sparksql...
2024-07-20 06:58:01,026 INFO driver.impl :: Registered driver :sparksql (parents: [:hive-like]) 🚚
2024-07-20 06:58:01,045 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.

2024-07-20 06:58:01,048 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
2024-07-20 06:58:01,049 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Oracle Driver"]
2024-07-20 06:58:01,071 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :mongo...
2024-07-20 06:58:01,072 INFO driver.impl :: Registered driver :mongo  🚚
2024-07-20 06:58:01,087 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :redshift...
2024-07-20 06:58:01,088 INFO driver.impl :: Registered driver :redshift (parents: [:postgres]) 🚚
2024-07-20 06:58:01,104 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.

2024-07-20 06:58:01,106 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
2024-07-20 06:58:01,107 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Vertica Driver" "Metabase Oracle Driver"]
2024-07-20 06:58:01,151 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :athena...
2024-07-20 06:58:01,153 INFO driver.impl :: Registered driver :athena (parents: [:sql-jdbc]) 🚚
2024-07-20 06:58:01,165 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :druid-jdbc...
2024-07-20 06:58:01,166 INFO driver.impl :: Registered driver :druid-jdbc (parents: [:sql-jdbc]) 🚚
2024-07-20 06:58:01,179 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
2024-07-20 06:58:01,195 INFO db.setup :: Verifying postgres Database Connection ...
2024-07-20 06:58:02,455 INFO db.setup :: Successfully verified PostgreSQL 16.1 application database connection. ✅
2024-07-20 06:58:02,483 INFO db.setup :: Checking if a database downgrade is required...
2024-07-20 06:58:04,154 INFO db.setup :: Running Database Migrations...
2024-07-20 06:58:04,155 INFO db.setup :: Setting up Liquibase...
2024-07-20 06:58:04,516 INFO db.setup :: Liquibase is ready.
2024-07-20 06:58:04,517 INFO db.liquibase :: Checking if Database has unrun migrations...
2024-07-20 06:58:05,988 INFO db.liquibase :: Database has unrun migrations. Checking if migration lock is taken...
2024-07-20 06:58:06,056 INFO db.liquibase :: No migration lock found.
2024-07-20 06:58:06,057 INFO db.liquibase :: Migration lock acquired.
2024-07-20 06:58:06,884 INFO db.liquibase :: Running 140 migrations ...
2024-07-20 06:58:14,666 INFO impl.StdSchedulerFactory :: Using default implementation for ThreadExecutor
2024-07-20 06:58:14,722 INFO core.SchedulerSignalerImpl :: Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
2024-07-20 06:58:14,723 INFO core.QuartzScheduler :: Quartz Scheduler v.2.3.2 created.
2024-07-20 06:58:14,724 INFO jdbcjobstore.JobStoreTX :: Using db table-based data access locking (synchronization).
2024-07-20 06:58:14,735 INFO jdbcjobstore.JobStoreTX :: JobStoreTX initialized.
2024-07-20 06:58:14,737 INFO core.QuartzScheduler :: Scheduler meta-data: Quartz Scheduler (v2.3.2) 'MetabaseScheduler' with instanceId '50fd87b3dc1c1721458694671'
  Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  NOT STARTED.
  Currently in standby mode.
  Number of jobs executed: 0
  Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads.
  Using job-store 'org.quartz.impl.jdbcjobstore.JobStoreTX' - which supports persistence. and is clustered.

2024-07-20 06:58:14,738 INFO impl.StdSchedulerFactory :: Quartz scheduler 'MetabaseScheduler' initialized from default resource file in Quartz package: 'quartz.properties'
2024-07-20 06:58:14,739 INFO impl.StdSchedulerFactory :: Quartz scheduler version: 2.3.2
2024-07-20 06:58:14,791 INFO jdbcjobstore.JobStoreTX :: ClusterManager: detected 1 failed or restarted instances.
2024-07-20 06:58:14,791 INFO jdbcjobstore.JobStoreTX :: ClusterManager: Scanning for instance "69e8776f3c8b1721436144940"'s failed in-progress jobs.
2024-07-20 06:58:14,814 INFO core.QuartzScheduler :: Scheduler MetabaseScheduler_$_50fd87b3dc1c1721458694671 started.
2024-07-20 06:58:14,848 INFO core.QuartzScheduler :: Scheduler MetabaseScheduler_$_50fd87b3dc1c1721458694671 shutting down.
2024-07-20 06:58:14,849 INFO core.QuartzScheduler :: Scheduler MetabaseScheduler_$_50fd87b3dc1c1721458694671 paused.
2024-07-20 06:58:14,852 INFO core.QuartzScheduler :: Scheduler MetabaseScheduler_$_50fd87b3dc1c1721458694671 shutdown complete.
2024-07-20 06:58:14,865 INFO db.custom-migrations :: No forward migration for DeleteSendPulseTaskOnDowngrade
2024-07-20 06:58:14,876 INFO db.custom-migrations :: No forward migration for DeleteInitSendPulseTriggersOnDowngrade
2024-07-20 06:58:23,085 ERROR middleware.log :: GET /api/health 503 3.8 ms (0 DB calls) {:metabase-user-id nil}
{:status "initializing", :progress 0.3}

2024-07-20 06:59:23,284 ERROR middleware.log :: GET /api/health 503 334.9 µs (0 DB calls) {:metabase-user-id nil}
{:status "initializing", :progress 0.3}

2024-07-20 07:00:23,419 ERROR middleware.log :: GET /api/health 503 327.1 µs (0 DB calls) {:metabase-user-id nil}
{:status "initializing", :progress 0.3}
10
11

This might be you’re running out of memory

12

Post the logs