Hi ,
I am trying to migrate from H2 to mysql after installation of metabase .I was able to connect to both DBs (default and Mysql). I am using commandline prompt to set the env variables ,ending up with error kindly help metabase is not loading also the metabse.db.mv file is still present
Below are my specifications
Metabase - [v0.36.6 (Latest)]
mysql -8.0.21
OS-Windows 10
Cmd line to run the commands and jar file
I ran the below commands
SET MB_DB_TYPE=mysql
SET MB_DB_DBNAME=metabase
SET MB_DB_PORT=3306
SET MB_DB_USER=root
SET MB_DB_PASS=Welcome#123
SET MB_DB_HOST=localhost
java -jar C:\Metabase\metabase.jar
Logs are as below
C:\Metabase>java -jar C:\Metabase\metabase.jar
09-28 20:52:06 e[1mINFO metabase.utile[0m :: Loading Metabase…
09-28 20:52:06 e[1mINFO metabase.utile[0m :: Maximum memory available to JVM: 862.5 MB
WARNING: not-empty already refers to: #'clojure.core/not-empty in namespace: metabase.mbql.schema, being replaced by: #'metabase.mbql.schema/not-empty
09-28 20:52:17 e[1mINFO util.encryptione[0m :: 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
09-28 20:52:24 e[1mWARN metabase.coree[0m :: WARNING: You have enabled namespace tracing, which could log sensitive information like db passwords.
09-28 20:52:24 e[1mINFO metabase.coree[0m :: Starting Metabase in STANDALONE mode
09-28 20:52:24 e[1mINFO metabase.servere[0m :: Launching Embedded Jetty Webserver with config:
{:port 3000}
09-28 20:52:24 e[1mINFO metabase.coree[0m :: Starting Metabase version v0.36.6 (cb258fb release-0.36.x) …
09-28 20:52:24 e[1mINFO metabase.coree[0m :: System info:
{“file.encoding” “Cp1252”,
“java.runtime.name” “Java™ SE Runtime Environment”,
“java.runtime.version” “1.8.0_261-b12”,
“java.vendor” “Oracle Corporation”,
“java.vendor.url” “http://java.oracle.com/”,
“java.version” “1.8.0_261”,
“java.vm.name” “Java HotSpot™ 64-Bit Server VM”,
“java.vm.version” “25.261-b12”,
“os.name” “Windows 10”,
“os.version” “10.0”,
“user.language” “en”,
“user.timezone” “Asia/Calcutta”}
09-28 20:52:24 e[1mINFO metabase.pluginse[0m :: Loading plugins in C:\Metabase\plugins…
09-28 20:52:25 e[1mINFO plugins.dependenciese[0m :: Plugin ‘Metabase BigQuery Driver’ depends on plugin ‘Metabase Google Drivers Shared Dependencies’
09-28 20:52:25 e[1mINFO plugins.dependenciese[0m :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? false
09-28 20:52:25 e[1mINFO plugins.dependenciese[0m :: Plugins with unsatisfied deps: [“Metabase BigQuery Driver”]
09-28 20:52:25 e[1mDEBUG plugins.lazy-loaded-drivere[0m :: Registering lazy loading driver :druid…
09-28 20:52:25 e[1mINFO driver.imple[0m :: Registered driver :druid
09-28 20:52:25 e[1mDEBUG plugins.lazy-loaded-drivere[0m :: Registering lazy loading driver :google…
09-28 20:52:25 e[1mINFO driver.imple[0m :: Registered abstract driver :google
09-28 20:52:25 e[1mINFO plugins.dependenciese[0m :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
09-28 20:52:25 e[1mDEBUG plugins.initializee[0m :: Dependencies satisfied; these plugins will now be loaded: [“Metabase BigQuery Driver”]
09-28 20:52:25 e[1mWARN plugins.lazy-loaded-drivere[0m :: Warning: plugin manifest for :bigquery does not include connection properties
09-28 20:52:25 e[1mDEBUG plugins.lazy-loaded-drivere[0m :: Registering lazy loading driver :bigquery…
09-28 20:52:25 e[1mINFO driver.imple[0m :: Registered abstract driver :sql
Load driver :sql took 337.5 ms
09-28 20:52:25 e[1mINFO driver.imple[0m :: Registered driver :bigquery (parents: [:sql :google])
09-28 20:52:25 e[1mINFO plugins.dependenciese[0m :: Plugin ‘Metabase Google Analytics Driver’ depends on plugin ‘Metabase Google Drivers Shared Dependencies’
09-28 20:52:25 e[1mINFO plugins.dependenciese[0m :: Metabase Google Analytics Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
09-28 20:52:25 e[1mDEBUG plugins.lazy-loaded-drivere[0m :: Registering lazy loading driver :googleanalytics…
09-28 20:52:25 e[1mINFO driver.imple[0m :: Registered driver :googleanalytics (parents: [:google])
09-28 20:52:26 e[1mDEBUG plugins.lazy-loaded-drivere[0m :: Registering lazy loading driver :mongo…
09-28 20:52:26 e[1mINFO driver.imple[0m :: Registered driver :mongo
09-28 20:52:26 e[1mINFO plugins.dependenciese[0m :: 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.
09-28 20:52:26 e[1mINFO plugins.dependenciese[0m :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
09-28 20:52:26 e[1mINFO plugins.dependenciese[0m :: Plugins with unsatisfied deps: [“Metabase Oracle Driver”]
09-28 20:52:26 e[1mDEBUG plugins.lazy-loaded-drivere[0m :: Registering lazy loading driver :presto…
09-28 20:52:26 e[1mINFO driver.imple[0m :: Registered driver :presto (parents: [:sql])
09-28 20:52:26 e[1mDEBUG plugins.lazy-loaded-drivere[0m :: Registering lazy loading driver :redshift…
09-28 20:52:26 e[1mINFO driver.imple[0m :: Registered abstract driver :sql-jdbc (parents: [:sql])
Load driver :sql-jdbc took 21.4 ms
09-28 20:52:26 e[1mINFO driver.imple[0m :: Registered driver :postgres (parents: [:sql-jdbc])
Load driver :postgres took 161.6 ms
09-28 20:52:26 e[1mINFO driver.imple[0m :: Registered driver :redshift (parents: [:postgres])
09-28 20:52:26 e[1mDEBUG plugins.lazy-loaded-drivere[0m :: Registering lazy loading driver :snowflake…
09-28 20:52:26 e[1mINFO driver.imple[0m :: Registered driver :snowflake (parents: [:sql-jdbc])
09-28 20:52:26 e[1mDEBUG plugins.lazy-loaded-drivere[0m :: Registering lazy loading driver :hive-like…
09-28 20:52:26 e[1mINFO driver.imple[0m :: Registered abstract driver :hive-like (parents: [:sql-jdbc])
09-28 20:52:26 e[1mDEBUG plugins.lazy-loaded-drivere[0m :: Registering lazy loading driver :sparksql…
09-28 20:52:26 e[1mINFO driver.imple[0m :: Registered driver :sparksql (parents: [:hive-like])
09-28 20:52:26 e[1mDEBUG plugins.lazy-loaded-drivere[0m :: Registering lazy loading driver :sqlite…
09-28 20:52:26 e[1mINFO driver.imple[0m :: Registered driver :sqlite (parents: [:sql-jdbc])
09-28 20:52:26 e[1mDEBUG plugins.lazy-loaded-drivere[0m :: Registering lazy loading driver :sqlserver…
09-28 20:52:26 e[1mINFO driver.imple[0m :: Registered driver :sqlserver (parents: [:sql-jdbc])
09-28 20:52:26 e[1mINFO plugins.dependenciese[0m :: 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.
09-28 20:52:26 e[1mINFO plugins.dependenciese[0m :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
09-28 20:52:26 e[1mINFO plugins.dependenciese[0m :: Plugins with unsatisfied deps: [“Metabase Vertica Driver” “Metabase Oracle Driver”]
09-28 20:52:26 e[1mINFO driver.imple[0m :: Registered driver :h2 (parents: [:sql-jdbc])
09-28 20:52:26 e[1mINFO driver.imple[0m :: Registered driver :mysql (parents: [:sql-jdbc])
09-28 20:52:26 e[1mINFO metabase.coree[0m :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute…
09-28 20:52:26 e[1mINFO metabase.dbe[0m :: Verifying mysql Database Connection …
09-28 20:52:26 e[1mINFO driver.imple[0m :: Initializing driver :sql…
09-28 20:52:26 e[1mINFO driver.imple[0m :: Initializing driver :sql-jdbc…
09-28 20:52:26 e[1mINFO driver.imple[0m :: Initializing driver :mysql…
09-28 20:52:26 e[1mERROR driver.utile[0m :: Database connection error
java.sql.SQLSyntaxErrorException: Could not connect to address=(host=localhost)(port=3306)(type=master) : (conn=1927) Unknown database ‘metabase’
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:192)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1372)
at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:635)
at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150)
at org.mariadb.jdbc.Driver.connect(Driver.java:89)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at clojure.java.jdbc$get_driver_connection.invokeStatic(jdbc.clj:271)
at clojure.java.jdbc$get_driver_connection.invoke(jdbc.clj:250)
at clojure.java.jdbc$get_connection.invokeStatic(jdbc.clj:411)
at clojure.java.jdbc$get_connection.invoke(jdbc.clj:274)
at clojure.java.jdbc$db_query_with_resultset_STAR_.invokeStatic(jdbc.clj:1111)
at clojure.java.jdbc$db_query_with_resultset_STAR_.invoke(jdbc.clj:1093)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1182)
at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1160)
at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
at metabase.driver.sql_jdbc.connection$can_connect_QMARK_.invokeStatic(connection.clj:159)
at metabase.driver.sql_jdbc.connection$can_connect_QMARK_.invoke(connection.clj:154)
at metabase.driver.sql_jdbc$fn__73927.invokeStatic(sql_jdbc.clj:36)
at metabase.driver.sql_jdbc$fn__73927.invoke(sql_jdbc.clj:34)
at metabase.driver.mysql$fn__73058.invokeStatic(mysql.clj:76)
at metabase.driver.mysql$fn__73058.invoke(mysql.clj:72)
at clojure.lang.MultiFn.invoke(MultiFn.java:234)
at metabase.driver.util$can_connect_with_details_QMARK_$fn__22512.invoke(util.clj:35)
at metabase.util$do_with_timeout$fn__10225.invoke(util.clj:310)
at clojure.core$binding_conveyor_fn$fn__5754.invoke(core.clj:2030)
at clojure.lang.AFn.call(AFn.java:18)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLSyntaxErrorException: (conn=1927) Unknown database ‘metabase’
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:187)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:769)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:546)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1367)
… 30 more
09-28 20:52:26 e[1mERROR metabase.coree[0m :: Metabase Initialization FAILED
java.lang.Exception: Could not connect to address=(host=localhost)(port=3306)(type=master) : (conn=1927) Unknown database ‘metabase’
at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(util.clj:40)
at metabase.driver.util$can_connect_with_details_QMARK_.doInvoke(util.clj:23)
at clojure.lang.RestFn.invoke(RestFn.java:442)
at clojure.lang.Var.invoke(Var.java:393)
at metabase.db$fn__21781$verify_db_connection__21790$fn__21793$fn__21794.invoke(db.clj:309)
at metabase.db$fn__21781$verify_db_connection__21790$fn__21793.invoke(db.clj:308)
at metabase.db$fn__21781$verify_db_connection__21790.invoke(db.clj:300)
at metabase.db$fn__21781$verify_db_connection__21790$fn__21791.invoke(db.clj:303)
at metabase.db$fn__21781$verify_db_connection__21790.invoke(db.clj:300)
at metabase.db$setup_db_BANG__STAR_$fn__21829.invoke(db.clj:345)
at metabase.util$do_with_us_locale.invokeStatic(util.clj:656)
at metabase.util$do_with_us_locale.invoke(util.clj:642)
at metabase.db$setup_db_BANG__STAR_.invokeStatic(db.clj:344)
at metabase.db$setup_db_BANG__STAR_.invoke(db.clj:339)
at metabase.db$setup_db_from_env_BANG_.invokeStatic(db.clj:358)
at metabase.db$setup_db_from_env_BANG_.invoke(db.clj:351)
at metabase.db$setup_db_BANG_$fn__21834.invoke(db.clj:368)
at metabase.db$setup_db_BANG_.invokeStatic(db.clj:366)
at metabase.db$setup_db_BANG_.invoke(db.clj:361)
at metabase.core$init_BANG_.invokeStatic(core.clj:75)
at metabase.core$init_BANG_.invoke(core.clj:54)
at metabase.core$start_normally.invokeStatic(core.clj:119)
at metabase.core$start_normally.invoke(core.clj:113)
at metabase.core$main.invokeStatic(core.clj:152)
at metabase.core$main.doInvoke(core.clj:146)
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.core.main(Unknown Source)
Caused by: java.sql.SQLSyntaxErrorException: Could not connect to address=(host=localhost)(port=3306)(type=master) : (conn=1927) Unknown database ‘metabase’
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:192)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1372)
at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:635)
at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150)
at org.mariadb.jdbc.Driver.connect(Driver.java:89)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at clojure.java.jdbc$get_driver_connection.invokeStatic(jdbc.clj:271)
at clojure.java.jdbc$get_driver_connection.invoke(jdbc.clj:250)
at clojure.java.jdbc$get_connection.invokeStatic(jdbc.clj:411)
at clojure.java.jdbc$get_connection.invoke(jdbc.clj:274)
at clojure.java.jdbc$db_query_with_resultset_STAR.invokeStatic(jdbc.clj:1111)
at clojure.java.jdbc$db_query_with_resultset_STAR.invoke(jdbc.clj:1093)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1182)
at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1160)
at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
at metabase.driver.sql_jdbc.connection$can_connect_QMARK_.invokeStatic(connection.clj:159)
at metabase.driver.sql_jdbc.connection$can_connect_QMARK_.invoke(connection.clj:154)
at metabase.driver.sql_jdbc$fn__73927.invokeStatic(sql_jdbc.clj:36)
at metabase.driver.sql_jdbc$fn__73927.invoke(sql_jdbc.clj:34)
at metabase.driver.mysql$fn__73058.invokeStatic(mysql.clj:76)
at metabase.driver.mysql$fn__73058.invoke(mysql.clj:72)
at clojure.lang.MultiFn.invoke(MultiFn.java:234)
at metabase.driver.util$can_connect_with_details_QMARK_$fn__22512.invoke(util.clj:35)
at metabase.util$do_with_timeout$fn__10225.invoke(util.clj:310)
at clojure.core$binding_conveyor_fn$fn__5754.invoke(core.clj:2030)
at clojure.lang.AFn.call(AFn.java:18)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLSyntaxErrorException: (conn=1927) Unknown database ‘metabase’
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:187)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:769)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:546)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1367)
… 30 more
09-28 20:52:26 e[1mINFO metabase.coree[0m :: Metabase Shutting Down …
09-28 20:52:26 e[1mINFO metabase.servere[0m :: Shutting Down Embedded Jetty Webserver
09-28 20:52:26 e[1mINFO metabase.coree[0m :: Metabase Shutdown COMPLETE