When I try to view the question I created, it slows down quite a bit and the whole browser becomes sluggish.
The log shows the following error
What is the cause?
Part of the log is in Japanese, but please forgive me
2023/08/29 19:06:22.437 [clojure-agent-send-off-pool-5] ERROR metabase.query-processor.middleware.catch-exceptions クエリの実行中にエラーが発生しました: Closed
{:database_id 5,
:started_at #t "2023-08-29T19:06:21.871927700+09:00[Asia/Tokyo]",
:via
[{:status :failed,
:class clojure.lang.ExceptionInfo,
:error "結果行の削減エラーです。Closed",
:stacktrace
["--> query_processor.context.default$default_reducef$fn__60460.invoke(default.clj:60)"
"query_processor.context.default$default_reducef.invokeStatic(default.clj:57)"
"query_processor.context.default$default_reducef.invoke(default.clj:49)"
"query_processor.context$reducef.invokeStatic(context.clj:70)"
"query_processor.context$reducef.invoke(context.clj:63)"
"query_processor.context.default$default_runf$respond_STAR___60464.invoke(default.clj:69)"
"driver.oracle$remove_rownum_column.invokeStatic(oracle.clj:494)"
"driver.oracle$remove_rownum_column.invoke(oracle.clj:490)"
"driver.sql_jdbc.execute$execute_reducible_query$fn__81056.invoke(execute.clj:689)"
"driver.sql_jdbc.execute$fn__80857$fn__80858.invoke(execute.clj:384)"
"driver.sql_jdbc.execute$fn__80825$do_with_resolved_connection__80826.invoke(execute.clj:334)"
"driver.sql_jdbc.execute$fn__80857.invokeStatic(execute.clj:378)"
"driver.sql_jdbc.execute$fn__80857.invoke(execute.clj:376)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:672)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:661)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:669)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:661)"
"driver.sql_jdbc$fn__115969.invokeStatic(sql_jdbc.clj:72)"
"driver.sql_jdbc$fn__115969.invoke(sql_jdbc.clj:70)"
"driver.oracle$fn__118088.invokeStatic(oracle.clj:507)"
"driver.oracle$fn__118088.invoke(oracle.clj:505)"
"query_processor.context$executef.invokeStatic(context.clj:60)"
"query_processor.context$executef.invoke(context.clj:49)"
"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:46)"
"query_processor.context$runf.invoke(context.clj:40)"
"query_processor.reducible$identity_qp.invokeStatic(reducible.clj:15)"
"query_processor.reducible$identity_qp.invoke(reducible.clj:12)"
"query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___77111.invoke(cache.clj:224)"
"query_processor.middleware.permissions$check_query_permissions$fn__72694.invoke(permissions.clj:126)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__76236.invoke(mbql_to_native.clj:24)"
"query_processor$fn__78344$combined_post_process__78349$combined_post_process_STAR___78350.invoke(query_processor.clj:260)"
"query_processor$fn__78344$combined_pre_process__78345$combined_pre_process_STAR___78346.invoke(query_processor.clj:257)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__77022$fn__77027.invoke(resolve_database_and_driver.clj:36)"
"driver$do_with_driver.invokeStatic(driver.clj:93)"
"driver$do_with_driver.invoke(driver.clj:88)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__77022.invoke(resolve_database_and_driver.clj:35)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__73004.invoke(fetch_source_query.clj:312)"
"query_processor.middleware.store$initialize_store$fn__73185$fn__73186.invoke(store.clj:12)"
"query_processor.store$do_with_store.invokeStatic(store.clj:54)"
"query_processor.store$do_with_store.invoke(store.clj:50)"
"query_processor.middleware.store$initialize_store$fn__73185.invoke(store.clj:11)"
"query_processor.middleware.normalize_query$normalize$fn__77318.invoke(normalize_query.clj:36)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__74712.invoke(constraints.clj:54)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__77247.invoke(process_userland_query.clj:151)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__77644.invoke(catch_exceptions.clj:171)"
"query_processor.reducible$async_qp$qp_STAR___66880$thunk__66882.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___66880.invoke(reducible.clj:109)"
"query_processor.reducible$async_qp$qp_STAR___66880.invoke(reducible.clj:94)"
"query_processor.reducible$sync_qp$qp_STAR___66892.doInvoke(reducible.clj:129)"
"query_processor.pivot$process_query_append_results.invokeStatic(pivot.clj:150)"
"query_processor.pivot$process_query_append_results.invoke(pivot.clj:137)"
"query_processor.pivot$process_queries_append_results$fn__93241.invoke(pivot.clj:161)"
"query_processor.pivot$process_queries_append_results.invokeStatic(pivot.clj:159)"
"query_processor.pivot$process_queries_append_results.invoke(pivot.clj:156)"
"query_processor.pivot$append_queries_context$multiple_reducing__93254.invoke(pivot.clj:199)"
"query_processor.context$reducef.invokeStatic(context.clj:70)"
"query_processor.context$reducef.invoke(context.clj:63)"
"query_processor.context.default$default_runf$respond_STAR___60464.invoke(default.clj:69)"
"query_processor.pivot$append_queries_context$fn__93249$multiple_executef__93250.invoke(pivot.clj:184)"
"query_processor.context$executef.invokeStatic(context.clj:60)"
"query_processor.context$executef.invoke(context.clj:49)"
"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:46)"
"query_processor.context$runf.invoke(context.clj:40)"
"query_processor.reducible$identity_qp.invokeStatic(reducible.clj:15)"
"query_processor.reducible$identity_qp.invoke(reducible.clj:12)"
"query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___77111.invoke(cache.clj:224)"
"query_processor.middleware.permissions$check_query_permissions$fn__72694.invoke(permissions.clj:126)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__76236.invoke(mbql_to_native.clj:24)"
"query_processor$fn__78344$combined_post_process__78349$combined_post_process_STAR___78350.invoke(query_processor.clj:260)"
"query_processor$fn__78344$combined_pre_process__78345$combined_pre_process_STAR___78346.invoke(query_processor.clj:257)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__77022$fn__77027.invoke(resolve_database_and_driver.clj:36)"
"driver$do_with_driver.invokeStatic(driver.clj:93)"
"driver$do_with_driver.invoke(driver.clj:88)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__77022.invoke(resolve_database_and_driver.clj:35)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__73004.invoke(fetch_source_query.clj:312)"
"query_processor.middleware.store$initialize_store$fn__73185$fn__73186.invoke(store.clj:12)"
"query_processor.store$do_with_store.invokeStatic(store.clj:54)"
"query_processor.store$do_with_store.invoke(store.clj:50)"
"query_processor.middleware.store$initialize_store$fn__73185.invoke(store.clj:11)"
"query_processor.middleware.normalize_query$normalize$fn__77318.invoke(normalize_query.clj:36)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__74712.invoke(constraints.clj:54)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__77247.invoke(process_userland_query.clj:151)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__77644.invoke(catch_exceptions.clj:171)"
"query_processor.reducible$async_qp$qp_STAR___66880$thunk__66882.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___66880$fn__66884.invoke(reducible.clj:108)"],
:error_type :qp,
:ex-data {:type :qp}}],
:error_type :qp,
:json_query
{:database 5,
:type :query,
:query
{:aggregation
[[:sum [:field "KYKJYUSU" {:base-type :type/Decimal}]] [:avg [:field "KYKTK" {:base-type :type/Decimal}]]],
:breakout ([:expression "pivot-grouping"]),
:source-table "card__36",
:expressions {:pivot-grouping [:abs 127]}},
:constraints {:max-results 10000, :max-results-bare-rows 2000},
:middleware {:js-int-to-string? true, :ignore-cached-results? false},
:async? true},
:native
{:query
"SELECT "source"."pivot-grouping" "pivot-grouping", SUM("source"."KYKJYUSU") "sum", AVG("source"."KYKTK") "avg" FROM (SELECT "source"."KYKJYUSU" "KYKJYUSU", "source"."KYKTK" "KYKTK", ABS(127) "pivot-grouping" FROM (select\nKYKTHA.DATNO As DATNO\n, KYKTHA.KYKNO As KYKNO\n, KYKTRA.LINNO As LINNO\n, KYKTHA.KYKDT As KYKDT\n, to_date(trim(KYKTHA.KYKDT),'YYYY/MM/DD') as KYKDATE\n, KYKTHA.TOKRN As TOKRN\n, KYKTHA.TKYNM As TKYNM\n, KYKTRA.KOJNMA As KOJNMA\n, KYKTRA.KOJNMB As KOJNMB\n, Concat(KYKTRA.KOJNMA,KYKTRA.KOJNMB) As KOJNM\n, KYKTRA.ZAINM As ZAINM\n, KYKTRA.SIZNM As SIZNM\n, KYKTRA.KYKJYUSU As KYKJYUSU\n, KYKTRA.KYKTK As KYKTK\n, KYKTRA.KYKSB As KYKSB\nfrom\nKYKTHA\ninner join\nKYKTRA\non\nKYKTHA.DATNO = KYKTRA.DATNO\nwhere\nKYKTHA.DATKB = '1'\nand KYKTHA.HNSNM = '異形棒鋼'\nand KYKTHA.ODNKB = '10'\nand KYKTRA.LINNO < '990') "source") "source" GROUP BY "source"."pivot-grouping" ORDER BY "source"."pivot-grouping" ASC",
:params nil},
:status :failed,
:class org.eclipse.jetty.io.EofException,
:stacktrace
["org.eclipse.jetty.server.HttpOutput.checkWritable(HttpOutput.java:756)"
"org.eclipse.jetty.server.HttpOutput.write(HttpOutput.java:780)"
"java.base/java.util.zip.DeflaterOutputStream.flush(DeflaterOutputStream.java:277)"
"--> async.streaming_response$delay_output_stream$fn__39737.invoke(streaming_response.clj:123)"
"async.streaming_response.proxy$java.io.OutputStream$ff19274a.flush(Unknown Source)"
"query_processor.streaming.json$fn$reify__60552.write_row_BANG_(json.clj:75)"
"query_processor.streaming$streaming_rff$fn__61367$fn__61372.invoke(streaming.clj:127)"
"query_processor.pivot$process_query_append_results$fn__93234$fn__93235.invoke(pivot.clj:147)"
"query_processor.middleware.process_userland_query$add_and_save_execution_info_xform_BANG_$execution_info_rf_STAR___77238.invoke(process_userland_query.clj:106)"
"query_processor.reducible$combine_additional_reducing_fns$combine_additional_reducing_fns_rf_STAR___66903.invoke(reducible.clj:209)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated_xform$fn__74880.invoke(add_rows_truncated.clj:34)"
"query_processor.middleware.format_rows$format_rows_xform$fn__77548.invoke(format_rows.clj:74)"
"query_processor.reducible$reducible_rows$reify__66895.reduce(reducible.clj:153)"
"query_processor.context.default$default_reducef$fn__60460.invoke(default.clj:58)"
"query_processor.context.default$default_reducef.invokeStatic(default.clj:57)"
"query_processor.context.default$default_reducef.invoke(default.clj:49)"
"query_processor.context$reducef.invokeStatic(context.clj:70)"
"query_processor.context$reducef.invoke(context.clj:63)"
"query_processor.context.default$default_runf$respond_STAR___60464.invoke(default.clj:69)"
"driver.oracle$remove_rownum_column.invokeStatic(oracle.clj:494)"
"driver.oracle$remove_rownum_column.invoke(oracle.clj:490)"
"driver.sql_jdbc.execute$execute_reducible_query$fn__81056.invoke(execute.clj:689)"
"driver.sql_jdbc.execute$fn__80857$fn__80858.invoke(execute.clj:384)"
"driver.sql_jdbc.execute$fn__80825$do_with_resolved_connection__80826.invoke(execute.clj:334)"
"driver.sql_jdbc.execute$fn__80857.invokeStatic(execute.clj:378)"
"driver.sql_jdbc.execute$fn__80857.invoke(execute.clj:376)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:672)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:661)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:669)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:661)"
"driver.sql_jdbc$fn__115969.invokeStatic(sql_jdbc.clj:72)"
"driver.sql_jdbc$fn__115969.invoke(sql_jdbc.clj:70)"
"driver.oracle$fn__118088.invokeStatic(oracle.clj:507)"
"driver.oracle$fn__118088.invoke(oracle.clj:505)"
"query_processor.context$executef.invokeStatic(context.clj:60)"
"query_processor.context$executef.invoke(context.clj:49)"
"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:46)"
"query_processor.context$runf.invoke(context.clj:40)"
"query_processor.reducible$identity_qp.invokeStatic(reducible.clj:15)"
"query_processor.reducible$identity_qp.invoke(reducible.clj:12)"
"query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___77111.invoke(cache.clj:224)"
"query_processor.middleware.permissions$check_query_permissions$fn__72694.invoke(permissions.clj:126)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__76236.invoke(mbql_to_native.clj:24)"
"query_processor$fn__78344$combined_post_process__78349$combined_post_process_STAR___78350.invoke(query_processor.clj:260)"
"query_processor$fn__78344$combined_pre_process__78345$combined_pre_process_STAR___78346.invoke(query_processor.clj:257)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__77022$fn__77027.invoke(resolve_database_and_driver.clj:36)"
"driver$do_with_driver.invokeStatic(driver.clj:93)"
"driver$do_with_driver.invoke(driver.clj:88)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__77022.invoke(resolve_database_and_driver.clj:35)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__73004.invoke(fetch_source_query.clj:312)"
"query_processor.middleware.store$initialize_store$fn__73185$fn__73186.invoke(store.clj:12)"
"query_processor.store$do_with_store.invokeStatic(store.clj:54)"
"query_processor.store$do_with_store.invoke(store.clj:50)"
"query_processor.middleware.store$initialize_store$fn__73185.invoke(store.clj:11)"
"query_processor.middleware.normalize_query$normalize$fn__77318.invoke(normalize_query.clj:36)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__74712.invoke(constraints.clj:54)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__77247.invoke(process_userland_query.clj:151)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__77644.invoke(catch_exceptions.clj:171)"
"query_processor.reducible$async_qp$qp_STAR___66880$thunk__66882.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___66880.invoke(reducible.clj:109)"
"query_processor.reducible$async_qp$qp_STAR___66880.invoke(reducible.clj:94)"
"query_processor.reducible$sync_qp$qp_STAR___66892.doInvoke(reducible.clj:129)"
"query_processor.pivot$process_query_append_results.invokeStatic(pivot.clj:150)"
"query_processor.pivot$process_query_append_results.invoke(pivot.clj:137)"
"query_processor.pivot$process_queries_append_results$fn__93241.invoke(pivot.clj:161)"
"query_processor.pivot$process_queries_append_results.invokeStatic(pivot.clj:159)"
"query_processor.pivot$process_queries_append_results.invoke(pivot.clj:156)"
"query_processor.pivot$append_queries_context$multiple_reducing__93254.invoke(pivot.clj:199)"
"query_processor.context$reducef.invokeStatic(context.clj:70)"
"query_processor.context$reducef.invoke(context.clj:63)"
"query_processor.context.default$default_runf$respond_STAR___60464.invoke(default.clj:69)"
"query_processor.pivot$append_queries_context$fn__93249$multiple_executef__93250.invoke(pivot.clj:184)"
"query_processor.context$executef.invokeStatic(context.clj:60)"
"query_processor.context$executef.invoke(context.clj:49)"
"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:46)"
"query_processor.context$runf.invoke(context.clj:40)"
"query_processor.reducible$identity_qp.invokeStatic(reducible.clj:15)"
"query_processor.reducible$identity_qp.invoke(reducible.clj:12)"
"query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___77111.invoke(cache.clj:224)"
"query_processor.middleware.permissions$check_query_permissions$fn__72694.invoke(permissions.clj:126)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__76236.invoke(mbql_to_native.clj:24)"
"query_processor$fn__78344$combined_post_process__78349$combined_post_process_STAR___78350.invoke(query_processor.clj:260)"
"query_processor$fn__78344$combined_pre_process__78345$combined_pre_process_STAR___78346.invoke(query_processor.clj:257)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__77022$fn__77027.invoke(resolve_database_and_driver.clj:36)"
"driver$do_with_driver.invokeStatic(driver.clj:93)"
"driver$do_with_driver.invoke(driver.clj:88)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__77022.invoke(resolve_database_and_driver.clj:35)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__73004.invoke(fetch_source_query.clj:312)"
"query_processor.middleware.store$initialize_store$fn__73185$fn__73186.invoke(store.clj:12)"
"query_processor.store$do_with_store.invokeStatic(store.clj:54)"
"query_processor.store$do_with_store.invoke(store.clj:50)"
"query_processor.middleware.store$initialize_store$fn__73185.invoke(store.clj:11)"
"query_processor.middleware.normalize_query$normalize$fn__77318.invoke(normalize_query.clj:36)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__74712.invoke(constraints.clj:54)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__77247.invoke(process_userland_query.clj:151)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__77644.invoke(catch_exceptions.clj:171)"
"query_processor.reducible$async_qp$qp_STAR___66880$thunk__66882.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___66880$fn__66884.invoke(reducible.clj:108)"],
:card_id 37,
:context :question,
:error "Closed",
:row_count 0,
:running_time 0,
:preprocessed
{:database 5,
:type :query,
:query
{:source-query
{:native
"select\nKYKTHA.DATNO As DATNO\n, KYKTHA.KYKNO As KYKNO\n, KYKTRA.LINNO As LINNO\n, KYKTHA.KYKDT As KYKDT\n, to_date(trim(KYKTHA.KYKDT),'YYYY/MM/DD') as KYKDATE\n, KYKTHA.TOKRN As TOKRN\n, KYKTHA.TKYNM As TKYNM\n, KYKTRA.KOJNMA As KOJNMA\n, KYKTRA.KOJNMB As KOJNMB\n, Concat(KYKTRA.KOJNMA,KYKTRA.KOJNMB) As KOJNM\n, KYKTRA.ZAINM As ZAINM\n, KYKTRA.SIZNM As SIZNM\n, KYKTRA.KYKJYUSU As KYKJYUSU\n, KYKTRA.KYKTK As KYKTK\n, KYKTRA.KYKSB As KYKSB\nfrom\nKYKTHA\ninner join\nKYKTRA\non\nKYKTHA.DATNO = KYKTRA.DATNO\nwhere\nKYKTHA.DATKB = '1'\nand KYKTHA.HNSNM = '異形棒鋼'\nand KYKTHA.ODNKB = '10'\nand KYKTRA.LINNO < '990'"},
:source-metadata
[{:display_name "DATNO",
:field_ref [:field "DATNO" {:base-type :type/Text}],
:name "DATNO",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 16.0}}}}
{:display_name "KYKNO",
:field_ref [:field "KYKNO" {:base-type :type/Text}],
:name "KYKNO",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 8.0}}}}
{:display_name "LINNO",
:field_ref [:field "LINNO" {:base-type :type/Text}],
:name "LINNO",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :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.0}}}}
{:display_name "KYKDT",
:field_ref [:field "KYKDT" {:base-type :type/Text}],
:name "KYKDT",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 8.0}}}}
{:display_name "KYKDATE",
:field_ref [:field "KYKDATE" {:base-type :type/Date, :temporal-unit :default}],
:name "KYKDATE",
:base_type :type/Date,
:effective_type :type/Date,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 0.0},
:type {:type/DateTime {:earliest "2022-10-28T00:00:00+09:00", :latest "2022-10-28T00:00:00+09:00"}}}}
{:display_name "TOKRN",
:field_ref [:field "TOKRN" {:base-type :type/Text}],
:name "TOKRN",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 5.0}}}}
{:display_name "TKYNM",
:field_ref [:field "TKYNM" {:base-type :type/Text}],
:name "TKYNM",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 5.0}}}}
{:display_name "KOJNMA",
:field_ref [:field "KOJNMA" {:base-type :type/Text}],
:name "KOJNMA",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :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}}}}
{:display_name "KOJNMB",
:field_ref [:field "KOJNMB" {:base-type :type/Text}],
:name "KOJNMB",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :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}}}}
{:display_name "KOJNM",
:field_ref [:field "KOJNM" {:base-type :type/Text}],
:name "KOJNM",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 2.0}}}}
{:display_name "ZAINM",
:field_ref [:field "ZAINM" {:base-type :type/Text}],
:name "ZAINM",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 5.0}}}}
{:display_name "SIZNM",
:field_ref [:field "SIZNM" {:base-type :type/Text}],
:name "SIZNM",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :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.0}}}}
{:display_name "KYKJYUSU",
:field_ref [:field "KYKJYUSU" {:base-type :type/Decimal}],
:name "KYKJYUSU",
:base_type :type/Decimal,
:effective_type :type/Decimal,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 0.0},
:type {:type/Number {:min 166667.0, :q1 166667.0, :q3 166667.0, :max 166667.0, :sd nil, :avg 166667.0}}}}
{:display_name "KYKTK",
:field_ref [:field "KYKTK" {:base-type :type/Decimal}],
:name "KYKTK",
:base_type :type/Decimal,
:effective_type :type/Decimal,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 0.0},
:type {:type/Number {:min 98.0, :q1 98.0, :q3 98.0, :max 98.0, :sd nil, :avg 98.0}}}}
{:display_name "KYKSB",
:field_ref [:field "KYKSB" {:base-type :type/Text}],
:name "KYKSB",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :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}}}}],
:source-query/dataset? true,
:source-card-id 36,
:expressions {"pivot-grouping" [:abs 127]},
:breakout [[:expression "pivot-grouping"]],
:order-by [[:asc [:expression "pivot-grouping"]]],
:aggregation
[[:aggregation-options [:sum [:field "KYKJYUSU" {:base-type :type/Decimal}]] {:name "sum"}]
[:aggregation-options [:avg [:field "KYKTK" {:base-type :type/Decimal}]] {:name "avg"}]]},
:constraints {:max-results 10000, :max-results-bare-rows 2000},
:middleware {:js-int-to-string? true, :ignore-cached-results? false},
:async? true,
:info {:executed-by 1, :context :question, :card-id 37, :card-name "契約日報詳細(契約番号別)"}},
:data {:rows , :cols }}
2023/08/29 19:06:22.656 [clojure-agent-send-off-pool-5] ERROR metabase.query-processor.middleware.catch-exceptions クエリの実行中にエラーが発生しました: Closed
{:database_id 5,
:started_at #t "2023-08-29T19:04:57.999263800+09:00[Asia/Tokyo]",
:json_query
{:database 5,
:type :query,
:query
{:aggregation
[[:sum [:field "KYKJYUSU" {:base-type :type/Decimal}]] [:avg [:field "KYKTK" {:base-type :type/Decimal}]]],
:breakout
([:field "ZAINM" {:base-type :type/Text}]
[:field "KYKNO" {:base-type :type/Text}]
[:field "TOKRN" {:base-type :type/Text}]
[:field "TKYNM" {:base-type :type/Text}]
[:field "SIZNM" {:base-type :type/Text}]
[:field "KOJNM" {:base-type :type/Text}]
[:field "KYKDATE" {:base-type :type/Date, :temporal-unit :day}]
[:expression "pivot-grouping"]),
:source-table "card__36",
:expressions {:pivot-grouping [:abs 0]}},
:constraints {:max-results 10000, :max-results-bare-rows 2000},
:middleware {:js-int-to-string? true, :ignore-cached-results? false, :add-default-userland-constraints? true},
:async? true},
:native
{:query
"SELECT "source"."ZAINM" "ZAINM", "source"."KYKNO" "KYKNO", "source"."TOKRN" "TOKRN", "source"."TKYNM" "TKYNM", "source"."SIZNM" "SIZNM", "source"."KOJNM" "KOJNM", TRUNC("source"."KYKDATE", 'dd') "KYKDATE", "source"."pivot-grouping" "pivot-grouping", SUM("source"."KYKJYUSU") "sum", AVG("source"."KYKTK") "avg" FROM (SELECT "source"."KYKNO" "KYKNO", "source"."KYKDATE" "KYKDATE", "source"."TOKRN" "TOKRN", "source"."TKYNM" "TKYNM", "source"."KOJNM" "KOJNM", "source"."ZAINM" "ZAINM", "source"."SIZNM" "SIZNM", "source"."KYKJYUSU" "KYKJYUSU", "source"."KYKTK" "KYKTK", ABS(0) "pivot-grouping" FROM (select\nKYKTHA.DATNO As DATNO\n, KYKTHA.KYKNO As KYKNO\n, KYKTRA.LINNO As LINNO\n, KYKTHA.KYKDT As KYKDT\n, to_date(trim(KYKTHA.KYKDT),'YYYY/MM/DD') as KYKDATE\n, KYKTHA.TOKRN As TOKRN\n, KYKTHA.TKYNM As TKYNM\n, KYKTRA.KOJNMA As KOJNMA\n, KYKTRA.KOJNMB As KOJNMB\n, Concat(KYKTRA.KOJNMA,KYKTRA.KOJNMB) As KOJNM\n, KYKTRA.ZAINM As ZAINM\n, KYKTRA.SIZNM As SIZNM\n, KYKTRA.KYKJYUSU As KYKJYUSU\n, KYKTRA.KYKTK As KYKTK\n, KYKTRA.KYKSB As KYKSB\nfrom\nKYKTHA\ninner join\nKYKTRA\non\nKYKTHA.DATNO = KYKTRA.DATNO\nwhere\nKYKTHA.DATKB = '1'\nand KYKTHA.HNSNM = '異形棒鋼'\nand KYKTHA.ODNKB = '10'\nand KYKTRA.LINNO < '990') "source") "source" GROUP BY "source"."ZAINM", "source"."KYKNO", "source"."TOKRN", "source"."TKYNM", "source"."SIZNM", "source"."KOJNM", TRUNC("source"."KYKDATE", 'dd'), "source"."pivot-grouping" ORDER BY "source"."ZAINM" ASC, "source"."KYKNO" ASC, "source"."TOKRN" ASC, "source"."TKYNM" ASC, "source"."SIZNM" ASC, "source"."KOJNM" ASC, TRUNC("source"."KYKDATE", 'dd') ASC, "source"."pivot-grouping" ASC",
:params nil},
:status :failed,
:class org.eclipse.jetty.io.EofException,
:stacktrace
["org.eclipse.jetty.server.HttpOutput.checkWritable(HttpOutput.java:756)"
"org.eclipse.jetty.server.HttpOutput.write(HttpOutput.java:780)"
"java.base/java.util.zip.DeflaterOutputStream.flush(DeflaterOutputStream.java:277)"
"--> async.streaming_response$delay_output_stream$fn__39737.invoke(streaming_response.clj:123)"
"async.streaming_response.proxy$java.io.OutputStream$ff19274a.flush(Unknown Source)"
"query_processor.streaming.json$fn$reify__60552.finish_BANG_(json.clj:95)"
"query_processor.streaming$streaming_reducedf$fn__61376.invoke(streaming.clj:132)"
"query_processor.context$reducedf.invokeStatic(context.clj:78)"
"query_processor.context$reducedf.invoke(context.clj:73)"
"query_processor.pivot$append_queries_context$multiple_reducing__93254.invoke(pivot.clj:202)"
"query_processor.context$reducef.invokeStatic(context.clj:70)"
"query_processor.context$reducef.invoke(context.clj:63)"
"query_processor.context.default$default_runf$respond_STAR___60464.invoke(default.clj:69)"
"query_processor.pivot$append_queries_context$fn__93249$multiple_executef__93250.invoke(pivot.clj:184)"
"query_processor.context$executef.invokeStatic(context.clj:60)"
"query_processor.context$executef.invoke(context.clj:49)"
"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:46)"
"query_processor.context$runf.invoke(context.clj:40)"
"query_processor.reducible$identity_qp.invokeStatic(reducible.clj:15)"
"query_processor.reducible$identity_qp.invoke(reducible.clj:12)"
"query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___77111.invoke(cache.clj:224)"
"query_processor.middleware.permissions$check_query_permissions$fn__72694.invoke(permissions.clj:126)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__76236.invoke(mbql_to_native.clj:24)"
"query_processor$fn__78344$combined_post_process__78349$combined_post_process_STAR___78350.invoke(query_processor.clj:260)"
"query_processor$fn__78344$combined_pre_process__78345$combined_pre_process_STAR___78346.invoke(query_processor.clj:257)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__77022$fn__77027.invoke(resolve_database_and_driver.clj:36)"
"driver$do_with_driver.invokeStatic(driver.clj:93)"
"driver$do_with_driver.invoke(driver.clj:88)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__77022.invoke(resolve_database_and_driver.clj:35)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__73004.invoke(fetch_source_query.clj:312)"
"query_processor.middleware.store$initialize_store$fn__73185$fn__73186.invoke(store.clj:12)"
"query_processor.store$do_with_store.invokeStatic(store.clj:54)"
"query_processor.store$do_with_store.invoke(store.clj:50)"
"query_processor.middleware.store$initialize_store$fn__73185.invoke(store.clj:11)"
"query_processor.middleware.normalize_query$normalize$fn__77318.invoke(normalize_query.clj:36)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__74712.invoke(constraints.clj:54)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__77247.invoke(process_userland_query.clj:151)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__77644.invoke(catch_exceptions.clj:171)"
"query_processor.reducible$async_qp$qp_STAR___66880$thunk__66882.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___66880$fn__66884.invoke(reducible.clj:108)"],
:card_id 37,
:context :question,
:error "Closed",
:row_count 0,
:running_time 0,
:preprocessed
{:database 5,
:type :query,
:query
{:source-query
{:native
"select\nKYKTHA.DATNO As DATNO\n, KYKTHA.KYKNO As KYKNO\n, KYKTRA.LINNO As LINNO\n, KYKTHA.KYKDT As KYKDT\n, to_date(trim(KYKTHA.KYKDT),'YYYY/MM/DD') as KYKDATE\n, KYKTHA.TOKRN As TOKRN\n, KYKTHA.TKYNM As TKYNM\n, KYKTRA.KOJNMA As KOJNMA\n, KYKTRA.KOJNMB As KOJNMB\n, Concat(KYKTRA.KOJNMA,KYKTRA.KOJNMB) As KOJNM\n, KYKTRA.ZAINM As ZAINM\n, KYKTRA.SIZNM As SIZNM\n, KYKTRA.KYKJYUSU As KYKJYUSU\n, KYKTRA.KYKTK As KYKTK\n, KYKTRA.KYKSB As KYKSB\nfrom\nKYKTHA\ninner join\nKYKTRA\non\nKYKTHA.DATNO = KYKTRA.DATNO\nwhere\nKYKTHA.DATKB = '1'\nand KYKTHA.HNSNM = '異形棒鋼'\nand KYKTHA.ODNKB = '10'\nand KYKTRA.LINNO < '990'"},
:source-metadata
[{:display_name "DATNO",
:field_ref [:field "DATNO" {:base-type :type/Text}],
:name "DATNO",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 16.0}}}}
{:display_name "KYKNO",
:field_ref [:field "KYKNO" {:base-type :type/Text}],
:name "KYKNO",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 8.0}}}}
{:display_name "LINNO",
:field_ref [:field "LINNO" {:base-type :type/Text}],
:name "LINNO",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :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.0}}}}
{:display_name "KYKDT",
:field_ref [:field "KYKDT" {:base-type :type/Text}],
:name "KYKDT",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 8.0}}}}
{:display_name "KYKDATE",
:field_ref [:field "KYKDATE" {:base-type :type/Date, :temporal-unit :default}],
:name "KYKDATE",
:base_type :type/Date,
:effective_type :type/Date,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 0.0},
:type {:type/DateTime {:earliest "2022-10-28T00:00:00+09:00", :latest "2022-10-28T00:00:00+09:00"}}}}
{:display_name "TOKRN",
:field_ref [:field "TOKRN" {:base-type :type/Text}],
:name "TOKRN",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 5.0}}}}
{:display_name "TKYNM",
:field_ref [:field "TKYNM" {:base-type :type/Text}],
:name "TKYNM",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 5.0}}}}
{:display_name "KOJNMA",
:field_ref [:field "KOJNMA" {:base-type :type/Text}],
:name "KOJNMA",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :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}}}}
{:display_name "KOJNMB",
:field_ref [:field "KOJNMB" {:base-type :type/Text}],
:name "KOJNMB",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :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}}}}
{:display_name "KOJNM",
:field_ref [:field "KOJNM" {:base-type :type/Text}],
:name "KOJNM",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 2.0}}}}
{:display_name "ZAINM",
:field_ref [:field "ZAINM" {:base-type :type/Text}],
:name "ZAINM",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 0.0},
:type
{:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 5.0}}}}
{:display_name "SIZNM",
:field_ref [:field "SIZNM" {:base-type :type/Text}],
:name "SIZNM",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :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.0}}}}
{:display_name "KYKJYUSU",
:field_ref [:field "KYKJYUSU" {:base-type :type/Decimal}],
:name "KYKJYUSU",
:base_type :type/Decimal,
:effective_type :type/Decimal,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 0.0},
:type {:type/Number {:min 166667.0, :q1 166667.0, :q3 166667.0, :max 166667.0, :sd nil, :avg 166667.0}}}}
{:display_name "KYKTK",
:field_ref [:field "KYKTK" {:base-type :type/Decimal}],
:name "KYKTK",
:base_type :type/Decimal,
:effective_type :type/Decimal,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 0.0},
:type {:type/Number {:min 98.0, :q1 98.0, :q3 98.0, :max 98.0, :sd nil, :avg 98.0}}}}
{:display_name "KYKSB",
:field_ref [:field "KYKSB" {:base-type :type/Text}],
:name "KYKSB",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :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}}}}],
:source-query/dataset? true,
:source-card-id 36,
:expressions {"pivot-grouping" [:abs 0]},
:breakout
[[:field "ZAINM" {:base-type :type/Text}]
[:field "KYKNO" {:base-type :type/Text}]
[:field "TOKRN" {:base-type :type/Text}]
[:field "TKYNM" {:base-type :type/Text}]
[:field "SIZNM" {:base-type :type/Text}]
[:field "KOJNM" {:base-type :type/Text}]
[:field "KYKDATE" {:base-type :type/Date, :temporal-unit :day}]
[:expression "pivot-grouping"]],
:order-by
[[:asc [:field "ZAINM" {:base-type :type/Text}]]
[:asc [:field "KYKNO" {:base-type :type/Text}]]
[:asc [:field "TOKRN" {:base-type :type/Text}]]
[:asc [:field "TKYNM" {:base-type :type/Text}]]
[:asc [:field "SIZNM" {:base-type :type/Text}]]
[:asc [:field "KOJNM" {:base-type :type/Text}]]
[:asc [:field "KYKDATE" {:base-type :type/Date, :temporal-unit :day}]]
[:asc [:expression "pivot-grouping"]]],
:aggregation
[[:aggregation-options [:sum [:field "KYKJYUSU" {:base-type :type/Decimal}]] {:name "sum"}]
[:aggregation-options [:avg [:field "KYKTK" {:base-type :type/Decimal}]] {:name "avg"}]]},
:constraints {:max-results 10000, :max-results-bare-rows 2000},
:middleware {:js-int-to-string? true, :ignore-cached-results? false, :add-default-userland-constraints? true},
:async? true,
:info {:executed-by 1, :context :question, :card-id 37, :card-name "契約日報詳細(契約番号別)"}},
:data {:rows , :cols }}