Snowflake - Failed to connect to Database

RubabZS · June 24, 2024, 11:48am

Hi,

We are running into an issue where our Snowflake connection is being timed out. The same configuration settings were working fine. We are running the open source version of metabase inside a container (on EC2) and our snowflake is hosted on AWS. Here is our diagnostic tool output. I've tried the following:

Installed updated ojdbc8.jar
Upgraded metabase to v0.50.6 (previously it was 0.46)
Increased timeout from 10 seconds to 30 seconds to see if the initial setup was taking time
My EC2 host is able to connect to my snowflake URL

Any leads would be appreciated, thank you.

{
  "browser-info": {
    "language": "en-GB",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.23+9",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.23",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.23+9",
    "os.name": "Linux",
    "os.version": "6.1.34-58.102.amzn2023.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "snowflake",
      "bigquery-cloud-sdk"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "14.10"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.7.3"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2024-06-19",
      "tag": "v0.50.6",
      "hash": "a5fbebf"
    },
    "settings": {
      "report-timezone": null
    }
  }
}

TonyC · June 24, 2024, 11:56am

What error are you getting in the logs?

Are you sure there was no change to the network?

RubabZS · June 24, 2024, 12:13pm

I'm getting:

[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:09:30+05:00 DEBUG metabase.server.middleware.log PUT /api/database/3 400 30.2 s (1 DB calls) {:metabase-user-id 2} 
{:message "Timed out after 30.0 s"}

Yep, no change. Other databases are working fine e.g. BigQuery.

TonyC · June 24, 2024, 12:17pm

When you say My EC2 host is able to connect to my snowflake URL ... Is metabase running on the same EC2 host?

RubabZS · June 24, 2024, 12:21pm

Yes, as a docker container.

Adding more logs, if they are relevant:

=> java.lang.String
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:10:48+05:00 ERROR metabase.api.database Cannot connect to Database,clojure.lang.ExceptionInfo: Timed out after 30.0 s {:message "Timed out after 30.0 s"},	at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(util.clj:166),	at metabase.driver.util$can_connect_with_details_QMARK_.doInvoke(util.clj:137),	at clojure.lang.RestFn.invoke(RestFn.java:442),	at metabase.api.database$test_database_connection.invokeStatic(database.clj:728),	at metabase.api.database$test_database_connection.doInvoke(database.clj:718),	at clojure.lang.RestFn.invoke(RestFn.java:425),	at metabase.api.database$fn__94146.invokeStatic(database.clj:937),	at metabase.api.database$fn__94146.invoke(database.clj:912),	at compojure.core$wrap_response$fn__52891.invoke(core.clj:160),	at compojure.core$wrap_route_middleware$fn__52875.invoke(core.clj:132),	at compojure.core$wrap_route_info$fn__52880.invoke(core.clj:139),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:151),	at clojure.lang.Var.invoke(Var.java:393),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at clojure.lang.Var.invoke(Var.java:393),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at clojure.lang.Var.invoke(Var.java:393),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903.invoke(core.clj:200),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at metabase.server.middleware.auth$enforce_authentication$fn__97198.invoke(auth.clj:18),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903.invoke(core.clj:200),	at compojure.core$make_context$handler__52931.invoke(core.clj:290),	at compojure.core$make_context$fn__52935.invoke(core.clj:300),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at clojure.lang.Var.invoke(Var.java:393),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at metabase.api.routes$fn__103641$fn__103644.invoke(routes.clj:73),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903.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:667),	at clojure.core$apply.invoke(core.clj:662),	at metabase.server.routes$fn__103921$fn__103922.doInvoke(routes.clj:73),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903.invoke(core.clj:200),	at compojure.core$make_context$handler__52931.invoke(core.clj:290),	at compojure.core$make_context$fn__52935.invoke(core.clj:300),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at metabase.server.routes$fn__103904$fn__103906.invoke(routes.clj:47),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903.invoke(core.clj:200),	at metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__100069.invoke(exceptions.clj:107),	at metabase.server.middleware.exceptions$catch_api_exceptions$fn__100066.invoke(exceptions.clj:96),	at metabase.server.middleware.log$log_api_call$fn__104201$fn__104202$fn__104203.invoke(log.clj:236),	at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invokeStatic(diagnostic.clj:18),	at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invoke(diagnostic.clj:12),	at metabase.server.middleware.log$log_api_call$fn__104201$fn__104202.invoke(log.clj:227),	at toucan2.execute$do_with_call_counts.invokeStatic(execute.clj:112),	at toucan2.execute$do_with_call_counts.invoke(execute.clj:103),	at metabase.server.middleware.log$log_api_call$fn__104201.invoke(log.clj:226),	at metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__107467.invoke(browser_cookie.clj:40),	at metabase.server.middleware.security$add_security_headers$fn__100025.invoke(security.clj:238),	at ring.middleware.json$wrap_json_body$fn__107726.invoke(json.clj:64),	at metabase.server.middleware.offset_paging$handle_paging$fn__86507.invoke(offset_paging.clj:43),	at metabase.server.middleware.json$wrap_streamed_json_response$fn__54346.invoke(json.clj:83),	at ring.middleware.keyword_params$wrap_keyword_params$fn__107815.invoke(keyword_params.clj:55),	at ring.middleware.params$wrap_params$fn__107834.invoke(params.clj:77),	at metabase.server.middleware.misc$maybe_set_site_url$fn__69793.invoke(misc.clj:60),	at metabase.server.middleware.session$reset_session_timeout$fn__76937.invoke(session.clj:552),	at metabase.server.middleware.session$bind_current_user$fn__76903$fn__76904.invoke(session.clj:446),	at metabase.server.middleware.session$do_with_current_user.invokeStatic(session.clj:425),	at metabase.server.middleware.session$do_with_current_user.invoke(session.clj:408),	at metabase.server.middleware.session$bind_current_user$fn__76903.invoke(session.clj:445),	at metabase.server.middleware.session$wrap_current_user_info$fn__76884.invoke(session.clj:383),	at metabase.server.middleware.session$wrap_session_id$fn__76856.invoke(session.clj:259),	at metabase.server.middleware.auth$wrap_static_api_key$fn__97206.invoke(auth.clj:32),	at ring.middleware.cookies$wrap_cookies$fn__107654.invoke(cookies.clj:200),	at metabase.server.middleware.misc$add_content_type$fn__69775.invoke(misc.clj:28),	at metabase.server.middleware.misc$disable_streaming_buffering$fn__69801.invoke(misc.clj:77),	at ring.middleware.gzip$wrap_gzip$fn__107696.invoke(gzip.clj:86),	at metabase.server.middleware.misc$bind_request$fn__69804.invoke(misc.clj:94),	at metabase.server.middleware.ssl$redirect_to_https_middleware$fn__107483.invoke(ssl.clj:41),	at metabase.server$async_proxy_handler$fn__70139.invoke(server.clj:77),	at metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source),	at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:173),	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122),	at org.eclipse.jetty.server.Server.handle(Server.java:563),	at org.eclipse.jetty.server.HttpChannel$RequestDispatchable.dispatch(HttpChannel.java:1598),	at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:753),	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:501),	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:287),	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314),	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100),	at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53),	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:421),	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:390),	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:277),	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.run(AdaptiveExecutionStrategy.java:199),	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:411),	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:969),	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob(QueuedThreadPool.java:1194),	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1149),	at java.base/java.lang.Thread.run(Unknown Source),Caused by: java.util.concurrent.TimeoutException: Timed out after 30.0 s,	at metabase.util.jvm$deref_with_timeout.invokeStatic(jvm.clj:287),	at metabase.util.jvm$deref_with_timeout.invoke(jvm.clj:279),	at metabase.util.jvm$do_with_timeout.invokeStatic(jvm.clj:294),	at metabase.util.jvm$do_with_timeout.invoke(jvm.clj:290),	at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(util.clj:148),	... 190 more
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:10:48+05:00 DEBUG metabase.server.middleware.log PUT /api/database/3 400 30.0 s (1 DB calls) {:metabase-user-id 2} 
{:message "Timed out after 30.0 s"}

[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:10:49+05:00 DEBUG metabase.server.middleware.log GET /api/database 200 16.5 ms (1 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (36 total active threads) Queries in flight: 0 (0 queued) {:metabase-user-id 2}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:10:51+05:00 ERROR net.snowflake.client.core.SFTrustManager WARNING!!! Using fail-open to connect. Driver is connecting to an HTTPS endpoint without OCSP based Certificate Revocation checking as it could not obtain a valid OCSP Response to use from the CA OCSP responder. Details: 
{"cacheEnabled":true,"ocspReqBase64":"ME8wTTBLMEkwRzAHBgUrDgMCGgQUKhyPrHZmqWsEJ3C9a6QhGWfIE0gEFFXZGF\/SHMwB4Vi0vqvZVUIB1y4CAhAIgJFyPSIo\/EPFUhFZ5mp3","ocspMode":"FAIL_OPEN","sfcPeerHost":"nw18763.ap-south-1.aws.snowflakecomputing.com","ocspResponderURL":"http:\/\/ocsp.r2m03.amazontrust.com","cacheHit":false,"eventType":"OCSPValidationError","certId":"MEcwBwYFKw4DAhoEFCocj6x2ZqlrBCdwvWukIRlnyBNIBBRV2Rhf0hzMAeFYtL6r2VVCAdcuAgIQCICRcj0iKPxDxVIRWeZqdw=="}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:11:00+05:00 INFO metabase.task.sync-databases Starting sync task for Database 4.
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:11:01+05:00 ERROR net.snowflake.client.core.SFTrustManager WARNING!!! Using fail-open to connect. Driver is connecting to an HTTPS endpoint without OCSP based Certificate Revocation checking as it could not obtain a valid OCSP Response to use from the CA OCSP responder. Details: 
{"cacheEnabled":true,"ocspReqBase64":"MFIwUDBOMEwwSjAHBgUrDgMCGgQUT1mjlFPPuVWef2vYxU2lPaZCtxQEFIQYzIU07LwMlJQuCFmcx7IQTgoIAhMHcxJM1AbSZ8CZHN0pmp84MXmF","ocspMode":"FAIL_OPEN","sfcPeerHost":"nw18763.ap-south-1.aws.snowflakecomputing.com","ocspResponderURL":"http:\/\/ocsp.rootca1.amazontrust.com","cacheHit":false,"eventType":"OCSPValidationError","certId":"MEowBwYFKw4DAhoEFE9Zo5RTz7lVnn9r2MVNpT2mQrcUBBSEGMyFNOy8DJSULghZnMeyEE4KCAITB3MSTNQG0mfAmRzdKZqfODF5hQ=="}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:11:11+05:00 ERROR net.snowflake.client.core.SFTrustManager WARNING!!! Using fail-open to connect. Driver is connecting to an HTTPS endpoint without OCSP based Certificate Revocation checking as it could not obtain a valid OCSP Response to use from the CA OCSP responder. Details: 
{"cacheEnabled":true,"ocspReqBase64":"MFIwUDBOMEwwSjAHBgUrDgMCGgQUiH2kRF5n6nyUd05DGJw+zuTIcxIEFJxfAN+qAdcwKziIorhtSpzyEZGDAhMGf5RKKifN8\/rCrisB+QjuucTG","ocspMode":"FAIL_OPEN","sfcPeerHost":"nw18763.ap-south-1.aws.snowflakecomputing.com","ocspResponderURL":"http:\/\/ocsp.rootg2.amazontrust.com","cacheHit":false,"eventType":"OCSPValidationError","certId":"MEowBwYFKw4DAhoEFIh9pEReZ+p8lHdOQxicPs7kyHMSBBScXwDfqgHXMCs4iKK4bUqc8hGRgwITBn+USionzfP6wq4rAfkI7rnExg=="}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:11:21+05:00 ERROR net.snowflake.client.core.SFTrustManager WARNING!!! Using fail-open to connect. Driver is connecting to an HTTPS endpoint without OCSP based Certificate Revocation checking as it could not obtain a valid OCSP Response to use from the CA OCSP responder. Details: 
{"cacheEnabled":true,"ocspReqBase64":"MEgwRjBEMEIwQDAHBgUrDgMCGgQUi8GehFuYHWHPVGkhGmi44xEzbZAEFL9ft9HO3R+G9FtVrNzXEMIOqYjnAgkApw5KTDSCt38=","ocspMode":"FAIL_OPEN","sfcPeerHost":"nw18763.ap-south-1.aws.snowflakecomputing.com","ocspResponderURL":"http:\/\/o.ss2.us\/","cacheHit":false,"eventType":"OCSPValidationError","certId":"MEAwBwYFKw4DAhoEFIvBnoRbmB1hz1RpIRpouOMRM22QBBS\/X7fRzt0fhvRbVazc1xDCDqmI5wIJAKcOSkw0grd\/"}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:11:21+05:00 ERROR net.snowflake.client.core.SFTrustManager WARNING!!! Using fail-open to connect. Driver is connecting to an HTTPS endpoint without OCSP based Certificate Revocation checking as it could not obtain a valid OCSP Response to use from the CA OCSP responder. Details: 
{"cacheEnabled":true,"ocspReqBase64":"ME8wTTBLMEkwRzAHBgUrDgMCGgQUKhyPrHZmqWsEJ3C9a6QhGWfIE0gEFFXZGF\/SHMwB4Vi0vqvZVUIB1y4CAhAIgJFyPSIo\/EPFUhFZ5mp3","ocspMode":"FAIL_OPEN","sfcPeerHost":"nw18763.ap-south-1.aws.snowflakecomputing.com","ocspResponderURL":"http:\/\/ocsp.r2m03.amazontrust.com","cacheHit":false,"eventType":"OCSPValidationError","certId":"MEcwBwYFKw4DAhoEFCocj6x2ZqlrBCdwvWukIRlnyBNIBBRV2Rhf0hzMAeFYtL6r2VVCAdcuAgIQCICRcj0iKPxDxVIRWeZqdw=="}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:11:21+05:00 ERROR net.snowflake.client.core.HeartbeatBackground heartbeat error - message=Session no longer exists.  New login required to access the service.,net.snowflake.client.jdbc.SnowflakeSQLException: Session no longer exists.  New login required to access the service.,	at net.snowflake.client.jdbc.SnowflakeUtil.checkErrorAndThrowExceptionSub(SnowflakeUtil.java:161),	at net.snowflake.client.jdbc.SnowflakeUtil.checkErrorAndThrowException(SnowflakeUtil.java:94),	at net.snowflake.client.core.SFSession.heartbeat(SFSession.java:985),	at net.snowflake.client.core.HeartbeatBackground.run(HeartbeatBackground.java:192),	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source),	at java.base/java.util.concurrent.FutureTask.run(Unknown Source),	at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.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)
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:11:30+05:00 ERROR metabase.driver.util Failed to connect to Database,java.util.concurrent.TimeoutException: Timed out after 30.0 s,	at metabase.util.jvm$deref_with_timeout.invokeStatic(jvm.clj:287),	at metabase.util.jvm$deref_with_timeout.invoke(jvm.clj:279),	at metabase.util.jvm$do_with_timeout.invokeStatic(jvm.clj:294),	at metabase.util.jvm$do_with_timeout.invoke(jvm.clj:290),	at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(util.clj:148),	at metabase.driver.util$can_connect_with_details_QMARK_.doInvoke(util.clj:137),	at clojure.lang.RestFn.invoke(RestFn.java:442),	at metabase.task.sync_databases$sync_and_analyze_database_STAR__BANG_$fn__108508$fn__108509.invoke(sync_databases.clj:82),	at metabase.task.sync_databases$sync_and_analyze_database_STAR__BANG_$fn__108508.invoke(sync_databases.clj:81),	at metabase.task.sync_databases$sync_and_analyze_database_STAR__BANG_.invokeStatic(sync_databases.clj:78),	at metabase.task.sync_databases$sync_and_analyze_database_STAR__BANG_.invoke(sync_databases.clj:71),	at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invokeStatic(sync_databases.clj:107),	at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invoke(sync_databases.clj:95),	at metabase.task.sync_databases.SyncAndAnalyzeDatabase.execute(sync_databases.clj:112),	at org.quartz.core.JobRunShell.run(JobRunShell.java:202),	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:11:30+05:00 ERROR metabase.driver.snowflake (type message)

TonyC · June 24, 2024, 12:28pm

Are you sure the credentials are correct and nothing changed? There seem to be a bunch of snowflake related network errors there

ERROR net.snowflake.client.core.HeartbeatBackground heartbeat error - message=Session no longer exists.

Can you try to create a new connection to snowflake with the same credentials and see what happens?

RubabZS · June 24, 2024, 12:39pm

I just created a new connection with the same credentials.

=> java.lang.String
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:36:48+05:00 ERROR metabase.api.database Cannot connect to Database,clojure.lang.ExceptionInfo: Timed out after 30.0 s {:message "Timed out after 30.0 s"},	at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(util.clj:166),	at metabase.driver.util$can_connect_with_details_QMARK_.doInvoke(util.clj:137),	at clojure.lang.RestFn.invoke(RestFn.java:442),	at metabase.api.database$test_database_connection.invokeStatic(database.clj:728),	at metabase.api.database$test_database_connection.doInvoke(database.clj:718),	at clojure.lang.RestFn.invoke(RestFn.java:425),	at metabase.api.database$test_connection_details.invokeStatic(database.clj:782),	at metabase.api.database$test_connection_details.invoke(database.clj:762),	at metabase.api.database$fn__94101.invokeStatic(database.clj:803),	at metabase.api.database$fn__94101.invoke(database.clj:786),	at compojure.core$wrap_response$fn__52891.invoke(core.clj:160),	at compojure.core$wrap_route_middleware$fn__52875.invoke(core.clj:132),	at compojure.core$wrap_route_info$fn__52880.invoke(core.clj:139),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:151),	at clojure.lang.Var.invoke(Var.java:393),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:152),	at clojure.lang.Var.invoke(Var.java:393),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903.invoke(core.clj:200),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at metabase.server.middleware.auth$enforce_authentication$fn__97198.invoke(auth.clj:18),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903.invoke(core.clj:200),	at compojure.core$make_context$handler__52931.invoke(core.clj:290),	at compojure.core$make_context$fn__52935.invoke(core.clj:300),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at clojure.lang.Var.invoke(Var.java:393),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at metabase.api.routes$fn__103641$fn__103644.invoke(routes.clj:73),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903.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:667),	at clojure.core$apply.invoke(core.clj:662),	at metabase.server.routes$fn__103921$fn__103922.doInvoke(routes.clj:73),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903.invoke(core.clj:200),	at compojure.core$make_context$handler__52931.invoke(core.clj:290),	at compojure.core$make_context$fn__52935.invoke(core.clj:300),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at metabase.server.routes$fn__103904$fn__103906.invoke(routes.clj:47),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903.invoke(core.clj:200),	at metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__100069.invoke(exceptions.clj:107),	at metabase.server.middleware.exceptions$catch_api_exceptions$fn__100066.invoke(exceptions.clj:96),	at metabase.server.middleware.log$log_api_call$fn__104201$fn__104202$fn__104203.invoke(log.clj:236),	at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invokeStatic(diagnostic.clj:18),	at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invoke(diagnostic.clj:12),	at metabase.server.middleware.log$log_api_call$fn__104201$fn__104202.invoke(log.clj:227),	at toucan2.execute$do_with_call_counts.invokeStatic(execute.clj:112),	at toucan2.execute$do_with_call_counts.invoke(execute.clj:103),	at metabase.server.middleware.log$log_api_call$fn__104201.invoke(log.clj:226),	at metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__107467.invoke(browser_cookie.clj:40),	at metabase.server.middleware.security$add_security_headers$fn__100025.invoke(security.clj:238),	at ring.middleware.json$wrap_json_body$fn__107726.invoke(json.clj:64),	at metabase.server.middleware.offset_paging$handle_paging$fn__86507.invoke(offset_paging.clj:43),	at metabase.server.middleware.json$wrap_streamed_json_response$fn__54346.invoke(json.clj:83),	at ring.middleware.keyword_params$wrap_keyword_params$fn__107815.invoke(keyword_params.clj:55),	at ring.middleware.params$wrap_params$fn__107834.invoke(params.clj:77),	at metabase.server.middleware.misc$maybe_set_site_url$fn__69793.invoke(misc.clj:60),	at metabase.server.middleware.session$reset_session_timeout$fn__76937.invoke(session.clj:552),	at metabase.server.middleware.session$bind_current_user$fn__76903$fn__76904.invoke(session.clj:446),	at metabase.server.middleware.session$do_with_current_user.invokeStatic(session.clj:425),	at metabase.server.middleware.session$do_with_current_user.invoke(session.clj:408),	at metabase.server.middleware.session$bind_current_user$fn__76903.invoke(session.clj:445),	at metabase.server.middleware.session$wrap_current_user_info$fn__76884.invoke(session.clj:383),	at metabase.server.middleware.session$wrap_session_id$fn__76856.invoke(session.clj:259),	at metabase.server.middleware.auth$wrap_static_api_key$fn__97206.invoke(auth.clj:32),	at ring.middleware.cookies$wrap_cookies$fn__107654.invoke(cookies.clj:200),	at metabase.server.middleware.misc$add_content_type$fn__69775.invoke(misc.clj:28),	at metabase.server.middleware.misc$disable_streaming_buffering$fn__69801.invoke(misc.clj:77),	at ring.middleware.gzip$wrap_gzip$fn__107696.invoke(gzip.clj:86),	at metabase.server.middleware.misc$bind_request$fn__69804.invoke(misc.clj:94),	at metabase.server.middleware.ssl$redirect_to_https_middleware$fn__107483.invoke(ssl.clj:41),	at metabase.server$async_proxy_handler$fn__70139.invoke(server.clj:77),	at metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source),	at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:173),	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122),	at org.eclipse.jetty.server.Server.handle(Server.java:563),	at org.eclipse.jetty.server.HttpChannel$RequestDispatchable.dispatch(HttpChannel.java:1598),	at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:753),	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:501),	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:287),	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314),	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100),	at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53),	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:421),	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:390),	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:277),	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.run(AdaptiveExecutionStrategy.java:199),	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:411),	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:969),	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob(QueuedThreadPool.java:1194),	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1149),	at java.base/java.lang.Thread.run(Unknown Source),Caused by: java.util.concurrent.TimeoutException: Timed out after 30.0 s,	at metabase.util.jvm$deref_with_timeout.invokeStatic(jvm.clj:287),	at metabase.util.jvm$deref_with_timeout.invoke(jvm.clj:279),	at metabase.util.jvm$do_with_timeout.invokeStatic(jvm.clj:294),	at metabase.util.jvm$do_with_timeout.invoke(jvm.clj:290),	at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(util.clj:148),	... 188 more
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:36:48+05:00 ERROR net.snowflake.client.core.SFTrustManager WARNING!!! Using fail-open to connect. Driver is connecting to an HTTPS endpoint without OCSP based Certificate Revocation checking as it could not obtain a valid OCSP Response to use from the CA OCSP responder. Details: 
{"cacheEnabled":true,"ocspReqBase64":"MEgwRjBEMEIwQDAHBgUrDgMCGgQUi8GehFuYHWHPVGkhGmi44xEzbZAEFL9ft9HO3R+G9FtVrNzXEMIOqYjnAgkApw5KTDSCt38=","ocspMode":"FAIL_OPEN","sfcPeerHost":"nw18763.ap-south-1.aws.snowflakecomputing.com","ocspResponderURL":"http:\/\/o.ss2.us\/","cacheHit":false,"eventType":"OCSPValidationError","certId":"MEAwBwYFKw4DAhoEFIvBnoRbmB1hz1RpIRpouOMRM22QBBS\/X7fRzt0fhvRbVazc1xDCDqmI5wIJAKcOSkw0grd\/"}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:36:48+05:00 DEBUG metabase.server.middleware.log POST /api/database 400 30.0 s (1 DB calls) {:metabase-user-id 2} 
{:message "Timed out after 30.0 s"}

[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:36:48+05:00 DEBUG metabase.server.middleware.log GET /api/database 200 13.1 ms (1 DB calls) App DB connections: 0/4 Jetty threads: 4/50 (3 idle, 0 queued) (40 total active threads) Queries in flight: 0 (0 queued) {:metabase-user-id 2}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:36:51+05:00 ERROR net.snowflake.client.core.SFTrustManager WARNING!!! Using fail-open to connect. Driver is connecting to an HTTPS endpoint without OCSP based Certificate Revocation checking as it could not obtain a valid OCSP Response to use from the CA OCSP responder. Details: 
{"cacheEnabled":true,"ocspReqBase64":"MEgwRjBEMEIwQDAHBgUrDgMCGgQUi8GehFuYHWHPVGkhGmi44xEzbZAEFL9ft9HO3R+G9FtVrNzXEMIOqYjnAgkApw5KTDSCt38=","ocspMode":"FAIL_OPEN","sfcPeerHost":"nw18763.ap-south-1.snowflakecomputing.com","ocspResponderURL":"http:\/\/o.ss2.us\/","cacheHit":false,"eventType":"OCSPValidationError","certId":"MEAwBwYFKw4DAhoEFIvBnoRbmB1hz1RpIRpouOMRM22QBBS\/X7fRzt0fhvRbVazc1xDCDqmI5wIJAKcOSkw0grd\/"}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:37:27+05:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 41.8 ms (10 DB calls) App DB connections: 1/4 Jetty threads: 4/50 (3 idle, 0 queued) (39 total active threads) Queries in flight: 0 (0 queued) {:metabase-user-id 2}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:37:27+05:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 49.1 ms (7 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (3 idle, 0 queued) (39 total active threads) Queries in flight: 0 (0 queued) {:metabase-user-id 2}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:37:27+05:00 DEBUG metabase.server.middleware.log GET /api/database 200 30.1 ms (1 DB calls) App DB connections: 2/4 Jetty threads: 4/50 (3 idle, 0 queued) (39 total active threads) Queries in flight: 0 (0 queued) {:metabase-user-id 2}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:37:27+05:00 DEBUG metabase.server.middleware.log GET /api/setting 200 41.5 ms (10 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (3 idle, 0 queued) (39 total active threads) Queries in flight: 0 (0 queued) {:metabase-user-id 2}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:37:27+05:00 DEBUG metabase.server.middleware.log GET /api/search 200 54.7 ms (4 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (3 idle, 0 queued) (39 total active threads) Queries in flight: 0 (0 queued) {:metabase-user-id 2}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:37:27+05:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 25.4 ms (6 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (39 total active threads) Queries in flight: 0 (0 queued) {:metabase-user-id 2}

TonyC · June 24, 2024, 12:50pm

Are you able to create the connection or it says Failed? Since it doesn't look like you are able to ... Ao are you sure you are able to connect in the first place?

RubabZS · June 24, 2024, 12:53pm

Ah, sorry for the confusion. My connection is not created. It fails with the timeout and I get the above logs.

TonyC · June 24, 2024, 12:57pm

So it seems there is a problem with the credentials or with some certificate you are providing? You can download Dbeaver and try to connect to snowflake to see if it's a metabase issue or just a snowflake issue

RubabZS · June 24, 2024, 1:04pm

Got it, let me try that. Thank you for the help!

TonyC · June 24, 2024, 1:09pm

LEt me know!

RubabZS · June 24, 2024, 1:18pm

It works seamlessly with Dbeaver. I provided it with the full snowflake URL.

https://nw18763.ap-south-1.aws.snowflakecomputing.com

It has to be metabase then. I give nw18763.ap-south-1.aws to the metabase as it was working with this configuration beforehand as well. Let me look into certificates then.

TonyC · June 24, 2024, 1:22pm

Share as well a screenshot of the database connection ... Since you said it failed on 46 as well so I doubt its a 50 version issue ... Anything else you might be aware you changed when this happened?

RubabZS · June 24, 2024, 2:02pm

Here it is:

The only other thing I can think of is we cleaned up our AWS infrastructure before the weekend, deleted some resources. But a working BigQuery connection would rule out any issue caused because of this, correct?

Luiggi · June 24, 2024, 2:21pm

click on avanced options and add the following to the jdbc parameters:
insecureMode=true

TonyC · June 24, 2024, 2:22pm

Not sure! Ie the Database correct? Since it's case sensitive? No real ideas right now form my end

RubabZS · June 24, 2024, 5:20pm

This worked. Thank you so much!

RubabZS · June 24, 2024, 5:29pm

The above solution by Luiggi worked. Thank you so much for your time!