Hi,
Today I updated the metabase docker to the latest version. In another docker we have a mariadb (Version: '10.7.3-MariaDB-1:10.7.3+maria~focal) using eht 3306 port.
So, I updated the metabase docker and use this command to run it:
docker run -d -p 3000:3000
-e "MB_DB_TYPE=mysql"
-e "MB_DB_CONNECTION_URI=mysql://172.20.5.110:3306/metabase?user=root&password=xxxxx"
-e "MB_PLUGINS_DIR=/app/plugins"
--name metabase metabase/metabase
The host has the 172.20.5.110 IP.
Metabase docker has 172.17.0.4 as the docker network IP.
MariaDB docker has 172.17.0.3 as the docker network IP.
I run this command and it doesn't work:
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: environ value jdk-11.0.16.1+1 for key :java-version has been overwritten with 11.0.16.1
WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.
2022-09-28 14:27:49,406 INFO metabase.util :: Maximum memory available to JVM: 1.5 GB
2022-09-28 14:27:54,206 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-28 14:28:02,874 INFO driver.impl :: Registered abstract driver :sql 🚚
2022-09-28 14:28:02,882 INFO metabase.util :: ⮦ Load driver :sql took 230.4 ms
2022-09-28 14:28:02,905 INFO driver.impl :: Registered abstract driver :sql-jdbc (parents: [:sql]) 🚚
2022-09-28 14:28:02,912 INFO metabase.util :: Load driver :sql-jdbc took 269.2 ms
2022-09-28 14:28:02,913 INFO driver.impl :: Registered driver :h2 (parents: [:sql-jdbc]) 🚚
2022-09-28 14:28:03,005 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc]) 🚚
2022-09-28 14:28:03,062 INFO driver.impl :: Registered driver :postgres (parents: [:sql-jdbc]) 🚚
2022-09-28 14:28:07,638 INFO metabase.core ::
Metabase v0.44.3 (7d50282 release-x.44.x)
Copyright © 2022 Metabase, Inc.
Metabase Enterprise Edition extensions are NOT PRESENT.
2022-09-28 14:28:07,664 INFO metabase.core :: Starting Metabase in STANDALONE mode
2022-09-28 14:28:07,752 INFO metabase.server :: Launching Embedded Jetty Webserver with config:
{:port 3000, :host "0.0.0.0"}
2022-09-28 14:28:07,845 INFO metabase.core :: Starting Metabase version v0.44.3 (7d50282 release-x.44.x) ...
2022-09-28 14:28:07,950 INFO metabase.core :: System info:
{"file.encoding" "UTF-8",
"java.runtime.name" "OpenJDK Runtime Environment",
"java.runtime.version" "11.0.16.1+1",
"java.vendor" "Eclipse Adoptium",
"java.vendor.url" "https://adoptium.net/",
"java.version" "11.0.16.1",
"java.vm.name" "OpenJDK 64-Bit Server VM",
"java.vm.version" "11.0.16.1+1",
"os.name" "Linux",
"os.version" "5.4.0-120-generic",
"user.language" "en",
"user.timezone" "GMT"}
2022-09-28 14:28:07,965 WARN metabase.plugins :: Metabase cannot use the plugins directory /app/plugins
Please make sure the directory exists and that Metabase has permission to write to it. You can change the directory Metabase uses for modules by setting the environment variable MB_PLUGINS_DIR. Falling back to a temporary directory for now.
java.nio.file.AccessDeniedException: /app/plugins
at java.base/sun.nio.fs.UnixException.translateToIOException(Unknown Source)
at java.base/sun.nio.fs.UnixException.rethrowAsIOException(Unknown Source)
at java.base/sun.nio.fs.UnixException.rethrowAsIOException(Unknown Source)
at java.base/sun.nio.fs.UnixFileSystemProvider.createDirectory(Unknown Source)
at java.base/java.nio.file.Files.createDirectory(Unknown Source)
at metabase.util.files$create_dir_if_not_exists_BANG_.invokeStatic(files.clj:63)
at metabase.util.files$create_dir_if_not_exists_BANG_.invoke(files.clj:59)
at metabase.plugins$fn__83267$fn__83268.invoke(plugins.clj:27)
at clojure.lang.Delay.deref(Delay.java:42)
at clojure.core$deref.invokeStatic(core.clj:2337)
at clojure.core$deref.invoke(core.clj:2323)
at metabase.plugins$plugins_dir.invokeStatic(plugins.clj:50)
at metabase.plugins$plugins_dir.invoke(plugins.clj:50)
at metabase.plugins$load_BANG_.invokeStatic(plugins.clj:158)
at metabase.plugins$load_BANG_.invoke(plugins.clj:157)
at metabase.plugins$fn__83366$fn__83367.invoke(plugins.clj:165)
at clojure.lang.Delay.deref(Delay.java:42)
at clojure.core$deref.invokeStatic(core.clj:2337)
at clojure.core$deref.invoke(core.clj:2323)
at metabase.plugins$load_plugins_BANG_.invokeStatic(plugins.clj:167)
at metabase.plugins$load_plugins_BANG_.invoke(plugins.clj:167)
at metabase.core$init_BANG__STAR_.invokeStatic(core.clj:93)
at metabase.core$init_BANG__STAR_.invoke(core.clj:81)
at metabase.core$init_BANG_.invokeStatic(core.clj:138)
at metabase.core$init_BANG_.invoke(core.clj:133)
at metabase.core$start_normally.invokeStatic(core.clj:150)
at metabase.core$start_normally.invoke(core.clj:144)
at metabase.core$_main.invokeStatic(core.clj:183)
at metabase.core$_main.doInvoke(core.clj:177)
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)
2022-09-28 14:28:07,982 INFO metabase.plugins :: Loading plugins in /tmp...
2022-09-28 14:28:08,262 INFO util.files :: Extract file /modules/sparksql.metabase-driver.jar -> /tmp/sparksql.metabase-driver.jar
2022-09-28 14:28:08,394 INFO util.files :: Extract file /modules/sqlserver.metabase-driver.jar -> /tmp/sqlserver.metabase-driver.jar
2022-09-28 14:28:08,413 INFO util.files :: Extract file /modules/presto-jdbc.metabase-driver.jar -> /tmp/presto-jdbc.metabase-driver.jar
2022-09-28 14:28:08,534 INFO util.files :: Extract file /modules/sqlite.metabase-driver.jar -> /tmp/sqlite.metabase-driver.jar
2022-09-28 14:28:08,585 INFO util.files :: Extract file /modules/vertica.metabase-driver.jar -> /tmp/vertica.metabase-driver.jar
2022-09-28 14:28:08,587 INFO util.files :: Extract file /modules/redshift.metabase-driver.jar -> /tmp/redshift.metabase-driver.jar
2022-09-28 14:28:08,601 INFO util.files :: Extract file /modules/presto.metabase-driver.jar -> /tmp/presto.metabase-driver.jar
2022-09-28 14:28:08,603 INFO util.files :: Extract file /modules/druid.metabase-driver.jar -> /tmp/druid.metabase-driver.jar
2022-09-28 14:28:08,611 INFO util.files :: Extract file /modules/mongo.metabase-driver.jar -> /tmp/mongo.metabase-driver.jar
2022-09-28 14:28:08,644 INFO util.files :: Extract file /modules/oracle.metabase-driver.jar -> /tmp/oracle.metabase-driver.jar
2022-09-28 14:28:08,647 INFO util.files :: Extract file /modules/snowflake.metabase-driver.jar -> /tmp/snowflake.metabase-driver.jar
2022-09-28 14:28:09,019 INFO util.files :: Extract file /modules/googleanalytics.metabase-driver.jar -> /tmp/googleanalytics.metabase-driver.jar
2022-09-28 14:28:09,048 INFO util.files :: Extract file /modules/bigquery-cloud-sdk.metabase-driver.jar -> /tmp/bigquery-cloud-sdk.metabase-driver.jar
2022-09-28 14:28:09,177 INFO util.files :: Extract file /modules/presto-common.metabase-driver.jar -> /tmp/presto-common.metabase-driver.jar
2022-09-28 14:28:09,483 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :bigquery-cloud-sdk...
2022-09-28 14:28:09,500 INFO driver.impl :: Registered driver :bigquery-cloud-sdk (parents: [:sql]) 🚚
2022-09-28 14:28:09,511 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :googleanalytics...
2022-09-28 14:28:09,512 INFO driver.impl :: Registered driver :googleanalytics 🚚
2022-09-28 14:28:09,523 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :redshift...
2022-09-28 14:28:09,524 INFO driver.impl :: Registered driver :redshift (parents: [:postgres]) 🚚
2022-09-28 14:28:09,537 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-28 14:28:09,539 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
2022-09-28 14:28:09,541 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Oracle Driver"]
2022-09-28 14:28:09,581 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :snowflake...
2022-09-28 14:28:09,582 INFO driver.impl :: Registered driver :snowflake (parents: [:sql-jdbc]) 🚚
2022-09-28 14:28:09,609 INFO plugins.dependencies :: Plugin 'Metabase Presto JDBC Driver' depends on plugin 'Presto Common Driver'
2022-09-28 14:28:09,619 INFO plugins.dependencies :: Metabase Presto JDBC Driver dependency {:plugin Presto Common Driver} satisfied? false
2022-09-28 14:28:09,621 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Oracle Driver" "Metabase Presto JDBC Driver"]
2022-09-28 14:28:09,640 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :mongo...
2022-09-28 14:28:09,644 INFO driver.impl :: Registered driver :mongo 🚚
2022-09-28 14:28:09,653 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :druid...
2022-09-28 14:28:09,658 INFO driver.impl :: Registered driver :druid 🚚
2022-09-28 14:28:09,668 INFO plugins.dependencies :: Plugin 'Metabase Presto Driver' depends on plugin 'Presto Common Driver'
2022-09-28 14:28:09,669 INFO plugins.dependencies :: Metabase Presto Driver dependency {:plugin Presto Common Driver} satisfied? false
2022-09-28 14:28:09,671 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Presto Driver" "Metabase Oracle Driver" "Metabase Presto JDBC Driver"]
2022-09-28 14:28:09,680 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlserver...
2022-09-28 14:28:09,681 INFO driver.impl :: Registered driver :sqlserver (parents: [:sql-jdbc]) 🚚
2022-09-28 14:28:09,689 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto-common...
2022-09-28 14:28:09,690 INFO driver.impl :: Registered abstract driver :presto-common 🚚
2022-09-28 14:28:09,692 INFO plugins.dependencies :: Metabase Presto Driver dependency {:plugin Presto Common Driver} satisfied? true
2022-09-28 14:28:09,694 INFO plugins.dependencies :: Metabase Presto JDBC Driver dependency {:plugin Presto Common Driver} satisfied? true
2022-09-28 14:28:09,695 DEBUG plugins.initialize :: Dependencies satisfied; these plugins will now be loaded: ["Metabase Presto JDBC Driver" "Metabase Presto Driver"]
2022-09-28 14:28:09,696 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto-jdbc...
2022-09-28 14:28:09,698 INFO driver.impl :: Registered driver :presto-jdbc (parents: [:presto-common]) 🚚
2022-09-28 14:28:09,704 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto...
2022-09-28 14:28:09,708 INFO driver.impl :: Registered driver :presto (parents: [:presto-common]) 🚚
2022-09-28 14:28:09,725 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :hive-like...
2022-09-28 14:28:09,727 INFO driver.impl :: Registered abstract driver :hive-like (parents: [:sql-jdbc]) 🚚
2022-09-28 14:28:09,727 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sparksql...
2022-09-28 14:28:09,729 INFO driver.impl :: Registered driver :sparksql (parents: [:hive-like]) 🚚
2022-09-28 14:28:09,740 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-28 14:28:09,741 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
2022-09-28 14:28:09,741 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Oracle Driver" "Metabase Vertica Driver"]
2022-09-28 14:28:09,753 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlite...
2022-09-28 14:28:09,758 INFO driver.impl :: Registered driver :sqlite (parents: [:sql-jdbc]) 🚚
2022-09-28 14:28:09,760 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
2022-09-28 14:28:09,766 INFO db.setup :: Verifying mysql Database Connection ...
2022-09-28 14:45:58,758 ERROR metabase.core :: Metabase Initialization FAILED
clojure.lang.ExceptionInfo: Unable to connect to Metabase mysql DB. {}
at metabase.db.setup$fn__35456$verify_db_connection__35461$fn__35462$fn__35463.invoke(setup.clj:99)
at metabase.db.setup$fn__35456$verify_db_connection__35461$fn__35462.invoke(setup.clj:97)
at metabase.db.setup$fn__35456$verify_db_connection__35461.invoke(setup.clj:89)
at metabase.db.setup$fn__35538$setup_db_BANG___35543$fn__35544$fn__35547$fn__35548.invoke(setup.clj:144)
at metabase.util$do_with_us_locale.invokeStatic(util.clj:716)
at metabase.util$do_with_us_locale.invoke(util.clj:702)
at metabase.db.setup$fn__35538$setup_db_BANG___35543$fn__35544$fn__35547.invoke(setup.clj:143)
at metabase.db.setup$fn__35538$setup_db_BANG___35543$fn__35544.invoke(setup.clj:142)
at metabase.db.setup$fn__35538$setup_db_BANG___35543.invoke(setup.clj:136)
at metabase.db$setup_db_BANG_$fn__35573.invoke(db.clj:65)
at metabase.db$setup_db_BANG_.invokeStatic(db.clj:60)
at metabase.db$setup_db_BANG_.invoke(db.clj:51)
at metabase.core$init_BANG__STAR_.invokeStatic(core.clj:98)
at metabase.core$init_BANG__STAR_.invoke(core.clj:81)
at metabase.core$init_BANG_.invokeStatic(core.clj:138)
at metabase.core$init_BANG_.invoke(core.clj:133)
at metabase.core$start_normally.invokeStatic(core.clj:150)
at metabase.core$start_normally.invoke(core.clj:144)
at metabase.core$_main.invokeStatic(core.clj:183)
at metabase.core$_main.doInvoke(core.clj:177)
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.SQLException: Connections could not be acquired from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
at clojure.java.jdbc$get_connection.invokeStatic(jdbc.clj:372)
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_with_spec_QMARK_.invokeStatic(connection.clj:266)
at metabase.driver.sql_jdbc.connection$can_connect_with_spec_QMARK_.invoke(connection.clj:263)
at metabase.db.setup$fn__35456$verify_db_connection__35461$fn__35462$fn__35463.invoke(setup.clj:97)
... 23 more
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1507)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)
... 35 more
Caused by: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=2022)(port=3306)(type=master) : Socket fail to connect to host:2022, port:3306. connect timed out
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:197)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1394)
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/java.sql.DriverManager.getConnection(Unknown Source)
at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
at metabase.db.data_source.DataSource.getConnection(data_source.clj:25)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:161)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:147)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:202)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Caused by: java.sql.SQLNonTransientConnectionException: Socket fail to connect to host:2022, port:3306. connect timed out
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:188)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createSocket(AbstractConnectProtocol.java:257)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:524)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1389)
... 14 more
Caused by: java.net.SocketTimeoutException: connect timed out
at java.base/java.net.PlainSocketImpl.socketConnect(Native Method)
at java.base/java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.base/java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.base/java.net.SocksSocketImpl.connect(Unknown Source)
at java.base/java.net.Socket.connect(Unknown Source)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createSocket(AbstractConnectProtocol.java:252)
... 16 more
2022-09-28 14:45:58,796 INFO metabase.core :: Metabase Shutting Down ...
2022-09-28 14:45:58,799 INFO metabase.server :: Shutting Down Embedded Jetty Webserver
2022-09-28 14:45:58,821 INFO metabase.core :: Metabase Shutdown COMPLETE
If I try to connect from inside the metabase docker, when it's starting, to the 172.20.5.110 and 172.10.0.3 to the port 3306 and both work.
Anyone knows where is the problem?
Thanks in advance.