Some Tiles in Dashboards show "There was a problem displaying this chart"

Get Help
1

Some Tiles in Dashboards show "There was a problem displaying this chart". We have 12 tiles in the dashboard and the tile with the issue is different almost every time.

dashboard%20issue

Diagnostic Information is below

{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "ANSI_X3.4-1968",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.14+9",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.14",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.14+9",
"os.name": "Linux",
"os.version": "5.10.93-87.444.amzn2.x86_64",
"user.language": "en",
"user.timezone": "UTC"
},
"metabase-info": {
"databases": [
"h2",
"mysql"
],
"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": "2022-01-10",
"tag": "v0.41.6",
"branch": "release-x.41.x",
"hash": "296635f"
},
"settings": {
"report-timezone": null
}
}
}

Please assist if there is anything to verify.

2

Hi @jayv
Post the stacktrace from Admin > Troubleshooting > Logs.
Latest release is 0.42.3: https://github.com/metabase/metabase/releases/latest
You should migrate away from H2 if you are using Metabase in production:
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html

3

Thank you for the response. Please see below.

[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:47:16-04:00 ERROR metabase.api.session Authentication endpoint error
clojure.lang.ExceptionInfo: Password did not match stored password. {:status-code 401, :errors {:password "did not match stored password"}}
at metabase.api.session$do_http_401_on_error.invokeStatic(session.clj:152)
at metabase.api.session$do_http_401_on_error.invoke(session.clj:148)
at metabase.api.session$fn__79063.invokeStatic(session.clj:172)
at metabase.api.session$fn__79063.invoke(session.clj:160)
at compojure.core$wrap_response$fn__32066.invoke(core.clj:160)
at compojure.core$wrap_route_middleware$fn__32050.invoke(core.clj:132)
at compojure.core$wrap_route_info$fn__32055.invoke(core.clj:139)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:151)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078.invoke(core.clj:200)
at metabase.api.session$_PLUS_log_all_request_failures$fn__79120.invoke(session.clj:295)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078.invoke(core.clj:200)
at compojure.core$make_context$handler__32106.invoke(core.clj:289)
at compojure.core$make_context$fn__32110.invoke(core.clj:299)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at metabase.api.routes$fn__79847$fn__79850.invoke(routes.clj:56)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078.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__79992$fn__79993.doInvoke(routes.clj:57)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078.invoke(core.clj:200)
at compojure.core$make_context$handler__32106.invoke(core.clj:289)
at compojure.core$make_context$fn__32110.invoke(core.clj:299)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:153)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:153)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:153)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at metabase.server.routes$fn__79980$fn__79982.invoke(routes.clj:41)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078.invoke(core.clj:200)
at metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__77452.invoke(exceptions.clj:98)
at metabase.server.middleware.exceptions$catch_api_exceptions$fn__77449.invoke(exceptions.clj:86)
at metabase.server.middleware.log$log_api_call$fn__80447$fn__80448$fn__80449.invoke(log.clj:209)
at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invokeStatic(diagnostic.clj:15)
at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invoke(diagnostic.clj:9)
at metabase.server.middleware.log$log_api_call$fn__80447$fn__80448.invoke(log.clj:201)
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__80447.invoke(log.clj:200)
at metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__83660.invoke(browser_cookie.clj:30)
at metabase.server.middleware.security$add_security_headers$fn__59285.invoke(security.clj:147)
at metabase.server.middleware.json$wrap_json_body$fn__82804.invoke(json.clj:62)
at metabase.server.middleware.json$wrap_streamed_json_response$fn__82822.invoke(json.clj:98)
at metabase.server.middleware.offset_paging$handle_paging$fn__59309.invoke(offset_paging.clj:42)
at ring.middleware.keyword_params$wrap_keyword_params$fn__83927.invoke(keyword_params.clj:55)
at ring.middleware.params$wrap_params$fn__83943.invoke(params.clj:69)
at metabase.server.middleware.misc$maybe_set_site_url$fn__34077.invoke(misc.clj:59)
at metabase.server.middleware.session$bind_current_user$fn__44982$fn__44983.invoke(session.clj:257)
at metabase.server.middleware.session$do_with_current_user.invokeStatic(session.clj:238)
at metabase.server.middleware.session$do_with_current_user.invoke(session.clj:230)
at metabase.server.middleware.session$bind_current_user$fn__44982.invoke(session.clj:256)
at metabase.server.middleware.session$wrap_current_user_info$fn__44969.invoke(session.clj:216)
at metabase.server.middleware.session$wrap_session_id$fn__44955.invoke(session.clj:162)
at metabase.server.middleware.auth$wrap_api_key$fn__70378.invoke(auth.clj:27)
at ring.middleware.cookies$wrap_cookies$fn__83847.invoke(cookies.clj:216)
at metabase.server.middleware.misc$add_content_type$fn__34060.invoke(misc.clj:27)
at metabase.server.middleware.misc$disable_streaming_buffering$fn__34085.invoke(misc.clj:76)
at ring.middleware.gzip$wrap_gzip$fn__83889.invoke(gzip.clj:86)
at metabase.server.middleware.misc$bind_request$fn__34088.invoke(misc.clj:93)
at metabase.server.middleware.ssl$redirect_to_https_middleware$fn__83676.invoke(ssl.clj:48)
at metabase.server$async_proxy_handler$fn__80220.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:388)
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
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:338)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:386)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)
at java.base/java.lang.Thread.run(Thread.java:829)
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:47:16-04:00 DEBUG metabase.server.middleware.log POST /api/session 401 113.2 ms (1 DB calls)
{:errors {:password "did not match stored password"}}

[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:47:24-04:00 DEBUG metabase.server.middleware.log POST /api/session 200 128.7 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (6 idle, 0 queued) (118 total active threads) Queries in flight: 0 (0 queued)
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:47:24-04:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 4.6 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (6 idle, 0 queued) (118 total active threads) Queries in flight: 0 (0 queued)
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:47:24-04:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 3.7 ms (2 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (5 idle, 0 queued) (119 total active threads) Queries in flight: 0 (0 queued)
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:47:24-04:00 DEBUG metabase.server.middleware.log GET /api/database 200 6.4 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (6 idle, 0 queued) (119 total active threads) Queries in flight: 0 (0 queued)
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:47:24-04:00 DEBUG metabase.server.middleware.log GET /api/collection/root/items 200 10.1 ms (11 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (6 idle, 0 queued) (119 total active threads) Queries in flight: 0 (0 queued)
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:47:25-04:00 DEBUG metabase.server.middleware.log GET /api/collection/root 200 1.1 ms (2 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (6 idle, 0 queued) (119 total active threads) Queries in flight: 0 (0 queued)
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:47:25-04:00 DEBUG metabase.server.middleware.log GET /api/collection/root/items 200 5.5 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (6 idle, 0 queued) (119 total active threads) Queries in flight: 0 (0 queued)
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:47:25-04:00 DEBUG metabase.server.middleware.log GET /api/database 200 3.2 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (6 idle, 0 queued) (119 total active threads) Queries in flight: 0 (0 queued)
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:47:25-04:00 DEBUG metabase.server.middleware.log GET /api/automagic-dashboards/database/4/candidates 200 257.1 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (6 idle, 0 queued) (119 total active threads) Queries in flight: 0 (0 queued)
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:47:30-04:00 DEBUG metabase.server.middleware.log GET /api/collection/tree 200 1.5 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (6 idle, 0 queued) (119 total active threads) Queries in flight: 0 (0 queued)
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:47:30-04:00 DEBUG metabase.server.middleware.log GET /api/collection/8 200 1.4 ms (3 DB calls) App DB connections: 4/15 Jetty threads: 3/50 (6 idle, 0 queued) (119 total active threads) Queries in flight: 0 (0 queued)
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:47:30-04:00 DEBUG metabase.server.middleware.log GET /api/collection/8/items 200 33.9 ms (7 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (5 idle, 0 queued) (119 total active threads) Queries in flight: 0 (0 queued)
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:47:30-04:00 DEBUG metabase.server.middleware.log GET /api/collection/8/items 200 31.7 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (5 idle, 0 queued) (119 total active threads) Queries in flight: 0 (0 queued)
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:47:55-04:00 DEBUG metabase.server.middleware.log GET /api/card/21 200 11.1 ms (10 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (6 idle, 0 queued) (117 total active threads) Queries in flight: 0 (0 queued)
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:47:55-04:00 DEBUG metabase.server.middleware.log GET /api/alert/question/21 200 1.0 ms (1 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (6 idle, 0 queued) (117 total active threads) Queries in flight: 0 (0 queued)
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:47:55-04:00 DEBUG metabase.server.middleware.log GET /api/table/card__18/query_metadata 200 9.1 ms (5 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (6 idle, 0 queued) (117 total active threads) Queries in flight: 0 (0 queued)
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:47:56-04:00 INFO metabase.api.card Question's average execution duration is 1.5 s; using 'magic' TTL of 15.0 s :floppy_disk:
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:47:56-04:00 INFO metabase.query-processor.middleware.fetch-source-query Fetched source query from Card 18:
{:native
XXX
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:47:56-04:00 INFO metabase.query-processor.middleware.fetch-source-query Fetched source query from Card 18:
{:native
XXX
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:47:57-04:00 INFO metabase.query-processor.middleware.cache Query took 1.5 s to run; minimum for cache eligibility is 60.0 s
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:47:57-04:00 DEBUG metabase.server.middleware.log POST /api/card/21/query 202 [ASYNC: completed] 1.8 s (13 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (6 idle, 0 queued) (123 total active threads) Queries in flight: 0 (0 queued); mysql DB 4 connections: 0/8 (0 threads blocked)
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:48:04-04:00 INFO metabase.api.card Question's average execution duration is 23.0 s; using 'magic' TTL of 3.8 mins :floppy_disk:
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:48:04-04:00 INFO metabase.query-processor.middleware.fetch-source-query Fetched source query from Card 18:
{:native
XXXX
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:48:04-04:00 INFO metabase.query-processor.middleware.fetch-source-query Fetched source query from Card 18:
{:native
XXX
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:48:11-04:00 INFO metabase.api.card Question's average execution duration is 23.0 s; using 'magic' TTL of 3.8 mins :floppy_disk:
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:48:11-04:00 INFO metabase.query-processor.middleware.fetch-source-query Fetched source query from Card 18:
{:native
XXX
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:48:11-04:00 INFO metabase.query-processor.middleware.fetch-source-query Fetched source query from Card 18:
{:native
XX
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:48:11-04:00 DEBUG metabase.server.middleware.log POST /api/card/21/query/csv 202 [ASYNC: canceled] 7.0 s (11 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (6 idle, 0 queued) (123 total active threads) Queries in flight: 1 (0 queued); mysql DB 4 connections: 0/8 (0 threads blocked)
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:48:12-04:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 4,
:started_at #t "2022-04-01T13:48:04.774931Z[UTC]",
:via
[{:status :failed,
:class clojure.lang.ExceptionInfo,
:error "Error executing query",
:stacktrace
["--> driver.sql_jdbc.execute$execute_reducible_query$fn__52495.invoke(execute.clj:504)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:501)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:496)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
"driver.sql_jdbc$fn__85188.invokeStatic(sql_jdbc.clj:54)"
"driver.sql_jdbc$fn__85188.invoke(sql_jdbc.clj:52)"
"query_processor.context$executef.invokeStatic(context.clj:59)"
"query_processor.context$executef.invoke(context.clj:48)"
"query_processor.context.default$default_runf.invokeStatic(default.clj:68)"
"query_processor.context.default$default_runf.invoke(default.clj:66)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
"query_processor.reducible$pivot.invoke(reducible.clj:31)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__49148.invoke(mbql_to_native.clj:25)"
"query_processor.middleware.check_features$check_features$fn__49634.invoke(check_features.clj:39)"
"query_processor.middleware.limit$limit$fn__47521.invoke(limit.clj:37)"
"query_processor.middleware.cache$run_query_with_cache.invokeStatic(cache.clj:177)"
"query_processor.middleware.cache$run_query_with_cache.invoke(cache.clj:168)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__50008.invoke(cache.clj:203)"
"query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__51001.invoke(optimize_temporal_filters.clj:204)"
"query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__51045.invoke(validate_temporal_bucketing.clj:50)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__49205.invoke(auto_parse_filter_values.clj:43)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__39253.invoke(wrap_value_literals.clj:161)"
"query_processor.middleware.annotate$add_column_info$fn__43684.invoke(annotate.clj:620)"
"query_processor.middleware.permissions$check_query_permissions$fn__45622.invoke(permissions.clj:108)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__50185.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46020.invoke(cumulative_aggregations.clj:60)"
"query_processor.middleware.visualization_settings$update_viz_settings$fn__45958.invoke(visualization_settings.clj:62)"
"query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47119.invoke(resolve_joined_fields.clj:102)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__50771.invoke(resolve_joins.clj:171)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__50307.invoke(add_implicit_joins.clj:190)"
"query_processor.middleware.large_int_id$convert_id_to_string$fn__47138.invoke(large_int_id.clj:59)"
"query_processor.middleware.format_rows$format_rows$fn__50359.invoke(format_rows.clj:74)"
"query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__46510.invoke(add_default_temporal_unit.clj:23)"
"query_processor.middleware.desugar$desugar$fn__45931.invoke(desugar.clj:21)"
"query_processor.middleware.binning$update_binning_strategy$fn__39153.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__45265.invoke(resolve_fields.clj:34)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__49560.invoke(add_dimension_projections.clj:314)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__49857.invoke(add_implicit_clauses.clj:147)"
"query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__47506.invoke(upgrade_field_literals.clj:40)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__46887.invoke(add_source_metadata.clj:123)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__50107.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__48457.invoke(auto_bucket_datetimes.clj:147)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45246.invoke(resolve_source_table.clj:45)"
"query_processor.middleware.parameters$substitute_parameters$fn__48111.invoke(parameters.clj:111)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45319.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__51429.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__47890.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__50374.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49868$fn__49872.invoke(resolve_database_and_driver.clj:31)"
"driver$do_with_driver.invokeStatic(driver.clj:60)"
"driver$do_with_driver.invoke(driver.clj:56)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49868.invoke(resolve_database_and_driver.clj:25)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45869.invoke(fetch_source_query.clj:273)"
"query_processor.middleware.store$initialize_store$fn__46057$fn__46058.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:44)"
"query_processor.store$do_with_store.invoke(store.clj:38)"
"query_processor.middleware.store$initialize_store$fn__46057.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50157.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__50164.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__47836.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49134.invoke(results_metadata.clj:143)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__47854.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50143.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__50454.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___42504$thunk__42505.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___42504$fn__42507.invoke(reducible.clj:108)"],
:error_type :invalid-query,
:ex-data
{:sql
"-- Metabase:: userID: 11 queryType: MBQL queryHash: f974b207bd5043c24057ca22e428499cfd1fe31d4c142846c3c44e062587a9c2 XXXX
:params nil,
:type :invalid-query}}],
:state "70100",
:error_type :invalid-query,
:json_query
{:constraints nil,
:type :query,
:middleware
{:js-int-to-string? false,
:ignore-cached-results? true,
:process-viz-settings? true,
:skip-results-metadata? true,
:format-rows? false},
:database 4,
:query {:source-table "card__18"},
:parameters nil,
:async? true,
:cache-ttl 230},
:native nil,
:status :failed,
:class java.sql.SQLTimeoutException,
:stacktrace
["org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:47)"
"org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:153)"
"org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:274)"
"org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:363)"
"org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:501)"
"com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)"
"--> driver.sql_jdbc.execute$fn__52415.invokeStatic(execute.clj:368)"
"driver.sql_jdbc.execute$fn__52415.invoke(execute.clj:366)"
"driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:376)"
"driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invoke(execute.clj:373)"
"driver.sql_jdbc.execute$execute_reducible_query$fn__52495.invoke(execute.clj:502)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:501)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:496)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
"driver.sql_jdbc$fn__85188.invokeStatic(sql_jdbc.clj:54)"
"driver.sql_jdbc$fn__85188.invoke(sql_jdbc.clj:52)"
"query_processor.context$executef.invokeStatic(context.clj:59)"
"query_processor.context$executef.invoke(context.clj:48)"
"query_processor.context.default$default_runf.invokeStatic(default.clj:68)"
"query_processor.context.default$default_runf.invoke(default.clj:66)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
"query_processor.reducible$pivot.invoke(reducible.clj:31)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__49148.invoke(mbql_to_native.clj:25)"
"query_processor.middleware.check_features$check_features$fn__49634.invoke(check_features.clj:39)"
"query_processor.middleware.limit$limit$fn__47521.invoke(limit.clj:37)"
"query_processor.middleware.cache$run_query_with_cache.invokeStatic(cache.clj:177)"
"query_processor.middleware.cache$run_query_with_cache.invoke(cache.clj:168)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__50008.invoke(cache.clj:203)"
"query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__51001.invoke(optimize_temporal_filters.clj:204)"
"query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__51045.invoke(validate_temporal_bucketing.clj:50)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__49205.invoke(auto_parse_filter_values.clj:43)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__39253.invoke(wrap_value_literals.clj:161)"
"query_processor.middleware.annotate$add_column_info$fn__43684.invoke(annotate.clj:620)"
"query_processor.middleware.permissions$check_query_permissions$fn__45622.invoke(permissions.clj:108)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__50185.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46020.invoke(cumulative_aggregations.clj:60)"
"query_processor.middleware.visualization_settings$update_viz_settings$fn__45958.invoke(visualization_settings.clj:62)"
"query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47119.invoke(resolve_joined_fields.clj:102)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__50771.invoke(resolve_joins.clj:171)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__50307.invoke(add_implicit_joins.clj:190)"
"query_processor.middleware.large_int_id$convert_id_to_string$fn__47138.invoke(large_int_id.clj:59)"
"query_processor.middleware.format_rows$format_rows$fn__50359.invoke(format_rows.clj:74)"
"query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__46510.invoke(add_default_temporal_unit.clj:23)"
"query_processor.middleware.desugar$desugar$fn__45931.invoke(desugar.clj:21)"
"query_processor.middleware.binning$update_binning_strategy$fn__39153.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__45265.invoke(resolve_fields.clj:34)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__49560.invoke(add_dimension_projections.clj:314)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__49857.invoke(add_implicit_clauses.clj:147)"
"query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__47506.invoke(upgrade_field_literals.clj:40)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__46887.invoke(add_source_metadata.clj:123)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__50107.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__48457.invoke(auto_bucket_datetimes.clj:147)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45246.invoke(resolve_source_table.clj:45)"
"query_processor.middleware.parameters$substitute_parameters$fn__48111.invoke(parameters.clj:111)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45319.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__51429.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__47890.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__50374.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49868$fn__49872.invoke(resolve_database_and_driver.clj:31)"
"driver$do_with_driver.invokeStatic(driver.clj:60)"
"driver$do_with_driver.invoke(driver.clj:56)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49868.invoke(resolve_database_and_driver.clj:25)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45869.invoke(fetch_source_query.clj:273)"
"query_processor.middleware.store$initialize_store$fn__46057$fn__46058.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:44)"
"query_processor.store$do_with_store.invoke(store.clj:38)"
"query_processor.middleware.store$initialize_store$fn__46057.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50157.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__50164.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__47836.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49134.invoke(results_metadata.clj:143)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__47854.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50143.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__50454.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___42504$thunk__42505.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___42504$fn__42507.invoke(reducible.clj:108)"],
:card_id 21,
:context :csv-download,
:error "(conn=15) Query execution was interrupted",
:row_count 0,
:running_time 0,
:preprocessed
{:type :query,
:middleware
{:js-int-to-string? false,
:ignore-cached-results? true,
:process-viz-settings? true,
:skip-results-metadata? true,
:format-rows? false},
:info
{:executed-by 11,
:context :csv-download,
:card-id 21,
:card-name "Claim Line Views Drill Down",
:query-hash
[-7, 116, -78, 7, -67, 80, 67, -62, 64, 87, -54, 34, -28, 40, 73, -100, -3, 31, -29, 29, 76, 20, 40, 70, -61, -60,
78, 6, 37, -121, -87, -62]},
:database 4,
:query
{:source-metadata
[{:name "GroupName",
:display_name "GroupName",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:field "GroupName" {:base-type :type/Text}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 3, :nil% 0.0815},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 21.5255}}}}
{:name "ClaimID",
:display_name "ClaimID",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:field "ClaimID" {:base-type :type/Text}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 696, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 12.031}}}}
{:name "ClaimStatus",
:display_name "ClaimStatus",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:field "ClaimStatus" {:base-type :type/Text}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 10, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 9.118}}}}
{:name "ClaimEntryDate",
:display_name "ClaimEntryDate",
:base_type :type/DateTime,
:effective_type :type/DateTime,
:field_ref [:field "ClaimEntryDate" {:base-type :type/DateTime, :temporal-unit :default}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 20, :nil% 0.0},
:type {:type/DateTime {:earliest "2022-01-03T00:00:00Z", :latest "2022-03-14T00:00:00Z"}}}}
{:name "ClaimStatusCode",
:display_name "ClaimStatusCode",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:field "ClaimStatusCode" {:base-type :type/Text}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 30, :nil% 0.7555},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 0.945}}}}
{:name "FormType",
:display_name "FormType",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:field "FormType" {:base-type :type/Text}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 2, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.0}}}}
{:name "Institutional Claim Type",
:display_name "Institutional Claim Type",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:field "Institutional Claim Type" {:base-type :type/Text}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 3, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 3.175}}}}
{:name "TypeofBill",
:display_name "TypeofBill",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:field "TypeofBill" {:base-type :type/Text}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 4, :nil% 0.682},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 0.954}}}}
{:name "MemberID",
:display_name "MemberID",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:field "MemberID" {:base-type :type/Text}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 573, :nil% 0.0815},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 8.269}}}}
{:name "BenefitPlanID",
:display_name "BenefitPlanID",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:field "BenefitPlanID" {:base-type :type/Text}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 15, :nil% 0.0815},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 8.2665}}}}
{:name "BenefitPlanName",
:display_name "BenefitPlanName",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:field "BenefitPlanName" {:base-type :type/Text}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 14, :nil% 0.0815},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 47.25}}}}
{:name "MasterContractName",
:display_name "MasterContractName",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:field "MasterContractName" {:base-type :type/Text}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 9, :nil% 0.1695},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 12.016}}}}
{:name "Contract Liberary",
:display_name "Contract Liberary",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:field "Contract Liberary" {:base-type :type/Text}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 10, :nil% 0.1695},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 12.7005}}}}
{:name "BillingVendorEIN",
:display_name "BillingVendorEIN",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:field "BillingVendorEIN" {:base-type :type/Text}],
:semantic_type :type/Company,
:fingerprint
{:global {:distinct-count 132, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 9.0}}}}
{:name "BillingVendorNPI",
:display_name "BillingVendorNPI",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:field "BillingVendorNPI" {:base-type :type/Text}],
:semantic_type :type/Company,
:fingerprint
{:global {:distinct-count 144, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 10.0}}}}
{:name "BillingVendorID",
:display_name "BillingVendorID",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:field "BillingVendorID" {:base-type :type/Text}],
:semantic_type :type/Company,
:fingerprint
{:global {:distinct-count 145, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 9.0}}}}
{:name "Name",
:display_name "Name",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:field "Name" {:base-type :type/Text}],
:semantic_type :type/Name,
:fingerprint
{:global {:distinct-count 140, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 31.2}}}}
{:name "LineNumber",
:display_name "LineNumber",
:base_type :type/Integer,
:effective_type :type/Integer,
:field_ref [:field "LineNumber" {:base-type :type/Integer}],
:semantic_type :type/Quantity,
:fingerprint
{:global {:distinct-count 32, :nil% 0.0},
:type
{:type/Number
{:min 1.0, :q1 1.12898666674863, :q3 5.086989711367286, :max 32.0, :sd 4.522911464317761, :avg 4.0005}}}}
{:name "LineStatus",
:display_name "LineStatus",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:field "LineStatus" {:base-type :type/Text}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 3, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 1.0}}}}
{:name "LineBilled",
:display_name "LineBilled",
:base_type :type/Decimal,
:effective_type :type/Decimal,
:field_ref [:field "LineBilled" {:base-type :type/Decimal}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 542, :nil% 0.0},
:type
{:type/Number
{:min 0.0,
:q1 59.94215927405192,
:q3 359.2222898090568,
:max 46000.0,
:sd 1978.1063648017953,
:avg 487.15314}}}}
{:name "ServiceFromDate",
:display_name "ServiceFromDate",
:base_type :type/Date,
:effective_type :type/Date,
:field_ref [:field "ServiceFromDate" {:base-type :type/Date, :temporal-unit :default}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 31, :nil% 0.0},
:type {:type/DateTime {:earliest "2021-04-01T00:00:00Z", :latest "2022-02-28T00:00:00Z"}}}}
{:name "ServiceThruDate",
:display_name "ServiceThruDate",
:base_type :type/Date,
:effective_type :type/Date,
:field_ref [:field "ServiceThruDate" {:base-type :type/Date, :temporal-unit :default}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 31, :nil% 0.0},
:type {:type/DateTime {:earliest "2021-04-01T00:00:00Z", :latest "2022-02-28T00:00:00Z"}}}}
{:name "ServiceCode",
:display_name "ServiceCode",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:field "ServiceCode" {:base-type :type/Text}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 344, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 4.9445}}}}
{:name "LineContractAllowed",
:display_name "LineContractAllowed",
:base_type :type/Decimal,
:effective_type :type/Decimal,
:field_ref [:field "LineContractAllowed" {:base-type :type/Decimal}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 423, :nil% 0.0},
:type
{:type/Number
{:min 0.0,
:q1 0.9241373600627509,
:q3 114.67993817298309,
:max 21966.0,
:sd 848.869444159742,
:avg 104.77821500000002}}}}
{:name "LineAllowed",
:display_name "LineAllowed",
:base_type :type/Decimal,
:effective_type :type/Decimal,
:field_ref [:field "LineAllowed" {:base-type :type/Decimal}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 416, :nil% 0.0},
:type
{:type/Number
{:min 0.0,
:q1 0.8312365221405125,
:q3 114.2874839854918,
:max 21966.0,
:sd 848.8863175001047,
:avg 104.15609500000002}}}}
{:name "LineNotAllowed",
:display_name "LineNotAllowed",
:base_type :type/Decimal,
:effective_type :type/Decimal,
:field_ref [:field "LineNotAllowed" {:base-type :type/Decimal}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 3, :nil% 0.0},
:type {:type/Number {:min 0.0, :q1 0.0, :q3 14.696255944819228, :max 90.0, :sd 2.301683921488183, :avg 0.07}}}}
{:name "LineDeductible",
:display_name "LineDeductible",
:base_type :type/Decimal,
:effective_type :type/Decimal,
:field_ref [:field "LineDeductible" {:base-type :type/Decimal}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 0.0},
:type {:type/Number {:min 0.0, :q1 0.0, :q3 0.0, :max 0.0, :sd 0.0, :avg 0.0}}}}
{:name "LineCopayment",
:display_name "LineCopayment",
:base_type :type/Decimal,
:effective_type :type/Decimal,
:field_ref [:field "LineCopayment" {:base-type :type/Decimal}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 52, :nil% 0.0},
:type
{:type/Number
{:min 0.0, :q1 0.0, :q3 0.2804869391845587, :max 225.0, :sd 19.672132047766265, :avg 5.689570000000001}}}}
{:name "LineCoinsurance",
:display_name "LineCoinsurance",
:base_type :type/Decimal,
:effective_type :type/Decimal,
:field_ref [:field "LineCoinsurance" {:base-type :type/Decimal}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 57, :nil% 0.0},
:type
{:type/Number {:min 0.0, :q1 0.0, :q3 0.006648548948411508, :max 4393.2, :sd 169.27323702768643, :avg 8.92834}}}}
{:name "LineMemberObligation",
:display_name "LineMemberObligation",
:base_type :type/Decimal,
:effective_type :type/Decimal,
:field_ref [:field "LineMemberObligation" {:base-type :type/Decimal}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 195, :nil% 0.0},
:type
{:type/Number
{:min 0.0,
:q1 0.018536800383390915,
:q3 4.685161805524886,
:max 4972.25,
:sd 290.9149950161147,
:avg 47.32088}}}}
{:name "LineOOPAmount",
:display_name "LineOOPAmount",
:base_type :type/Decimal,
:effective_type :type/Decimal,
:field_ref [:field "LineOOPAmount" {:base-type :type/Decimal}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 110, :nil% 0.0},
:type
{:type/Number
{:min 0.0,
:q1 8.369333982014074E-4,
:q3 0.2777987253760902,
:max 4393.2,
:sd 170.13422586843515,
:avg 14.722405}}}}
{:name "LinePaid",
:display_name "LinePaid",
:base_type :type/Decimal,
:effective_type :type/Decimal,
:field_ref [:field "LinePaid" {:base-type :type/Decimal}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 445, :nil% 0.0},
:type
{:type/Number
{:min 0.0,
:q1 0.6080737277350206,
:q3 102.09601222268816,
:max 17572.8,
:sd 680.0876564597514,
:avg 88.51007000000001}}}}
{:name "LineSequestrationAmount",
:display_name "LineSequestrationAmount",
:base_type :type/Decimal,
:effective_type :type/Decimal,
:field_ref [:field "LineSequestrationAmount" {:base-type :type/Decimal}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 0.0},
:type {:type/Number {:min 0.0, :q1 0.0, :q3 0.0, :max 0.0, :sd 0.0, :avg 0.0}}}}
{:name "Event Code",
:display_name "Event Code",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:field "Event Code" {:base-type :type/Text}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 21, :nil% 0.8365},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 0.509}}}}
{:name "Event Desc",
:display_name "Event Desc",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:field "Event Desc" {:base-type :type/Text}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 24, :nil% 0.8365},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 14.4265}}}}
{:name "Service Definition",
:display_name "Service Definition",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:field "Service Definition" {:base-type :type/Text}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 22, :nil% 0.185},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 10.0235}}}}
{:name "Benefit Definition",
:display_name "Benefit Definition",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:field "Benefit Definition" {:base-type :type/Text}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 40, :nil% 0.21},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 15.854}}}}
{:name "FeeScheduleName",
:display_name "FeeScheduleName",
:base_type :type/Text,
:effective_type :type/Text,
:field_ref [:field "FeeScheduleName" {:base-type :type/Text}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 9, :nil% 0.281},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 19.8145}}}}],
:fields
[[:field "GroupName" {:base-type :type/Text}]
[:field "ClaimID" {:base-type :type/Text}]
[:field "ClaimStatus" {:base-type :type/Text}]
[:field "ClaimEntryDate" {:base-type :type/DateTime, :temporal-unit :default}]
[:field "ClaimStatusCode" {:base-type :type/Text}]
[:field "FormType" {:base-type :type/Text}]
[:field "Institutional Claim Type" {:base-type :type/Text}]
[:field "TypeofBill" {:base-type :type/Text}]
[:field "MemberID" {:base-type :type/Text}]
[:field "BenefitPlanID" {:base-type :type/Text}]
[:field "BenefitPlanName" {:base-type :type/Text}]
[:field "MasterContractName" {:base-type :type/Text}]
[:field "Contract Liberary" {:base-type :type/Text}]
[:field "BillingVendorEIN" {:base-type :type/Text}]
[:field "BillingVendorNPI" {:base-type :type/Text}]
[:field "BillingVendorID" {:base-type :type/Text}]
[:field "Name" {:base-type :type/Text}]
[:field "LineNumber" {:base-type :type/Integer}]
[:field "LineStatus" {:base-type :type/Text}]
[:field "LineBilled" {:base-type :type/Decimal}]
[:field "ServiceFromDate" {:base-type :type/Date, :temporal-unit :default}]
[:field "ServiceThruDate" {:base-type :type/Date, :temporal-unit :default}]
[:field "ServiceCode" {:base-type :type/Text}]
[:field "LineContractAllowed" {:base-type :type/Decimal}]
[:field "LineAllowed" {:base-type :type/Decimal}]
[:field "LineNotAllowed" {:base-type :type/Decimal}]
[:field "LineDeductible" {:base-type :type/Decimal}]
[:field "LineCopayment" {:base-type :type/Decimal}]
[:field "LineCoinsurance" {:base-type :type/Decimal}]
[:field "LineMemberObligation" {:base-type :type/Decimal}]
[:field "LineOOPAmount" {:base-type :type/Decimal}]
[:field "LinePaid" {:base-type :type/Decimal}]
[:field "LineSequestrationAmount" {:base-type :type/Decimal}]
[:field "Event Code" {:base-type :type/Text}]
[:field "Event Desc" {:base-type :type/Text}]
[:field "Service Definition" {:base-type :type/Text}]
[:field "Benefit Definition" {:base-type :type/Text}]
[:field "FeeScheduleName" {:base-type :type/Text}]],
:source-query
{:native
XXX
:limit 1048575},
:async? true,
:cache-ttl 230},
:data {:rows [], :cols []}}

[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:48:28-04:00 INFO metabase.query-processor.middleware.cache.impl Results are too large to cache. :tired_face:
[b0458b95-2066-4d78-b4dd-d0bffb4889d7] 2022-04-01T09:48:28-04:00 INFO metabase.query-processor.middleware.cache.impl Results are too large to cache. :tired_face:

4

@jayv The error comes from your MySQL - it is sending a timeout error to Metabase:
https://stackoverflow.com/questions/17824486/mysql-query-timing-out-70100-query-execution-was-interrupted

5

Thanks we found a potential issue with RDS which we are reviewing with AWS on. I will close this once we have are able to resolve and confirm.

6

Here are some logs... Could you also check this. I don't see any error but the same message comes to me too. Error displaying this chart.

[5370b8b1-4e83-479d-a202-6f2a7a317a28] 2023-08-07T15:44:50+05:30 INFO metabase.query-processor.card Question's average execution duration is 6.1 s; using 'magic' TTL of 1.0 mins :floppy_disk:
[5370b8b1-4e83-479d-a202-6f2a7a317a28] 2023-08-07T15:44:50+05:30 INFO metabase.query-processor.card Question's average execution duration is 6.2 s; using 'magic' TTL of 1.0 mins :floppy_disk:
[5370b8b1-4e83-479d-a202-6f2a7a317a28] 2023-08-07T15:44:50+05:30 INFO metabase.query-processor.card Question's average execution duration is 6.0 s; using 'magic' TTL of 60.0 s :floppy_disk:
[5370b8b1-4e83-479d-a202-6f2a7a317a28] 2023-08-07T15:44:50+05:30 INFO metabase.query-processor.card Question's average execution duration is 30.1 s; using 'magic' TTL of 5.0 mins :floppy_disk:
[5370b8b1-4e83-479d-a202-6f2a7a317a28] 2023-08-07T15:44:50+05:30 INFO metabase.query-processor.card Question's average execution duration is 370.0 ms; using 'magic' TTL of 4.0 s :floppy_disk:
[5370b8b1-4e83-479d-a202-6f2a7a317a28] 2023-08-07T15:44:50+05:30 INFO metabase.query-processor.card Question's average execution duration is 6.0 s; using 'magic' TTL of 60.0 s :floppy_disk:
[5370b8b1-4e83-479d-a202-6f2a7a317a28] 2023-08-07T15:45:50+05:30 DEBUG metabase.server.middleware.log POST /api/dashboard/89/dashcard/624/card/579/query 202 [ASYNC: canceled] 1.0 mins (13 DB calls) App DB connections: 0/15 Jetty threads: 6/50 (4 idle, 0 queued) (506 total active threads) Queries in flight: 17 (0 queued); postgres DB 18 connections: 15/15 (283 threads blocked)
[5370b8b1-4e83-479d-a202-6f2a7a317a28] 2023-08-07T15:45:50+05:30 DEBUG metabase.server.middleware.log POST /api/dashboard/89/dashcard/625/card/653/query 202 [ASYNC: canceled] 1.0 mins (13 DB calls) App DB connections: 0/15 Jetty threads: 6/50 (4 idle, 0 queued) (506 total active threads) Queries in flight: 17 (0 queued); postgres DB 18 connections: 15/15 (286 threads blocked)
[5370b8b1-4e83-479d-a202-6f2a7a317a28] 2023-08-07T15:45:50+05:30 DEBUG metabase.server.middleware.log POST /api/dashboard/89/dashcard/626/card/581/query 202 [ASYNC: canceled] 1.0 mins (13 DB calls) App DB connections: 0/15 Jetty threads: 6/50 (4 idle, 0 queued) (506 total active threads) Queries in flight: 17 (0 queued); postgres DB 18 connections: 15/15 (283 threads blocked)
[5370b8b1-4e83-479d-a202-6f2a7a317a28] 2023-08-07T15:45:50+05:30 DEBUG metabase.server.middleware.log POST /api/dashboard/89/dashcard/628/card/654/query 202 [ASYNC: canceled] 1.0 mins (13 DB calls) App DB connections: 0/15 Jetty threads: 6/50 (4 idle, 0 queued) (506 total active threads) Queries in flight: 17 (0 queued); postgres DB 18 connections: 15/15 (287 threads blocked)
[5370b8b1-4e83-479d-a202-6f2a7a317a28] 2023-08-07T15:45:50+05:30 DEBUG metabase.server.middleware.log POST /api/dashboard/89/dashcard/627/card/582/query 202 [ASYNC: canceled] 1.0 mins (13 DB calls) App DB connections: 0/15 Jetty threads: 6/50 (4 idle, 0 queued) (506 total active threads) Queries in flight: 16 (0 queued); postgres DB 18 connections: 15/15 (283 threads blocked)
[5370b8b1-4e83-479d-a202-6f2a7a317a28] 2023-08-07T15:45:50+05:30 DEBUG metabase.server.middleware.log POST /api/dashboard/89/dashcard/630/card/656/query 202 [ASYNC: canceled] 1.0 mins (18 DB calls) App DB connections: 0/15 Jetty threads: 6/50 (4 idle, 0 queued) (506 total active threads) Queries in flight: 15 (0 queued); postgres DB 18 connections: 15/15 (288 threads blocked)
[5370b8b1-4e83-479d-a202-6f2a7a317a28] 2023-08-07T15:45:58+05:30 DEBUG metabase.server.middleware.log GET /api/session/properties 200 25.7 ms (4 DB calls) App DB connections: 1/15 Jetty threads: 9/50 (1 idle, 0 queued) (506 total active threads) Queries in flight: 15 (0 queued)
[5370b8b1-4e83-479d-a202-6f2a7a317a28] 2023-08-07T15:45:58+05:30 DEBUG metabase.server.middleware.log GET /api/setting 200 34.9 ms (5 DB calls) App DB connections: 1/15 Jetty threads: 9/50 (1 idle, 0 queued) (506 total active threads) Queries in flight: 15 (0 queued)
[5370b8b1-4e83-479d-a202-6f2a7a317a28] 2023-08-07T15:45:58+05:30 DEBUG metabase.server.middleware.log GET /api/setup/admin_checklist 200 109.3 ms (10 DB calls) App DB connections: 0/15 Jetty threads: 7/50 (3 idle, 0 queued) (508 total active threads) Queries in flight: 15 (0 queued)
[5370b8b1-4e83-479d-a202-6f2a7a317a28] 2023-08-07T15:46:01+05:30 DEBUG metabase.server.middleware.log GET /api/util/bug_report_details 200 16.9 ms (1 DB calls) App DB connections: 0/15 Jetty threads: 7/50 (3 idle, 0 queued) (508 total active threads) Queries in flight: 15 (0 queued)

7

Please upgrade to the latest version