Hello,
I linked my dashboards to MongoDB metabase, but for more complex queries, both loading singularly or placed in a dashboard, I often get the "There was a problem displaying this chart.".
With many refreshes of the page I can make it go away and load everything correctly, but how can I get rid of it on the first load. I don't mind my query taking minutes to load the first time, if it gives the right result instead of the error.
Here's the log of an occurence, where only 1 out of 4 graphs loaded, the other 3 needed some refreshes.
[9c82b324-f40a-4366-b1bc-af166a60ec58] 2022-12-14T14:08:40+01:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 18.3 ms (10 Chiamate DB) Connessioni DB App: 1/15 Threads Jetty: 4/50 (11 inattivo/i, 0 accodato/i) (170 thread attivi totale/i) Query in partenza: 0 (0 accodato/i)
[9c82b324-f40a-4366-b1bc-af166a60ec58] 2022-12-14T14:08:40+01:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 26.2 ms (4 Chiamate DB) Connessioni DB App: 0/15 Threads Jetty: 3/50 (12 inattivo/i, 0 accodato/i) (170 thread attivi totale/i) Query in partenza: 0 (0 accodato/i)
[9c82b324-f40a-4366-b1bc-af166a60ec58] 2022-12-14T14:08:41+01:00 DEBUG metabase.server.middleware.log GET /api/collection/root 200 3.1 ms (2 Chiamate DB) Connessioni DB App: 0/15 Threads Jetty: 3/50 (12 inattivo/i, 0 accodato/i) (170 thread attivi totale/i) Query in partenza: 0 (0 accodato/i)
[9c82b324-f40a-4366-b1bc-af166a60ec58] 2022-12-14T14:08:41+01:00 DEBUG metabase.server.middleware.log GET /api/bookmark 200 3.3 ms (1 Chiamate DB) Connessioni DB App: 4/15 Threads Jetty: 7/50 (8 inattivo/i, 0 accodato/i) (170 thread attivi totale/i) Query in partenza: 0 (0 accodato/i)
[9c82b324-f40a-4366-b1bc-af166a60ec58] 2022-12-14T14:08:41+01:00 DEBUG metabase.server.middleware.log GET /api/database 200 7.9 ms (3 Chiamate DB) Connessioni DB App: 3/15 Threads Jetty: 7/50 (8 inattivo/i, 0 accodato/i) (170 thread attivi totale/i) Query in partenza: 0 (0 accodato/i)
[9c82b324-f40a-4366-b1bc-af166a60ec58] 2022-12-14T14:08:41+01:00 DEBUG metabase.server.middleware.log GET /api/util/bug_report_details 200 7.0 ms (1 Chiamate DB) Connessioni DB App: 0/15 Threads Jetty: 6/50 (9 inattivo/i, 0 accodato/i) (170 thread attivi totale/i) Query in partenza: 0 (0 accodato/i)
[9c82b324-f40a-4366-b1bc-af166a60ec58] 2022-12-14T14:08:41+01:00 DEBUG metabase.server.middleware.log GET /api/collection/tree 200 18.7 ms (7 Chiamate DB) Connessioni DB App: 0/15 Threads Jetty: 5/50 (10 inattivo/i, 0 accodato/i) (170 thread attivi totale/i) Query in partenza: 0 (0 accodato/i)
[9c82b324-f40a-4366-b1bc-af166a60ec58] 2022-12-14T14:08:41+01:00 DEBUG metabase.server.middleware.log GET /api/dashboard/10 200 41.5 ms (13 Chiamate DB) Connessioni DB App: 2/15 Threads Jetty: 3/50 (12 inattivo/i, 0 accodato/i) (170 thread attivi totale/i) Query in partenza: 0 (0 accodato/i)
[9c82b324-f40a-4366-b1bc-af166a60ec58] 2022-12-14T14:08:41+01:00 DEBUG metabase.server.middleware.log GET /api/collection/2 200 6.3 ms (4 Chiamate DB) Connessioni DB App: 0/15 Threads Jetty: 3/50 (12 inattivo/i, 0 accodato/i) (170 thread attivi totale/i) Query in partenza: 0 (0 accodato/i)
[9c82b324-f40a-4366-b1bc-af166a60ec58] 2022-12-14T14:08:47+01:00 DEBUG metabase.server.middleware.log POST /api/dashboard/10/dashcard/104/card/21/query 202 [Asincrono: completed] 6.1 s (14 Chiamate DB) Connessioni DB App: 2/15 Threads Jetty: 2/50 (13 inattivo/i, 0 accodato/i) (185 thread attivi totale/i) Query in partenza: 3 (0 accodato/i)
[9c82b324-f40a-4366-b1bc-af166a60ec58] 2022-12-14T14:08:57+01:00 ERROR metabase.query-processor.middleware.catch-exceptions Errore elaborazione query: Closed
{:database_id 6,
:started_at #t "2022-12-14T13:06:23.337935Z[UTC]",
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :native,
:middleware {:js-int-to-string? true, :ignore-cached-results? false},
:native
{:query
"[\n {\n \"$match\": {\n \"$and\": [\n {\n \"event_datum.type\": \"page_load_time\"\n },\n {\n \"$expr\": {\n \"$gte\": [\n \"$event_datum.ts\",\n {\n \"$subtract\": [ISODate(), { $multiply: [ 6, 31, 24, 60, 60, 1000 ] }]\n }\n ]\n }\n },\n {\n \"$expr\": {\n \"$ne\": [\n {\"$month\": \"$event_datum.ts\"},\n {\"$month\": \n {\n \"$subtract\": [ISODate(), { $multiply: [ 6, 31, 24, 60, 60, 1000 ] }]\n }}\n ]\n }\n },\n {\n \"$or\": [\n {\n \"event_datum.message\": \"Load Agenda from storage\"\n },\n {\n \"event_datum.message\": \"Load contacts GDP from storage\"\n },\n {\n \"event_datum.message\": \"Load HomePage KPI from storage\"\n },\n {\n \"event_datum.message\": \"Load Tasks from storage\"\n },\n {\n \"event_datum.message\": \"Load Contraente\"\n },\n {\n \"event_datum.message\": \"Load configurazione proposta\"\n },\n {\n \"event_datum.message\": \"Load Bisogni from cache\"\n },\n {\n \"event_datum.message\": \"Load sign page\"\n },\n {\n \"event_datum.message\": \"Load Beneficiari\"\n },\n {\n \"event_datum.message\": \"Load Prodotti from cache\"\n },\n {\n \"event_datum.message\": \"Salva Soggetto service\"\n }\n ]\n }\n ]\n }\n },\n { \"$unwind\": \"$event_datum.params\" },\n {\n \"$group\": {\n \"_id\": {\n \"component\": \"$event_datum.message\",\n \"month\": {\n \"$let\": {\n \"vars\": {\n \"parts\": {\n \"$dateToParts\": {\n \"timezone\": \"Europe/Rome\",\n \"date\": \"$event_datum.ts\"\n }\n }\n },\n \"in\": {\n \"$dateFromParts\": {\n \"timezone\": \"Europe/Rome\",\n \"year\": \"$$parts.year\",\n \"month\": \"$$parts.month\"\n }\n }\n }\n }\n },\n\n \"avg\": {\n \"$avg\": { \"$toLong\": \"$event_datum.params.total\" }\n }\n }\n },\n {\n \"$sort\": {\n \"_id\": 1\n }\n },\n {\n \"$project\": {\n \"_id\": false,\n \"component\": \"$_id.component\",\n \"month\": \"$_id.month\",\n \"avg\": true\n }\n },\n {\n \"$sort\": {\n \"event_datum.message\": 1\n }\n }\n]",
:collection "events",
:template-tags {}},
:database 6,
:parameters [],
:async? true,
:cache-ttl nil},
:status :failed,
:class org.eclipse.jetty.io.EofException,
:stacktrace
["org.eclipse.jetty.server.HttpOutput.checkWritable(HttpOutput.java:765)"
"org.eclipse.jetty.server.HttpOutput.write(HttpOutput.java:795)"
"java.base/java.io.OutputStream.write(Unknown Source)"
"java.base/java.util.zip.GZIPOutputStream.writeHeader(Unknown Source)"
"java.base/java.util.zip.GZIPOutputStream.<init>(Unknown Source)"
"java.base/java.util.zip.GZIPOutputStream.<init>(Unknown Source)"
"--> async.streaming_response$output_stream_delay$fn__19016.invoke(streaming_response.clj:107)"
"async.streaming_response$delay_output_stream$fn__19025.invoke(streaming_response.clj:124)"
"async.streaming_response.proxy$java.io.OutputStream$ff19274a.write(Unknown Source)"
"query_processor.streaming.json$fn$reify__39271.finish_BANG_(json.clj:91)"
"query_processor.streaming$streaming_reducedf$fn__40050.invoke(streaming.clj:128)"
"query_processor.context$reducedf.invokeStatic(context.clj:77)"
"query_processor.context$reducedf.invoke(context.clj:72)"
"query_processor.context.default$default_reducef.invokeStatic(default.clj:63)"
"query_processor.context.default$default_reducef.invoke(default.clj:48)"
"query_processor.context$reducef.invokeStatic(context.clj:69)"
"query_processor.context$reducef.invoke(context.clj:62)"
"query_processor.context.default$default_runf$respond_STAR___39182.invoke(default.clj:68)"
"driver.mongo.execute$reduce_results.invokeStatic(execute.clj:138)"
"driver.mongo.execute$reduce_results.invoke(execute.clj:131)"
"driver.mongo.execute$execute_reducible_query.invokeStatic(execute.clj:169)"
"driver.mongo.execute$execute_reducible_query.invoke(execute.clj:157)"
"driver.mongo$fn__96261$f__94586__auto____96262.invoke(mongo.clj:238)"
"driver.mongo.util$do_with_mongo_connection$fn__94577.invoke(util.clj:226)"
"util.ssh$do_with_ssh_tunnel.invokeStatic(ssh.clj:134)"
"util.ssh$do_with_ssh_tunnel.invoke(ssh.clj:123)"
"driver.mongo.util$do_with_mongo_connection.invokeStatic(util.clj:220)"
"driver.mongo.util$do_with_mongo_connection.invoke(util.clj:215)"
"driver.mongo$fn__96261.invokeStatic(mongo.clj:237)"
"driver.mongo$fn__96261.invoke(mongo.clj:235)"
"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:67)"
"query_processor.context.default$default_runf.invoke(default.clj:65)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)"
"query_processor.reducible$identity_qp.invoke(reducible.clj:9)"
"query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___52623.invoke(cache.clj:220)"
"query_processor.middleware.permissions$check_query_permissions$fn__48144.invoke(permissions.clj:109)"
"metabase_enterprise.advanced_permissions.query_processor.middleware.permissions$check_download_permissions$fn__85604.invoke(permissions.clj:124)"
"metabase_enterprise.sandbox.query_processor.middleware.column_level_perms_check$maybe_apply_column_level_perms_check$fn__87408.invoke(column_level_perms_check.clj:30)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__51568.invoke(mbql_to_native.clj:23)"
"query_processor$fn__54099$combined_post_process__54104$combined_post_process_STAR___54105.invoke(query_processor.clj:212)"
"query_processor$fn__54099$combined_pre_process__54100$combined_pre_process_STAR___54101.invoke(query_processor.clj:209)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52544$fn__52549.invoke(resolve_database_and_driver.clj:35)"
"driver$do_with_driver.invokeStatic(driver.clj:75)"
"driver$do_with_driver.invoke(driver.clj:71)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52544.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__48579.invoke(fetch_source_query.clj:353)"
"query_processor.middleware.store$initialize_store$fn__48767$fn__48768.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__48767.invoke(store.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__52816.invoke(normalize_query.clj:22)"
"metabase_enterprise.audit_app.query_processor.middleware.handle_audit_queries$handle_internal_queries$fn__59641.invoke(handle_audit_queries.clj:130)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__49849.invoke(constraints.clj:53)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__52755.invoke(process_userland_query.clj:145)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__53127.invoke(catch_exceptions.clj:167)"
"query_processor.reducible$async_qp$qp_STAR___44982$thunk__44984.invoke(reducible.clj:100)"
"query_processor.reducible$async_qp$qp_STAR___44982$fn__44986.invoke(reducible.clj:105)"],
:card_id 35,
:context :dashboard,
:error "Closed",
:row_count 0,
:running_time 0,
:data {:rows [], :cols []}}
[9c82b324-f40a-4366-b1bc-af166a60ec58] 2022-12-14T14:09:02+01:00 ERROR metabase.query-processor.middleware.catch-exceptions Errore elaborazione query: Closed
{:database_id 6,
:started_at #t "2022-12-14T13:07:17.439050Z[UTC]",
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :native,
:middleware {:js-int-to-string? true, :ignore-cached-results? false},
:native
{:query
"[\n {\n \"$match\": {\n \"$and\": [\n {\n \"event_datum.type\": \"page_load_time\"\n },\n {\n \"$expr\": {\n \"$gte\": [\n \"$event_datum.ts\",\n {\n \"$subtract\": [ISODate(), { $multiply: [ 6, 31, 24, 60, 60, 1000 ] }]\n }\n ]\n }\n },\n {\n \"$expr\": {\n \"$ne\": [\n {\"$month\": \"$event_datum.ts\"},\n {\"$month\": \n {\n \"$subtract\": [ISODate(), { $multiply: [ 6, 31, 24, 60, 60, 1000 ] }]\n }}\n ]\n }\n },\n {\n \"$or\": [\n {\n \"event_datum.message\": \"Load Agenda from storage\"\n },\n {\n \"event_datum.message\": \"Load contacts GDP from storage\"\n },\n {\n \"event_datum.message\": \"Load HomePage KPI from storage\"\n },\n {\n \"event_datum.message\": \"Load Tasks from storage\"\n },\n {\n \"event_datum.message\": \"Load Contraente\"\n },\n {\n \"event_datum.message\": \"Load configurazione proposta\"\n },\n {\n \"event_datum.message\": \"Load Bisogni from cache\"\n },\n {\n \"event_datum.message\": \"Load sign page\"\n },\n {\n \"event_datum.message\": \"Load Beneficiari\"\n },\n {\n \"event_datum.message\": \"Load Prodotti from cache\"\n },\n {\n \"event_datum.message\": \"Salva Soggetto service\"\n }\n ]\n }\n ]\n }\n },\n { \"$unwind\": \"$event_datum.params\" },\n {\n \"$group\": {\n \"_id\": {\n \"component\": \"$event_datum.message\",\n \"month\": {\n \"$let\": {\n \"vars\": {\n \"parts\": {\n \"$dateToParts\": {\n \"timezone\": \"Europe/Rome\",\n \"date\": \"$event_datum.ts\"\n }\n }\n },\n \"in\": {\n \"$dateFromParts\": {\n \"timezone\": \"Europe/Rome\",\n \"year\": \"$$parts.year\",\n \"month\": \"$$parts.month\"\n }\n }\n }\n }\n },\n\n \"avg\": {\n \"$avg\": { \"$toLong\": \"$event_datum.params.total\" }\n }\n }\n },\n {\n \"$sort\": {\n \"_id\": 1\n }\n },\n {\n \"$project\": {\n \"_id\": false,\n \"component\": \"$_id.component\",\n \"month\": \"$_id.month\",\n \"avg\": true\n }\n },\n {\n \"$sort\": {\n \"event_datum.message\": 1\n }\n }\n]",
:collection "events",
:template-tags {}},
:database 6,
:parameters [],
:async? true,
:cache-ttl nil},
:status :failed,
:class org.eclipse.jetty.io.EofException,
:stacktrace
["org.eclipse.jetty.server.HttpOutput.checkWritable(HttpOutput.java:765)"
"org.eclipse.jetty.server.HttpOutput.write(HttpOutput.java:795)"
"java.base/java.io.OutputStream.write(Unknown Source)"
"java.base/java.util.zip.GZIPOutputStream.writeHeader(Unknown Source)"
"java.base/java.util.zip.GZIPOutputStream.<init>(Unknown Source)"
"java.base/java.util.zip.GZIPOutputStream.<init>(Unknown Source)"
"--> async.streaming_response$output_stream_delay$fn__19016.invoke(streaming_response.clj:107)"
"async.streaming_response$delay_output_stream$fn__19025.invoke(streaming_response.clj:124)"
"async.streaming_response.proxy$java.io.OutputStream$ff19274a.write(Unknown Source)"
"query_processor.streaming.json$fn$reify__39271.finish_BANG_(json.clj:91)"
"query_processor.streaming$streaming_reducedf$fn__40050.invoke(streaming.clj:128)"
"query_processor.context$reducedf.invokeStatic(context.clj:77)"
"query_processor.context$reducedf.invoke(context.clj:72)"
"query_processor.context.default$default_reducef.invokeStatic(default.clj:63)"
"query_processor.context.default$default_reducef.invoke(default.clj:48)"
"query_processor.context$reducef.invokeStatic(context.clj:69)"
"query_processor.context$reducef.invoke(context.clj:62)"
"query_processor.context.default$default_runf$respond_STAR___39182.invoke(default.clj:68)"
"driver.mongo.execute$reduce_results.invokeStatic(execute.clj:138)"
"driver.mongo.execute$reduce_results.invoke(execute.clj:131)"
"driver.mongo.execute$execute_reducible_query.invokeStatic(execute.clj:169)"
"driver.mongo.execute$execute_reducible_query.invoke(execute.clj:157)"
"driver.mongo$fn__96261$f__94586__auto____96262.invoke(mongo.clj:238)"
"driver.mongo.util$do_with_mongo_connection$fn__94577.invoke(util.clj:226)"
"util.ssh$do_with_ssh_tunnel.invokeStatic(ssh.clj:134)"
"util.ssh$do_with_ssh_tunnel.invoke(ssh.clj:123)"
"driver.mongo.util$do_with_mongo_connection.invokeStatic(util.clj:220)"
"driver.mongo.util$do_with_mongo_connection.invoke(util.clj:215)"
"driver.mongo$fn__96261.invokeStatic(mongo.clj:237)"
"driver.mongo$fn__96261.invoke(mongo.clj:235)"
"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:67)"
"query_processor.context.default$default_runf.invoke(default.clj:65)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)"
"query_processor.reducible$identity_qp.invoke(reducible.clj:9)"
"query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___52623.invoke(cache.clj:220)"
"query_processor.middleware.permissions$check_query_permissions$fn__48144.invoke(permissions.clj:109)"
"metabase_enterprise.advanced_permissions.query_processor.middleware.permissions$check_download_permissions$fn__85604.invoke(permissions.clj:124)"
"metabase_enterprise.sandbox.query_processor.middleware.column_level_perms_check$maybe_apply_column_level_perms_check$fn__87408.invoke(column_level_perms_check.clj:30)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__51568.invoke(mbql_to_native.clj:23)"
"query_processor$fn__54099$combined_post_process__54104$combined_post_process_STAR___54105.invoke(query_processor.clj:212)"
"query_processor$fn__54099$combined_pre_process__54100$combined_pre_process_STAR___54101.invoke(query_processor.clj:209)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52544$fn__52549.invoke(resolve_database_and_driver.clj:35)"
"driver$do_with_driver.invokeStatic(driver.clj:75)"
"driver$do_with_driver.invoke(driver.clj:71)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52544.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__48579.invoke(fetch_source_query.clj:353)"
"query_processor.middleware.store$initialize_store$fn__48767$fn__48768.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__48767.invoke(store.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__52816.invoke(normalize_query.clj:22)"
"metabase_enterprise.audit_app.query_processor.middleware.handle_audit_queries$handle_internal_queries$fn__59641.invoke(handle_audit_queries.clj:130)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__49849.invoke(constraints.clj:53)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__52755.invoke(process_userland_query.clj:145)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__53127.invoke(catch_exceptions.clj:167)"
"query_processor.reducible$async_qp$qp_STAR___44982$thunk__44984.invoke(reducible.clj:100)"
"query_processor.reducible$async_qp$qp_STAR___44982$fn__44986.invoke(reducible.clj:105)"],
:card_id 35,
:context :dashboard,
:error "Closed",
:row_count 0,
:running_time 0,
:data {:rows [], :cols []}}
[9c82b324-f40a-4366-b1bc-af166a60ec58] 2022-12-14T14:09:05+01:00 DEBUG metabase.server.middleware.log POST /api/dashboard/10/dashcard/106/card/20/query 202 [Asincrono: completed] 24.2 s (14 Chiamate DB) Connessioni DB App: 1/15 Threads Jetty: 2/50 (13 inattivo/i, 0 accodato/i) (160 thread attivi totale/i) Query in partenza: 2 (0 accodato/i)
[9c82b324-f40a-4366-b1bc-af166a60ec58] 2022-12-14T14:09:11+01:00 ERROR metabase.query-processor.middleware.catch-exceptions Errore elaborazione query: Closed
{:database_id 6,
:started_at #t "2022-12-14T13:03:49.540206Z[UTC]",
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :query,
:middleware {:js-int-to-string? true, :ignore-cached-results? false},
:database 6,
:query
{:source-table 34,
:filter [:= [:field 377 nil] "crash" "exception"],
:aggregation [[:count]],
:breakout [[:field 374 nil] [:field 437 nil]]},
:parameters [],
:async? true,
:cache-ttl nil},
:native
{:projections ["event_datum.message" "device.model" "count"],
:query
[{"$match" {"$or" [{"event_datum.type" "crash"} {"event_datum.type" "exception"}]}}
{"$group"
{"_id" {"event_datum" {"message" "$event_datum.message"}, "device" {"model" "$device.model"}}, "count" {"$sum" 1}}}
{"$sort" {"_id" 1}}
{"$project"
{"_id" false, "event_datum.message" "$_id.event_datum.message", "device.model" "$_id.device.model", "count" true}}
{"$sort" {"event_datum.message" 1, "device.model" 1}}],
:collection "eventsView",
:mbql? true},
:status :failed,
:class org.eclipse.jetty.io.EofException,
:stacktrace
["org.eclipse.jetty.server.HttpOutput.checkWritable(HttpOutput.java:765)"
"org.eclipse.jetty.server.HttpOutput.write(HttpOutput.java:795)"
"java.base/java.io.OutputStream.write(Unknown Source)"
"java.base/java.util.zip.GZIPOutputStream.writeHeader(Unknown Source)"
"java.base/java.util.zip.GZIPOutputStream.<init>(Unknown Source)"
"java.base/java.util.zip.GZIPOutputStream.<init>(Unknown Source)"
"--> async.streaming_response$output_stream_delay$fn__19016.invoke(streaming_response.clj:107)"
"async.streaming_response$delay_output_stream$fn__19025.invoke(streaming_response.clj:124)"
"async.streaming_response.proxy$java.io.OutputStream$ff19274a.write(Unknown Source)"
"query_processor.streaming.json$fn$reify__39271.finish_BANG_(json.clj:91)"
"query_processor.streaming$streaming_reducedf$fn__40050.invoke(streaming.clj:128)"
"query_processor.context$reducedf.invokeStatic(context.clj:77)"
"query_processor.context$reducedf.invoke(context.clj:72)"
"query_processor.context.default$default_reducef.invokeStatic(default.clj:63)"
"query_processor.context.default$default_reducef.invoke(default.clj:48)"
"query_processor.context$reducef.invokeStatic(context.clj:69)"
"query_processor.context$reducef.invoke(context.clj:62)"
"query_processor.context.default$default_runf$respond_STAR___39182.invoke(default.clj:68)"
"driver.mongo.execute$reduce_results.invokeStatic(execute.clj:138)"
"driver.mongo.execute$reduce_results.invoke(execute.clj:131)"
"driver.mongo.execute$execute_reducible_query.invokeStatic(execute.clj:169)"
"driver.mongo.execute$execute_reducible_query.invoke(execute.clj:157)"
"driver.mongo$fn__96261$f__94586__auto____96262.invoke(mongo.clj:238)"
"driver.mongo.util$do_with_mongo_connection$fn__94577.invoke(util.clj:226)"
"util.ssh$do_with_ssh_tunnel.invokeStatic(ssh.clj:134)"
"util.ssh$do_with_ssh_tunnel.invoke(ssh.clj:123)"
"driver.mongo.util$do_with_mongo_connection.invokeStatic(util.clj:220)"
"driver.mongo.util$do_with_mongo_connection.invoke(util.clj:215)"
"driver.mongo$fn__96261.invokeStatic(mongo.clj:237)"
"driver.mongo$fn__96261.invoke(mongo.clj:235)"
"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:67)"
"query_processor.context.default$default_runf.invoke(default.clj:65)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)"
"query_processor.reducible$identity_qp.invoke(reducible.clj:9)"
"query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___52623.invoke(cache.clj:220)"
"query_processor.middleware.permissions$check_query_permissions$fn__48144.invoke(permissions.clj:109)"
"metabase_enterprise.advanced_permissions.query_processor.middleware.permissions$check_download_permissions$fn__85604.invoke(permissions.clj:124)"
"metabase_enterprise.sandbox.query_processor.middleware.column_level_perms_check$maybe_apply_column_level_perms_check$fn__87408.invoke(column_level_perms_check.clj:30)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__51568.invoke(mbql_to_native.clj:23)"
"query_processor$fn__54099$combined_post_process__54104$combined_post_process_STAR___54105.invoke(query_processor.clj:212)"
"query_processor$fn__54099$combined_pre_process__54100$combined_pre_process_STAR___54101.invoke(query_processor.clj:209)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52544$fn__52549.invoke(resolve_database_and_driver.clj:35)"
"driver$do_with_driver.invokeStatic(driver.clj:75)"
"driver$do_with_driver.invoke(driver.clj:71)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52544.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__48579.invoke(fetch_source_query.clj:353)"
"query_processor.middleware.store$initialize_store$fn__48767$fn__48768.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__48767.invoke(store.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__52816.invoke(normalize_query.clj:22)"
"metabase_enterprise.audit_app.query_processor.middleware.handle_audit_queries$handle_internal_queries$fn__59641.invoke(handle_audit_queries.clj:130)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__49849.invoke(constraints.clj:53)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__52755.invoke(process_userland_query.clj:145)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__53127.invoke(catch_exceptions.clj:167)"
"query_processor.reducible$async_qp$qp_STAR___44982$thunk__44984.invoke(reducible.clj:100)"
"query_processor.reducible$async_qp$qp_STAR___44982$fn__44986.invoke(reducible.clj:105)"],
:card_id 47,
:context :dashboard,
:error "Closed",
:row_count 0,
:running_time 0,
:preprocessed
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :query,
:middleware {:js-int-to-string? true, :ignore-cached-results? false},
:info
{:executed-by 2,
:context :dashboard,
:card-id 47,
:card-name "Grafico errori per modello device [totale]",
:dashboard-id 10},
:database 6,
:query
{:source-table 34,
:filter
[:or
[:=
[:field 377 nil]
[:value
"crash"
{:base_type :type/Text,
:effective_type :type/Text,
:coercion_strategy nil,
:semantic_type :type/Category,
:database_type "java.lang.String",
:name "type"}]]
[:=
[:field 377 nil]
[:value
"exception"
{:base_type :type/Text,
:effective_type :type/Text,
:coercion_strategy nil,
:semantic_type :type/Category,
:database_type "java.lang.String",
:name "type"}]]],
:aggregation [[:aggregation-options [:count] {:name "count"}]],
:breakout [[:field 374 nil] [:field 437 nil]],
:order-by [[:asc [:field 374 nil]] [:asc [:field 437 nil]]]},
:async? true},
:data {:rows [], :cols []}}
[9c82b324-f40a-4366-b1bc-af166a60ec58] 2022-12-14T14:09:11+01:00 DEBUG metabase.server.middleware.log POST /api/dashboard/10/dashcard/113/card/36/query 202 [Asincrono: canceled] 30.2 s (12 Chiamate DB) Connessioni DB App: 0/15 Threads Jetty: 2/50 (13 inattivo/i, 0 accodato/i) (154 thread attivi totale/i) Query in partenza: 1 (0 accodato/i)
[9c82b324-f40a-4366-b1bc-af166a60ec58] 2022-12-14T14:09:11+01:00 DEBUG metabase.server.middleware.log POST /api/dashboard/10/dashcard/105/card/35/query 202 [Asincrono: canceled] 30.2 s (14 Chiamate DB) Connessioni DB App: 0/15 Threads Jetty: 2/50 (13 inattivo/i, 0 accodato/i) (154 thread attivi totale/i) Query in partenza: 0 (0 accodato/i)
[9c82b324-f40a-4366-b1bc-af166a60ec58] 2022-12-14T14:09:13+01:00 ERROR metabase.query-processor.middleware.catch-exceptions Errore elaborazione query: Broken pipe
{:database_id 6,
:started_at #t "2022-12-14T13:08:41.547918Z[UTC]",
:via
[{:status :failed,
:class org.eclipse.jetty.io.EofException,
:error nil,
:stacktrace
["org.eclipse.jetty.io.ChannelEndPoint.flush(ChannelEndPoint.java:280)"
"org.eclipse.jetty.io.WriteFlusher.flush(WriteFlusher.java:422)"
"org.eclipse.jetty.io.WriteFlusher.write(WriteFlusher.java:277)"
"org.eclipse.jetty.io.AbstractEndPoint.write(AbstractEndPoint.java:381)"
"org.eclipse.jetty.server.HttpConnection$SendCallback.process(HttpConnection.java:831)"
"org.eclipse.jetty.util.IteratingCallback.processing(IteratingCallback.java:241)"
"org.eclipse.jetty.util.IteratingCallback.iterate(IteratingCallback.java:223)"
"org.eclipse.jetty.server.HttpConnection.send(HttpConnection.java:555)"
"org.eclipse.jetty.server.HttpChannel.sendResponse(HttpChannel.java:1014)"
"org.eclipse.jetty.server.HttpChannel.write(HttpChannel.java:1086)"
"org.eclipse.jetty.server.HttpOutput.channelWrite(HttpOutput.java:285)"
"org.eclipse.jetty.server.HttpOutput.channelWrite(HttpOutput.java:269)"
"org.eclipse.jetty.server.HttpOutput.flush(HttpOutput.java:751)"
"java.base/java.util.zip.DeflaterOutputStream.flush(Unknown Source)"
"--> async.streaming_response$delay_output_stream$fn__19023.invoke(streaming_response.clj:119)"
"async.streaming_response.proxy$java.io.OutputStream$ff19274a.flush(Unknown Source)"
"query_processor.streaming.json$fn$reify__39271.write_row_BANG_(json.clj:71)"
"query_processor.streaming$streaming_rff$fn__40041$fn__40046.invoke(streaming.clj:123)"
"query_processor.middleware.process_userland_query$add_and_save_execution_info_xform_BANG_$execution_info_rf_STAR___52746.invoke(process_userland_query.clj:100)"
"query_processor.reducible$combine_additional_reducing_fns$combine_additional_reducing_fns_rf_STAR___45003.invoke(reducible.clj:206)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated_xform$fn__50261.invoke(add_rows_truncated.clj:33)"
"query_processor.middleware.format_rows$format_rows_xform$fn__53030.invoke(format_rows.clj:68)"
"query_processor.reducible$combine_additional_reducing_fns$combine_additional_reducing_fns_rf_STAR___45003.invoke(reducible.clj:206)"
"query_processor.reducible$reducible_rows$reify__44996.reduce(reducible.clj:150)"
"query_processor.context.default$default_reducef$fn__39178.invoke(default.clj:57)"
"query_processor.context.default$default_reducef.invokeStatic(default.clj:56)"
"query_processor.context.default$default_reducef.invoke(default.clj:48)"
"query_processor.context$reducef.invokeStatic(context.clj:69)"
"query_processor.context$reducef.invoke(context.clj:62)"
"query_processor.context.default$default_runf$respond_STAR___39182.invoke(default.clj:68)"
"driver.mongo.execute$reduce_results.invokeStatic(execute.clj:138)"
"driver.mongo.execute$reduce_results.invoke(execute.clj:131)"
"driver.mongo.execute$execute_reducible_query.invokeStatic(execute.clj:169)"
"driver.mongo.execute$execute_reducible_query.invoke(execute.clj:157)"
"driver.mongo$fn__96261$f__94586__auto____96262.invoke(mongo.clj:238)"
"driver.mongo.util$do_with_mongo_connection$fn__94577.invoke(util.clj:226)"
"util.ssh$do_with_ssh_tunnel.invokeStatic(ssh.clj:134)"
"util.ssh$do_with_ssh_tunnel.invoke(ssh.clj:123)"
"driver.mongo.util$do_with_mongo_connection.invokeStatic(util.clj:220)"
"driver.mongo.util$do_with_mongo_connection.invoke(util.clj:215)"
"driver.mongo$fn__96261.invokeStatic(mongo.clj:237)"
"driver.mongo$fn__96261.invoke(mongo.clj:235)"
"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:67)"
"query_processor.context.default$default_runf.invoke(default.clj:65)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)"
"query_processor.reducible$identity_qp.invoke(reducible.clj:9)"
"query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___52623.invoke(cache.clj:220)"
"query_processor.middleware.permissions$check_query_permissions$fn__48144.invoke(permissions.clj:109)"
"metabase_enterprise.advanced_permissions.query_processor.middleware.permissions$check_download_permissions$fn__85604.invoke(permissions.clj:124)"
"metabase_enterprise.sandbox.query_processor.middleware.column_level_perms_check$maybe_apply_column_level_perms_check$fn__87408.invoke(column_level_perms_check.clj:30)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__51568.invoke(mbql_to_native.clj:23)"
"query_processor$fn__54099$combined_post_process__54104$combined_post_process_STAR___54105.invoke(query_processor.clj:212)"
"query_processor$fn__54099$combined_pre_process__54100$combined_pre_process_STAR___54101.invoke(query_processor.clj:209)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52544$fn__52549.invoke(resolve_database_and_driver.clj:35)"
"driver$do_with_driver.invokeStatic(driver.clj:75)"
"driver$do_with_driver.invoke(driver.clj:71)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52544.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__48579.invoke(fetch_source_query.clj:353)"
"query_processor.middleware.store$initialize_store$fn__48767$fn__48768.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__48767.invoke(store.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__52816.invoke(normalize_query.clj:22)"
"metabase_enterprise.audit_app.query_processor.middleware.handle_audit_queries$handle_internal_queries$fn__59641.invoke(handle_audit_queries.clj:130)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__49849.invoke(constraints.clj:53)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__52755.invoke(process_userland_query.clj:145)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__53127.invoke(catch_exceptions.clj:167)"
"query_processor.reducible$async_qp$qp_STAR___44982$thunk__44984.invoke(reducible.clj:100)"
"query_processor.reducible$async_qp$qp_STAR___44982$fn__44986.invoke(reducible.clj:105)"]}
{:status :failed,
:class clojure.lang.ExceptionInfo,
:error "Error reducing result rows",
:stacktrace
["--> query_processor.context.default$default_reducef$fn__39178.invoke(default.clj:59)"
"query_processor.context.default$default_reducef.invokeStatic(default.clj:56)"
"query_processor.context.default$default_reducef.invoke(default.clj:48)"
"query_processor.context$reducef.invokeStatic(context.clj:69)"
"query_processor.context$reducef.invoke(context.clj:62)"
"query_processor.context.default$default_runf$respond_STAR___39182.invoke(default.clj:68)"
"driver.mongo.execute$reduce_results.invokeStatic(execute.clj:138)"
"driver.mongo.execute$reduce_results.invoke(execute.clj:131)"
"driver.mongo.execute$execute_reducible_query.invokeStatic(execute.clj:169)"
"driver.mongo.execute$execute_reducible_query.invoke(execute.clj:157)"
"driver.mongo$fn__96261$f__94586__auto____96262.invoke(mongo.clj:238)"
"driver.mongo.util$do_with_mongo_connection$fn__94577.invoke(util.clj:226)"
"util.ssh$do_with_ssh_tunnel.invokeStatic(ssh.clj:134)"
"util.ssh$do_with_ssh_tunnel.invoke(ssh.clj:123)"
"driver.mongo.util$do_with_mongo_connection.invokeStatic(util.clj:220)"
"driver.mongo.util$do_with_mongo_connection.invoke(util.clj:215)"
"driver.mongo$fn__96261.invokeStatic(mongo.clj:237)"
"driver.mongo$fn__96261.invoke(mongo.clj:235)"
"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:67)"
"query_processor.context.default$default_runf.invoke(default.clj:65)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)"
"query_processor.reducible$identity_qp.invoke(reducible.clj:9)"
"query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___52623.invoke(cache.clj:220)"
"query_processor.middleware.permissions$check_query_permissions$fn__48144.invoke(permissions.clj:109)"
"metabase_enterprise.advanced_permissions.query_processor.middleware.permissions$check_download_permissions$fn__85604.invoke(permissions.clj:124)"
"metabase_enterprise.sandbox.query_processor.middleware.column_level_perms_check$maybe_apply_column_level_perms_check$fn__87408.invoke(column_level_perms_check.clj:30)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__51568.invoke(mbql_to_native.clj:23)"
"query_processor$fn__54099$combined_post_process__54104$combined_post_process_STAR___54105.invoke(query_processor.clj:212)"
"query_processor$fn__54099$combined_pre_process__54100$combined_pre_process_STAR___54101.invoke(query_processor.clj:209)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52544$fn__52549.invoke(resolve_database_and_driver.clj:35)"
"driver$do_with_driver.invokeStatic(driver.clj:75)"
"driver$do_with_driver.invoke(driver.clj:71)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52544.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__48579.invoke(fetch_source_query.clj:353)"
"query_processor.middleware.store$initialize_store$fn__48767$fn__48768.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__48767.invoke(store.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__52816.invoke(normalize_query.clj:22)"
"metabase_enterprise.audit_app.query_processor.middleware.handle_audit_queries$handle_internal_queries$fn__59641.invoke(handle_audit_queries.clj:130)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__49849.invoke(constraints.clj:53)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__52755.invoke(process_userland_query.clj:145)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__53127.invoke(catch_exceptions.clj:167)"
"query_processor.reducible$async_qp$qp_STAR___44982$thunk__44984.invoke(reducible.clj:100)"
"query_processor.reducible$async_qp$qp_STAR___44982$fn__44986.invoke(reducible.clj:105)"],
:error_type :qp,
:ex-data {:type :qp}}],
:error_type :qp,
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :native,
:middleware {:js-int-to-string? true, :ignore-cached-results? false},
:native
{:query
"[\n {\n \"$match\": {\n \"$and\": [\n {\n \"event_datum.type\": \"page_load_time\"\n },\n {\n \"$expr\": {\n \"$gte\": [\n \"$event_datum.ts\",\n {\n \"$subtract\": [ISODate(), { $multiply: [ 6, 31, 24, 60, 60, 1000 ] }]\n }\n ]\n }\n },\n {\n \"$expr\": {\n \"$ne\": [\n {\"$month\": \"$event_datum.ts\"},\n {\"$month\": \n {\n \"$subtract\": [ISODate(), { $multiply: [ 6, 31, 24, 60, 60, 1000 ] }]\n }}\n ]\n }\n },\n {\n \"$or\": [\n {\n \"event_datum.message\": \"Load Agenda from storage\"\n },\n {\n \"event_datum.message\": \"Load contacts GDP from storage\"\n },\n {\n \"event_datum.message\": \"Load HomePage KPI from storage\"\n },\n {\n \"event_datum.message\": \"Load Tasks from storage\"\n },\n {\n \"event_datum.message\": \"Load Contraente\"\n },\n {\n \"event_datum.message\": \"Load configurazione proposta\"\n },\n {\n \"event_datum.message\": \"Load Bisogni from cache\"\n },\n {\n \"event_datum.message\": \"Load sign page\"\n },\n {\n \"event_datum.message\": \"Load Beneficiari\"\n },\n {\n \"event_datum.message\": \"Load Prodotti from cache\"\n },\n {\n \"event_datum.message\": \"Salva Soggetto service\"\n }\n ]\n }\n ]\n }\n },\n { \"$unwind\": \"$event_datum.params\" },\n {\n \"$group\": {\n \"_id\": {\n \"component\": \"$event_datum.message\",\n \"month\": {\n \"$let\": {\n \"vars\": {\n \"parts\": {\n \"$dateToParts\": {\n \"timezone\": \"Europe/Rome\",\n \"date\": \"$event_datum.ts\"\n }\n }\n },\n \"in\": {\n \"$dateFromParts\": {\n \"timezone\": \"Europe/Rome\",\n \"year\": \"$$parts.year\",\n \"month\": \"$$parts.month\"\n }\n }\n }\n }\n },\n\n \"avg\": {\n \"$avg\": { \"$toLong\": \"$event_datum.params.total\" }\n }\n }\n },\n {\n \"$sort\": {\n \"_id\": 1\n }\n },\n {\n \"$project\": {\n \"_id\": false,\n \"component\": \"$_id.component\",\n \"month\": \"$_id.month\",\n \"avg\": true\n }\n },\n {\n \"$sort\": {\n \"event_datum.message\": 1\n }\n }\n]",
:collection "events",
:template-tags {}},
:database 6,
:parameters [],
:async? true,
:cache-ttl nil},
:status :failed,
:class java.io.IOException,
:stacktrace
["java.base/sun.nio.ch.FileDispatcherImpl.writev0(Native Method)"
"java.base/sun.nio.ch.SocketDispatcher.writev(Unknown Source)"
"java.base/sun.nio.ch.IOUtil.write(Unknown Source)"
"java.base/sun.nio.ch.IOUtil.write(Unknown Source)"
"java.base/sun.nio.ch.SocketChannelImpl.write(Unknown Source)"
"java.base/java.nio.channels.SocketChannel.write(Unknown Source)"
"org.eclipse.jetty.io.ChannelEndPoint.flush(ChannelEndPoint.java:274)"
"org.eclipse.jetty.io.WriteFlusher.flush(WriteFlusher.java:422)"
"org.eclipse.jetty.io.WriteFlusher.write(WriteFlusher.java:277)"
"org.eclipse.jetty.io.AbstractEndPoint.write(AbstractEndPoint.java:381)"
"org.eclipse.jetty.server.HttpConnection$SendCallback.process(HttpConnection.java:831)"
"org.eclipse.jetty.util.IteratingCallback.processing(IteratingCallback.java:241)"
"org.eclipse.jetty.util.IteratingCallback.iterate(IteratingCallback.java:223)"
"org.eclipse.jetty.server.HttpConnection.send(HttpConnection.java:555)"
"org.eclipse.jetty.server.HttpChannel.sendResponse(HttpChannel.java:1014)"
"org.eclipse.jetty.server.HttpChannel.write(HttpChannel.java:1086)"
"org.eclipse.jetty.server.HttpOutput.channelWrite(HttpOutput.java:285)"
"org.eclipse.jetty.server.HttpOutput.channelWrite(HttpOutput.java:269)"
"org.eclipse.jetty.server.HttpOutput.flush(HttpOutput.java:751)"
"java.base/java.util.zip.DeflaterOutputStream.flush(Unknown Source)"
"--> async.streaming_response$delay_output_stream$fn__19023.invoke(streaming_response.clj:119)"
"async.streaming_response.proxy$java.io.OutputStream$ff19274a.flush(Unknown Source)"
"query_processor.streaming.json$fn$reify__39271.write_row_BANG_(json.clj:71)"
"query_processor.streaming$streaming_rff$fn__40041$fn__40046.invoke(streaming.clj:123)"
"query_processor.middleware.process_userland_query$add_and_save_execution_info_xform_BANG_$execution_info_rf_STAR___52746.invoke(process_userland_query.clj:100)"
"query_processor.reducible$combine_additional_reducing_fns$combine_additional_reducing_fns_rf_STAR___45003.invoke(reducible.clj:206)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated_xform$fn__50261.invoke(add_rows_truncated.clj:33)"
"query_processor.middleware.format_rows$format_rows_xform$fn__53030.invoke(format_rows.clj:68)"
"query_processor.reducible$combine_additional_reducing_fns$combine_additional_reducing_fns_rf_STAR___45003.invoke(reducible.clj:206)"
"query_processor.reducible$reducible_rows$reify__44996.reduce(reducible.clj:150)"
"query_processor.context.default$default_reducef$fn__39178.invoke(default.clj:57)"
"query_processor.context.default$default_reducef.invokeStatic(default.clj:56)"
"query_processor.context.default$default_reducef.invoke(default.clj:48)"
"query_processor.context$reducef.invokeStatic(context.clj:69)"
"query_processor.context$reducef.invoke(context.clj:62)"
"query_processor.context.default$default_runf$respond_STAR___39182.invoke(default.clj:68)"
"driver.mongo.execute$reduce_results.invokeStatic(execute.clj:138)"
"driver.mongo.execute$reduce_results.invoke(execute.clj:131)"
"driver.mongo.execute$execute_reducible_query.invokeStatic(execute.clj:169)"
"driver.mongo.execute$execute_reducible_query.invoke(execute.clj:157)"
"driver.mongo$fn__96261$f__94586__auto____96262.invoke(mongo.clj:238)"
"driver.mongo.util$do_with_mongo_connection$fn__94577.invoke(util.clj:226)"
"util.ssh$do_with_ssh_tunnel.invokeStatic(ssh.clj:134)"
"util.ssh$do_with_ssh_tunnel.invoke(ssh.clj:123)"
"driver.mongo.util$do_with_mongo_connection.invokeStatic(util.clj:220)"
"driver.mongo.util$do_with_mongo_connection.invoke(util.clj:215)"
"driver.mongo$fn__96261.invokeStatic(mongo.clj:237)"
"driver.mongo$fn__96261.invoke(mongo.clj:235)"
"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:67)"
"query_processor.context.default$default_runf.invoke(default.clj:65)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)"
"query_processor.reducible$identity_qp.invoke(reducible.clj:9)"
"query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___52623.invoke(cache.clj:220)"
"query_processor.middleware.permissions$check_query_permissions$fn__48144.invoke(permissions.clj:109)"
"metabase_enterprise.advanced_permissions.query_processor.middleware.permissions$check_download_permissions$fn__85604.invoke(permissions.clj:124)"
"metabase_enterprise.sandbox.query_processor.middleware.column_level_perms_check$maybe_apply_column_level_perms_check$fn__87408.invoke(column_level_perms_check.clj:30)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__51568.invoke(mbql_to_native.clj:23)"
"query_processor$fn__54099$combined_post_process__54104$combined_post_process_STAR___54105.invoke(query_processor.clj:212)"
"query_processor$fn__54099$combined_pre_process__54100$combined_pre_process_STAR___54101.invoke(query_processor.clj:209)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52544$fn__52549.invoke(resolve_database_and_driver.clj:35)"
"driver$do_with_driver.invokeStatic(driver.clj:75)"
"driver$do_with_driver.invoke(driver.clj:71)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52544.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__48579.invoke(fetch_source_query.clj:353)"
"query_processor.middleware.store$initialize_store$fn__48767$fn__48768.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__48767.invoke(store.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__52816.invoke(normalize_query.clj:22)"
"metabase_enterprise.audit_app.query_processor.middleware.handle_audit_queries$handle_internal_queries$fn__59641.invoke(handle_audit_queries.clj:130)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__49849.invoke(constraints.clj:53)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__52755.invoke(process_userland_query.clj:145)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__53127.invoke(catch_exceptions.clj:167)"
"query_processor.reducible$async_qp$qp_STAR___44982$thunk__44984.invoke(reducible.clj:100)"
"query_processor.reducible$async_qp$qp_STAR___44982$fn__44986.invoke(reducible.clj:105)"],
:card_id 35,
:context :dashboard,
:error "Broken pipe",
:row_count 0,
:running_time 0,
:data {:rows [], :cols []}}
[9c82b324-f40a-4366-b1bc-af166a60ec58] 2022-12-14T14:09:13+01:00 ERROR metabase.query-processor.middleware.catch-exceptions Errore elaborazione query: Closed
{:database_id 6,
:started_at #t "2022-12-14T13:03:49.236257Z[UTC]",
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :native,
:middleware {:js-int-to-string? true, :ignore-cached-results? false},
:native
{:query
"[\n {\n \"$lookup\": {\n \"from\": 'devices',\n \"localField\": 'device_id',\n \"foreignField\": '_id',\n \"as\": 'device'\n }\n },\n {\n \"$match\": {\n \"$and\": [ \n {\n \"$or\": [\n {\n \"event_datum.type\": \"crash\"\n },\n {\n \"event_datum.type\": \"exception\"\n }\n ]\n },\n {\n \"$or\": [\n {\n \"device.app.version\": \"1.29\"\n },\n {\n \"device.app.version\": \"1.29.0.1\"\n },\n {\n \"device.app.version\": \"1.29.0.2\"\n },\n {\n \"device.app.version\": \"1.29.0.3\"\n },\n {\n \"device.app.version\": \"1.29.0.4\"\n },\n {\n \"device.app.version\": \"1.29.0.5\"\n },\n {\n \"device.app.version\": \"1.29.0.6\"\n },\n {\n \"device.app.version\": \"1.29.0.7\"\n },\n {\n \"device.app.version\": \"1.29.0.8\"\n },\n ]\n },\n ]\n }\n },\n {\n \"$group\": {\n \"_id\": {\n \"Message toString\": { $substr: [ { \n \"$concat\": [\n \"$event_datum.message\",\n \"\"\n ]\n }, 0, 15 ] },\n \"version\": {\"$first\": \"$device.app.version\"}\n },\n \"count\": {\n \"$sum\": 1\n }\n }\n },\n {\n \"$sort\": {\n \"_id\": 1\n }\n },\n {\n \"$project\": {\n \"_id\": false,\n \"Message toString\": \"$_id.Message toString\",\n \"version\": \"$_id.version\",\n \"count\": true\n }\n },\n {\n \"$sort\": {\n \"version\": 1\n }\n }\n]",
:collection "events",
:template-tags {}},
:database 6,
:parameters [],
:async? true,
:cache-ttl nil},
:status :failed,
:class org.eclipse.jetty.io.EofException,
:stacktrace
["org.eclipse.jetty.server.HttpOutput.checkWritable(HttpOutput.java:765)"
"org.eclipse.jetty.server.HttpOutput.write(HttpOutput.java:795)"
"java.base/java.io.OutputStream.write(Unknown Source)"
"java.base/java.util.zip.GZIPOutputStream.writeHeader(Unknown Source)"
"java.base/java.util.zip.GZIPOutputStream.<init>(Unknown Source)"
"java.base/java.util.zip.GZIPOutputStream.<init>(Unknown Source)"
"--> async.streaming_response$output_stream_delay$fn__19016.invoke(streaming_response.clj:107)"
"async.streaming_response$delay_output_stream$fn__19025.invoke(streaming_response.clj:124)"
"async.streaming_response.proxy$java.io.OutputStream$ff19274a.write(Unknown Source)"
"query_processor.streaming.json$fn$reify__39271.finish_BANG_(json.clj:91)"
"query_processor.streaming$streaming_reducedf$fn__40050.invoke(streaming.clj:128)"
"query_processor.context$reducedf.invokeStatic(context.clj:77)"
"query_processor.context$reducedf.invoke(context.clj:72)"
"query_processor.context.default$default_reducef.invokeStatic(default.clj:63)"
"query_processor.context.default$default_reducef.invoke(default.clj:48)"
"query_processor.context$reducef.invokeStatic(context.clj:69)"
"query_processor.context$reducef.invoke(context.clj:62)"
"query_processor.context.default$default_runf$respond_STAR___39182.invoke(default.clj:68)"
"driver.mongo.execute$reduce_results.invokeStatic(execute.clj:138)"
"driver.mongo.execute$reduce_results.invoke(execute.clj:131)"
"driver.mongo.execute$execute_reducible_query.invokeStatic(execute.clj:169)"
"driver.mongo.execute$execute_reducible_query.invoke(execute.clj:157)"
"driver.mongo$fn__96261$f__94586__auto____96262.invoke(mongo.clj:238)"
"driver.mongo.util$do_with_mongo_connection$fn__94577.invoke(util.clj:226)"
"util.ssh$do_with_ssh_tunnel.invokeStatic(ssh.clj:134)"
"util.ssh$do_with_ssh_tunnel.invoke(ssh.clj:123)"
"driver.mongo.util$do_with_mongo_connection.invokeStatic(util.clj:220)"
"driver.mongo.util$do_with_mongo_connection.invoke(util.clj:215)"
"driver.mongo$fn__96261.invokeStatic(mongo.clj:237)"
"driver.mongo$fn__96261.invoke(mongo.clj:235)"
"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:67)"
"query_processor.context.default$default_runf.invoke(default.clj:65)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)"
"query_processor.reducible$identity_qp.invoke(reducible.clj:9)"
"query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___52623.invoke(cache.clj:220)"
"query_processor.middleware.permissions$check_query_permissions$fn__48144.invoke(permissions.clj:109)"
"metabase_enterprise.advanced_permissions.query_processor.middleware.permissions$check_download_permissions$fn__85604.invoke(permissions.clj:124)"
"metabase_enterprise.sandbox.query_processor.middleware.column_level_perms_check$maybe_apply_column_level_perms_check$fn__87408.invoke(column_level_perms_check.clj:30)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__51568.invoke(mbql_to_native.clj:23)"
"query_processor$fn__54099$combined_post_process__54104$combined_post_process_STAR___54105.invoke(query_processor.clj:212)"
"query_processor$fn__54099$combined_pre_process__54100$combined_pre_process_STAR___54101.invoke(query_processor.clj:209)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52544$fn__52549.invoke(resolve_database_and_driver.clj:35)"
"driver$do_with_driver.invokeStatic(driver.clj:75)"
"driver$do_with_driver.invoke(driver.clj:71)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52544.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__48579.invoke(fetch_source_query.clj:353)"
"query_processor.middleware.store$initialize_store$fn__48767$fn__48768.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__48767.invoke(store.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__52816.invoke(normalize_query.clj:22)"
"metabase_enterprise.audit_app.query_processor.middleware.handle_audit_queries$handle_internal_queries$fn__59641.invoke(handle_audit_queries.clj:130)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__49849.invoke(constraints.clj:53)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__52755.invoke(process_userland_query.clj:145)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__53127.invoke(catch_exceptions.clj:167)"
"query_processor.reducible$async_qp$qp_STAR___44982$thunk__44984.invoke(reducible.clj:100)"
"query_processor.reducible$async_qp$qp_STAR___44982$fn__44986.invoke(reducible.clj:105)"],
:card_id 45,
:context :dashboard,
:error "Closed",
:row_count 0,
:running_time 0,
:data {:rows [], :cols []}}