Metabase stopped working. What might be the problem?

#1

Hello everyone!

I was using Metabase for a long time when all of a sudden today it stopped working. I was doing some random stuff when it crashed and I could no longer login.

I rebooted the machine that it is working on but it keeps on getting stuck at startup. What might be the problem?

May 14 17:01:14 localhost systemd: Started Metabase server.
May 14 17:01:16 localhost metabase: 05-14 12:01:16 #033[1mINFO metabase.util#033[0m :: Loading Metabase...
May 14 17:01:16 localhost metabase: 05-14 12:01:16 #033[1mINFO metabase.util#033[0m :: Maximum memory available to JVM: 3.4 GB
May 14 17:01:18 localhost metabase: 05-14 12:01:18 #033[1mINFO util.encryption#033[0m :: Saved credentials encryption is DISABLED for this Metabase instance. πŸ”“
May 14 17:01:18 localhost metabase: For more information, see https://www.metabase.com/docs/latest/operations-guide/start.html#encrypting-your-database-connection-details-at-rest
May 14 17:01:23 localhost metabase: 05-14 12:01:23 #033[1mINFO metabase.core#033[0m :: Starting Metabase in STANDALONE mode
May 14 17:01:23 localhost metabase: 05-14 12:01:23 #033[1mINFO metabase.core#033[0m :: Launching Embedded Jetty Webserver with config:
May 14 17:01:23 localhost metabase: {:port 3000}
May 14 17:01:23 localhost metabase: 05-14 12:01:23 #033[1mINFO metabase.core#033[0m :: Starting Metabase version v0.31.2 (89c37eb release-0.31.2) ...
May 14 17:01:23 localhost metabase: 05-14 12:01:23 #033[1mINFO metabase.core#033[0m :: System timezone is 'Atlantic/South_Georgia' ...
May 14 17:01:23 localhost metabase: 05-14 12:01:23 #033[1mINFO metabase.plugins#033[0m :: Loading plugins in directory /plugins...
May 14 17:01:23 localhost metabase: 05-14 12:01:23 #033[1mINFO metabase.plugins#033[0m :: #033[35mLoading plugin /plugins/sparksql.metabase-driver.jar... πŸ”Œ#033[0m
May 14 17:01:23 localhost metabase: 05-14 12:01:23 #033[1mINFO metabase.plugins#033[0m :: #033[35mLoading plugin /plugins/bigquery.metabase-driver.jar... πŸ”Œ#033[0m
May 14 17:01:23 localhost metabase: 05-14 12:01:23 #033[1mINFO metabase.plugins#033[0m :: #033[35mLoading plugin /plugins/sqlserver.metabase-driver.jar... πŸ”Œ#033[0m
May 14 17:01:23 localhost metabase: 05-14 12:01:23 #033[1mINFO metabase.plugins#033[0m :: #033[35mLoading plugin /plugins/sqlite.metabase-driver.jar... πŸ”Œ#033[0m
May 14 17:01:23 localhost metabase: 05-14 12:01:23 #033[1mINFO metabase.plugins#033[0m :: #033[35mLoading plugin /plugins/vertica.metabase-driver.jar... πŸ”Œ#033[0m
May 14 17:01:23 localhost metabase: 05-14 12:01:23 #033[1mINFO metabase.plugins#033[0m :: #033[35mLoading plugin /plugins/redshift.metabase-driver.jar... πŸ”Œ#033[0m
May 14 17:01:23 localhost metabase: 05-14 12:01:23 #033[1mINFO metabase.plugins#033[0m :: #033[35mLoading plugin /plugins/presto.metabase-driver.jar... πŸ”Œ#033[0m
May 14 17:01:23 localhost metabase: 05-14 12:01:23 #033[1mINFO metabase.plugins#033[0m :: #033[35mLoading plugin /plugins/druid.metabase-driver.jar... πŸ”Œ#033[0m
May 14 17:01:23 localhost metabase: 05-14 12:01:23 #033[1mINFO metabase.plugins#033[0m :: #033[35mLoading plugin /plugins/mongo.metabase-driver.jar... πŸ”Œ#033[0m
May 14 17:01:23 localhost metabase: 05-14 12:01:23 #033[1mINFO metabase.plugins#033[0m :: #033[35mLoading plugin /plugins/google.metabase-driver.jar... πŸ”Œ#033[0m
May 14 17:01:23 localhost metabase: 05-14 12:01:23 #033[1mINFO metabase.plugins#033[0m :: #033[35mLoading plugin /plugins/oracle.metabase-driver.jar... πŸ”Œ#033[0m
May 14 17:01:23 localhost metabase: 05-14 12:01:23 #033[1mINFO metabase.plugins#033[0m :: #033[35mLoading plugin /plugins/snowflake.metabase-driver.jar... πŸ”Œ#033[0m
May 14 17:01:23 localhost metabase: 05-14 12:01:23 #033[1mINFO metabase.plugins#033[0m :: #033[35mLoading plugin /plugins/googleanalytics.metabase-driver.jar... πŸ”Œ#033[0m
May 14 17:01:23 localhost metabase: 05-14 12:01:23 #033[1mINFO driver.sparksql#033[0m :: Found metabase.driver.FixedHiveDriver.
May 14 17:01:23 localhost metabase: 05-14 12:01:23 #033[1mINFO driver.sparksql#033[0m :: Successfully registered metabase.driver.FixedHiveDriver with JDBC.
May 14 17:01:24 localhost metabase: WARNING: any? already refers to: #'clojure.core/any? in namespace: monger.collection, being replaced by: #'monger.collection/any?
May 14 17:01:24 localhost metabase: 05-14 12:01:24 #033[1mINFO metabase.core#033[0m :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
May 14 17:01:24 localhost metabase: 05-14 12:01:24 #033[1mINFO metabase.db#033[0m :: #033[36mVerifying h2 Database Connection ...#033[0m
May 14 17:01:24 localhost metabase: 05-14 12:01:24 #033[1mINFO metabase.db#033[0m :: Verify Database Connection ...  βœ…
May 14 17:01:24 localhost metabase: 05-14 12:01:24 #033[1mINFO metabase.db#033[0m :: Running Database Migrations...
May 14 17:01:24 localhost metabase: 05-14 12:01:24 #033[1mINFO metabase.db#033[0m :: Setting up Liquibase...
May 14 17:01:24 localhost metabase: 05-14 12:01:24 #033[1mINFO metabase.db#033[0m :: Liquibase is ready.
May 14 17:01:24 localhost metabase: 05-14 12:01:24 #033[1mINFO metabase.db#033[0m :: Checking if Database has unrun migrations...
May 14 17:01:26 localhost metabase: 05-14 12:01:26 #033[1mINFO metabase.db#033[0m :: Database Migrations Current ...  βœ…
May 14 17:01:26 localhost metabase: 05-14 12:01:26 #033[1mINFO db.migrations#033[0m :: Running all necessary data migrations, this may take a minute.
May 14 17:01:26 localhost metabase: 05-14 12:01:26 #033[1mINFO db.migrations#033[0m :: Finished running data migrations.
May 14 17:01:26 localhost metabase: 05-14 12:01:26 #033[1mINFO metabase.events#033[0m :: Starting events listener: #033[34mmetabase.events.notifications#033[0m πŸ‘‚
May 14 17:01:26 localhost metabase: 05-14 12:01:26 #033[1mINFO metabase.events#033[0m :: Starting events listener: #033[34mmetabase.events.metabot-lifecycle#033[0m πŸ‘‚
May 14 17:01:26 localhost metabase: 05-14 12:01:26 #033[1mINFO metabase.events#033[0m :: Starting events listener: #033[34mmetabase.events.dependencies#033[0m πŸ‘‚
May 14 17:01:26 localhost metabase: 05-14 12:01:26 #033[1mINFO metabase.events#033[0m :: Starting events listener: #033[34mmetabase.events.activity-feed#033[0m πŸ‘‚
May 14 17:01:26 localhost metabase: 05-14 12:01:26 #033[1mINFO metabase.events#033[0m :: Starting events listener: #033[34mmetabase.events.last-login#033[0m πŸ‘‚
May 14 17:01:26 localhost metabase: 05-14 12:01:26 #033[1mINFO metabase.events#033[0m :: Starting events listener: #033[34mmetabase.events.revision#033[0m πŸ‘‚
May 14 17:01:26 localhost metabase: 05-14 12:01:26 #033[1mINFO metabase.events#033[0m :: Starting events listener: #033[34mmetabase.events.sync-database#033[0m πŸ‘‚
May 14 17:01:26 localhost metabase: 05-14 12:01:26 #033[1mINFO metabase.events#033[0m :: Starting events listener: #033[34mmetabase.events.view-log#033[0m πŸ‘‚
May 14 17:01:26 localhost metabase: 05-14 12:01:26 #033[1mINFO metabase.events#033[0m :: Starting events listener: #033[34mmetabase.events.driver-notifications#033[0m πŸ‘‚

I see that I have two files - metabase.db.mv.db and metabase.db.trace.db. If I cant fix the problem is it possible to retrieve the saved quieries?

Any help will be highly appreciated!

Best regards!

#2

Hi @petar777
It sounds like the H2 database has become corrupted. You can try to repair it, but it’s probably easier to recover a backup instead.
The H2 database is metabase.db.mv.db
And you can ignore metabase.db.trace.db, it’s a debug log about H2 issues.
Try to see if you can migrate to Postgres or MariaDB/MySQL:
https://www.metabase.com/docs/latest/operations-guide/start.html#migrating-from-using-the-h2-database-to-mysql-or-postgres