Hi all,
I’m new to Metabase and trying to integrate my MongoDB with Metabase without SSL.
I’m running Metabase on docker on my ec2 instance and my MongoDB is running locally on the same ec2 instance.
Here’s my Metabase logs from Admin -> Troubleshooting :
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 ERROR metabase.driver.util Database connection error
com.mongodb.MongoTimeoutException: Timed out after 3000 ms while waiting to connect. Client view of cluster state is {type=UNKNOWN, servers=[{address=172.17.0.1:27017, type=UNKNOWN, state=CONNECTING, exception={com.mongodb.MongoSocketWriteException: Exception sending message}, caused by {javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake}, caused by {java.io.EOFException: SSL peer shut down incorrectly}}]
at com.mongodb.internal.connection.BaseCluster.getDescription(BaseCluster.java:179)
at com.mongodb.internal.connection.SingleServerCluster.getDescription(SingleServerCluster.java:41)
at com.mongodb.client.internal.MongoClientDelegate.getConnectedClusterDescription(MongoClientDelegate.java:136)
at com.mongodb.client.internal.MongoClientDelegate.createClientSession(MongoClientDelegate.java:94)
at com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.getClientSession(MongoClientDelegate.java:249)
at com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.execute(MongoClientDelegate.java:172)
at com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.execute(MongoClientDelegate.java:161)
at com.mongodb.DB.executeCommand(DB.java:774)
at com.mongodb.DB.command(DB.java:520)
at com.mongodb.DB.command(DB.java:536)
at com.mongodb.DB.command(DB.java:491)
at monger.core$command.invokeStatic(core.clj:251)
at monger.core$command.invoke(core.clj:242)
at monger.command$db_stats.invokeStatic(command.clj:71)
at monger.command$db_stats.invoke(command.clj:69)
at metabase.driver.mongo$eval2471$fn__2472$f__1886__auto____2473.invoke(mongo.clj:52)
at metabase.driver.mongo.util$_with_mongo_connection$fn__1877.invoke(util.clj:225)
at metabase.util.ssh$do_with_ssh_tunnel.invokeStatic(ssh.clj:156)
at metabase.util.ssh$do_with_ssh_tunnel.invoke(ssh.clj:145)
at metabase.driver.mongo.util$_with_mongo_connection.invokeStatic(util.clj:219)
at metabase.driver.mongo.util$_with_mongo_connection.invoke(util.clj:214)
at metabase.driver.mongo$eval2471$fn__2472.invoke(mongo.clj:51)
at clojure.lang.MultiFn.invoke(MultiFn.java:234)
at metabase.driver.util$can_connect_with_details_QMARK_$fn__29139.invoke(util.clj:34)
at metabase.util$do_with_timeout$fn__15244.invoke(util.clj:322)
at clojure.core$binding_conveyor_fn$fn__5754.invoke(core.clj:2030)
at clojure.lang.AFn.call(AFn.java:18)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 ERROR metabase.api.database Cannot connect to Database
java.lang.Exception: Timed out after 3000 ms while waiting to connect. Client view of cluster state is {type=UNKNOWN, servers=[{address=172.17.0.1:27017, type=UNKNOWN, state=CONNECTING, exception={com.mongodb.MongoSocketWriteException: Exception sending message}, caused by {javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake}, caused by {java.io.EOFException: SSL peer shut down incorrectly}}]
at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(util.clj:39)
at metabase.driver.util$can_connect_with_details_QMARK_.doInvoke(util.clj:22)
at clojure.lang.RestFn.invoke(RestFn.java:442)
at metabase.api.database$test_database_connection.invokeStatic(database.clj:396)
at metabase.api.database$test_database_connection.doInvoke(database.clj:386)
at clojure.lang.RestFn.invoke(RestFn.java:425)
at metabase.api.database$fn__62230$test_connection_details__62235$fn__62236.invoke(database.clj:443)
at metabase.api.database$fn__62230$test_connection_details__62235.invoke(database.clj:425)
at metabase.api.database$fn__62260.invokeStatic(database.clj:462)
at metabase.api.database$fn__62260.invoke(database.clj:449)
at compojure.core$wrap_response$fn__1993.invoke(core.clj:160)
at compojure.core$wrap_route_middleware$fn__1977.invoke(core.clj:132)
at compojure.core$wrap_route_info$fn__1982.invoke(core.clj:139)
at compojure.core$wrap_route_matches$fn__1986.invoke(core.clj:151)
at compojure.core$routes$fn__2005$f__2006.invoke(core.clj:198)
at compojure.core$routes$fn__2005.invoke(core.clj:200)
at metabase.server.middleware.auth$enforce_authentication$fn__73836.invoke(auth.clj:14)
at compojure.core$routes$fn__2005$f__2006.invoke(core.clj:198)
at compojure.core$routes$fn__2005.invoke(core.clj:200)
at compojure.core$make_context$handler__2033.invoke(core.clj:287)
at compojure.core$make_context$fn__2035.invoke(core.clj:296)
at compojure.core$routes$fn__2005$f__2006.invoke(core.clj:198)
at compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007.invoke(core.clj:197)
at compojure.core$make_context$fn__2035.invoke(core.clj:297)
at compojure.core$routes$fn__2005$f__2006.invoke(core.clj:198)
at compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007.invoke(core.clj:197)
at compojure.core$make_context$fn__2035.invoke(core.clj:297)
at compojure.core$routes$fn__2005$f__2006.invoke(core.clj:198)
at compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007.invoke(core.clj:197)
at compojure.core$make_context$fn__2035.invoke(core.clj:297)
at compojure.core$routes$fn__2005$f__2006.invoke(core.clj:198)
at compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007.invoke(core.clj:197)
at compojure.core$make_context$fn__2035.invoke(core.clj:297)
at compojure.core$routes$fn__2005$f__2006.invoke(core.clj:198)
at compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007.invoke(core.clj:197)
at compojure.core$make_context$fn__2035.invoke(core.clj:297)
at compojure.core$routes$fn__2005$f__2006.invoke(core.clj:198)
at compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007.invoke(core.clj:197)
at compojure.core$make_context$fn__2035.invoke(core.clj:297)
at compojure.core$routes$fn__2005$f__2006.invoke(core.clj:198)
at compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007.invoke(core.clj:197)
at metabase.api.routes$fn__73957$fn__73959.invoke(routes.clj:69)
at compojure.core$routes$fn__2005$f__2006.invoke(core.clj:198)
at compojure.core$routes$fn__2005.invoke(core.clj:200)
at clojure.lang.AFn.applyToHelper(AFn.java:160)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:665)
at clojure.core$apply.invoke(core.clj:660)
at metabase.server.routes$fn__76139$fn__76140.doInvoke(routes.clj:57)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at compojure.core$routes$fn__2005$f__2006.invoke(core.clj:198)
at compojure.core$routes$fn__2005.invoke(core.clj:200)
at compojure.core$make_context$handler__2033.invoke(core.clj:287)
at compojure.core$make_context$fn__2035.invoke(core.clj:296)
at compojure.core$routes$fn__2005$f__2006.invoke(core.clj:198)
at compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__1986.invoke(core.clj:153)
at compojure.core$routes$fn__2005$f__2006.invoke(core.clj:198)
at compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__1986.invoke(core.clj:153)
at compojure.core$routes$fn__2005$f__2006.invoke(core.clj:198)
at compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__1986.invoke(core.clj:153)
at compojure.core$routes$fn__2005$f__2006.invoke(core.clj:198)
at compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007.invoke(core.clj:197)
at metabase.server.routes$fn__76127$fn__76129.invoke(routes.clj:41)
at compojure.core$routes$fn__2005$f__2006.invoke(core.clj:198)
at compojure.core$routes$fn__2005.invoke(core.clj:200)
at metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__73948.invoke(exceptions.clj:96)
at metabase.server.middleware.exceptions$catch_api_exceptions$fn__73945.invoke(exceptions.clj:84)
at metabase.server.middleware.log$log_api_call$fn__76055$fn__76056.invoke(log.clj:195)
at toucan.db$_do_with_call_counting.invokeStatic(db.clj:216)
at toucan.db$_do_with_call_counting.invoke(db.clj:209)
at metabase.server.middleware.log$log_api_call$fn__76055.invoke(log.clj:189)
at metabase.server.middleware.security$add_security_headers$fn__73911.invoke(security.clj:142)
at metabase.server.middleware.json$wrap_json_body$fn__75836.invoke(json.clj:62)
at metabase.server.middleware.json$wrap_streamed_json_response$fn__75854.invoke(json.clj:98)
at ring.middleware.keyword_params$wrap_keyword_params$fn__76396.invoke(keyword_params.clj:55)
at ring.middleware.params$wrap_params$fn__76412.invoke(params.clj:69)
at metabase.server.middleware.misc$maybe_set_site_url$fn__35081.invoke(misc.clj:58)
at metabase.server.middleware.session$bind_current_user$fn__41914$fn__41915.invoke(session.clj:277)
at metabase.server.middleware.session$do_with_current_user.invokeStatic(session.clj:258)
at metabase.server.middleware.session$do_with_current_user.invoke(session.clj:250)
at metabase.server.middleware.session$bind_current_user$fn__41914.invoke(session.clj:276)
at metabase.server.middleware.session$wrap_current_user_info$fn__41901.invoke(session.clj:236)
at metabase.server.middleware.session$wrap_session_id$fn__41887.invoke(session.clj:182)
at metabase.server.middleware.auth$wrap_api_key$fn__73844.invoke(auth.clj:27)
at ring.middleware.cookies$wrap_cookies$fn__76316.invoke(cookies.clj:216)
at metabase.server.middleware.misc$add_content_type$fn__35064.invoke(misc.clj:27)
at metabase.server.middleware.misc$disable_streaming_buffering$fn__35089.invoke(misc.clj:75)
at ring.middleware.gzip$wrap_gzip$fn__76358.invoke(gzip.clj:86)
at metabase.server.middleware.misc$bind_request$fn__35092.invoke(misc.clj:92)
at metabase.server.middleware.ssl$redirect_to_https_middleware$fn__76072.invoke(ssl.clj:38)
at metabase.server$async_proxy_handler$fn__75669.invoke(server.clj:71)
at metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
at org.eclipse.jetty.server.Server.handle(Server.java:516)
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383)
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:556)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:273)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:773)
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:905)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: com.mongodb.MongoTimeoutException: Timed out after 3000 ms while waiting to connect. Client view of cluster state is {type=UNKNOWN, servers=[{address=172.17.0.1:27017, type=UNKNOWN, state=CONNECTING, exception={com.mongodb.MongoSocketWriteException: Exception sending message}, caused by {javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake}, caused by {java.io.EOFException: SSL peer shut down incorrectly}}]
at com.mongodb.internal.connection.BaseCluster.getDescription(BaseCluster.java:179)
at com.mongodb.internal.connection.SingleServerCluster.getDescription(SingleServerCluster.java:41)
at com.mongodb.client.internal.MongoClientDelegate.getConnectedClusterDescription(MongoClientDelegate.java:136)
at com.mongodb.client.internal.MongoClientDelegate.createClientSession(MongoClientDelegate.java:94)
at com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.getClientSession(MongoClientDelegate.java:249)
at com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.execute(MongoClientDelegate.java:172)
at com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.execute(MongoClientDelegate.java:161)
at com.mongodb.DB.executeCommand(DB.java:774)
at com.mongodb.DB.command(DB.java:520)
at com.mongodb.DB.command(DB.java:536)
at com.mongodb.DB.command(DB.java:491)
at monger.core$command.invokeStatic(core.clj:251)
at monger.core$command.invoke(core.clj:242)
at monger.command$db_stats.invokeStatic(command.clj:71)
at monger.command$db_stats.invoke(command.clj:69)
at metabase.driver.mongo$eval2471$fn__2472$f__1886__auto____2473.invoke(mongo.clj:52)
at metabase.driver.mongo.util$_with_mongo_connection$fn__1877.invoke(util.clj:225)
at metabase.util.ssh$do_with_ssh_tunnel.invokeStatic(ssh.clj:156)
at metabase.util.ssh$do_with_ssh_tunnel.invoke(ssh.clj:145)
at metabase.driver.mongo.util$_with_mongo_connection.invokeStatic(util.clj:219)
at metabase.driver.mongo.util$_with_mongo_connection.invoke(util.clj:214)
at metabase.driver.mongo$eval2471$fn__2472.invoke(mongo.clj:51)
at clojure.lang.MultiFn.invoke(MultiFn.java:234)
at metabase.driver.util$can_connect_with_details_QMARK_$fn__29139.invoke(util.clj:34)
at metabase.util$do_with_timeout$fn__15244.invoke(util.clj:322)
at clojure.core$binding_conveyor_fn$fn__5754.invoke(core.clj:2030)
at clojure.lang.AFn.call(AFn.java:18)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
... 1 more
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 DEBUG metabase.server.middleware.log POST /api/database 200 3.0 s (4 DB calls) App DB connections: 1/15 Jetty threads: 3/50 (4 idle, 0 queued) (61 total active threads) Queries in flight: 0 (0 queued)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util STARTING: Sync mongo Database 4 'mongodb'
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util STARTING: Sync metadata for mongo Database 4 'mongodb'
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util STARTING: step 'sync-timezone' for mongo Database 4 'mongodb'
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util FINISHED: step 'sync-timezone' for mongo Database 4 'mongodb' (270.1 µs)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util STARTING: step 'sync-tables' for mongo Database 4 'mongodb'
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util FINISHED: step 'sync-tables' for mongo Database 4 'mongodb' (4.8 ms)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util FINISHED: step 'sync-fields' for mongo Database 4 'mongodb' (694.2 µs)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util STARTING: step 'sync-fields' for mongo Database 4 'mongodb'
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util FINISHED: step 'sync-fks' for mongo Database 4 'mongodb' (537.6 µs)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util STARTING: step 'sync-fks' for mongo Database 4 'mongodb'
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util STARTING: step 'sync-metabase-metadata' for mongo Database 4 'mongodb'
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util FINISHED: step 'sync-metabase-metadata' for mongo Database 4 'mongodb' (851.4 µs)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util FINISHED: Sync metadata for mongo Database 4 'mongodb' (13.3 ms)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util STARTING: Analyze data for mongo Database 4 'mongodb'
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util FINISHED: step 'classify-fields' for mongo Database 4 'mongodb' (160.7 µs)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util FINISHED: step 'fingerprint-fields' for mongo Database 4 'mongodb' (272.3 µs)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util STARTING: step 'classify-fields' for mongo Database 4 'mongodb'
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util STARTING: step 'classify-tables' for mongo Database 4 'mongodb'
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for mongo Database 4 'mongodb'
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util FINISHED: step 'classify-tables' for mongo Database 4 'mongodb' (166.8 µs)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util FINISHED: Analyze data for mongo Database 4 'mongodb' (3.9 ms)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util STARTING: Cache field values in mongo Database 4 'mongodb'
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util STARTING: step 'update-field-values' for mongo Database 4 'mongodb'
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util FINISHED: step 'update-field-values' for mongo Database 4 'mongodb' (485.6 µs)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util FINISHED: Cache field values in mongo Database 4 'mongodb' (2.1 ms)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 INFO metabase.sync.util FINISHED: Sync mongo Database 4 'mongodb' (23.3 ms)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:19+05:30 DEBUG metabase.server.middleware.log GET /api/database 200 2.5 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (63 total active threads) Queries in flight: 0 (0 queued)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:23+05:30 DEBUG metabase.server.middleware.log GET /api/automagic-dashboards/database/4/candidates 200 2.8 ms (4 DB calls) App DB connections: 2/15 Jetty threads: 3/50 (4 idle, 0 queued) (63 total active threads) Queries in flight: 0 (0 queued)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:25+05:30 DEBUG metabase.server.middleware.log GET /api/automagic-dashboards/database/4/candidates 200 2.5 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (63 total active threads) Queries in flight: 0 (0 queued)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:27+05:30 DEBUG metabase.server.middleware.log GET /api/automagic-dashboards/database/4/candidates 200 2.0 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (63 total active threads) Queries in flight: 0 (0 queued)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:29+05:30 DEBUG metabase.server.middleware.log GET /api/automagic-dashboards/database/4/candidates 200 2.1 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (63 total active threads) Queries in flight: 0 (0 queued)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:31+05:30 DEBUG metabase.server.middleware.log GET /api/automagic-dashboards/database/4/candidates 200 2.1 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (63 total active threads) Queries in flight: 0 (0 queued)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:33+05:30 DEBUG metabase.server.middleware.log GET /api/automagic-dashboards/database/4/candidates 200 2.2 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (63 total active threads) Queries in flight: 0 (0 queued)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:34+05:30 DEBUG metabase.server.middleware.log GET /api/database 200 2.7 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (3 idle, 0 queued) (63 total active threads) Queries in flight: 0 (0 queued)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:35+05:30 DEBUG metabase.server.middleware.log GET /api/automagic-dashboards/database/4/candidates 200 2.3 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (63 total active threads) Queries in flight: 0 (0 queued)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:37+05:30 DEBUG metabase.server.middleware.log GET /api/database/4/schemas 200 2.5 ms (4 DB calls) App DB connections: 2/15 Jetty threads: 3/50 (4 idle, 0 queued) (63 total active threads) Queries in flight: 0 (0 queued)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:41+05:30 DEBUG metabase.server.middleware.log GET /api/setting 200 580.3 µs (0 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (63 total active threads) Queries in flight: 0 (0 queued)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:41+05:30 DEBUG metabase.server.middleware.log GET /api/session/properties 200 2.3 ms (2 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (63 total active threads) Queries in flight: 0 (0 queued)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:41+05:30 DEBUG metabase.server.middleware.log GET /api/setup/admin_checklist 200 3.9 ms (13 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (63 total active threads) Queries in flight: 0 (0 queued)
[b0b66cb2-f179-4f02-ad7d-d67408367a75] 2021-03-09T20:49:44+05:30 DEBUG metabase.server.middleware.log GET /api/util/bug_report_details 200 1.4 ms (1 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (63 total active threads) Queries in flight: 0 (0 queued)
Here’s Metabase Diagnostic Info :
{
"browser-info": {
"language": "en-US",
"platform": "Linux x86_64",
"userAgent": "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:86.0) Gecko/20100101 Firefox/86.0",
"vendor": ""
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.10+9",
"java.vendor": "AdoptOpenJDK",
"java.vendor.url": "https://adoptopenjdk.net/",
"java.version": "11.0.10",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.10+9",
"os.name": "Linux",
"os.version": "4.14.219-161.340.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"h2",
"mongo"
],
"hosting-env": "unknown",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "1.4.197 (2018-03-18)"
},
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "1.4.197 (2018-03-18)"
}
},
"run-mode": "prod",
"version": {
"date": "2021-03-03",
"tag": "v0.38.1",
"branch": "release-x.38.x",
"hash": "79ef63a"
},
"settings": {
"report-timezone": null
}
}
}
Here’s log from my MongoDB :
{"t":{"$date":"2021-03-09T15:21:55.598+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"172.17.0.2:58902","connectionId":65,"connectionCount":5}}
{"t":{"$date":"2021-03-09T15:21:55.601+00:00"},"s":"I", "c":"NETWORK", "id":22988, "ctx":"conn65","msg":"Error receiving request from client. Ending connection from remote","attr":{"error":{"code":141,"codeName":"SSLHandshakeFailed","errmsg":"SSL handshake received but server is started without SSL support"},"remote":"172.17.0.2:58902","connectionId":65}}
{"t":{"$date":"2021-03-09T15:21:55.601+00:00"},"s":"I", "c":"NETWORK", "id":22944, "ctx":"conn65","msg":"Connection ended","attr":{"remote":"172.17.0.2:58902","connectionId":65,"connectionCount":4}}
I’ve successfully integrated and run queries on the same MongoDB from Apache Drill with same architecture (Drill on docker on ec2 instance and MongoDB locally on ec2 instance)
From what I’ve understood, the connection is being established between Metabase and MongoDB because I can see MongoDB in “our data” in metabase but for some reason I’m not able to see the collections of my MongoDB database.
Please help!!!