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!