I keep getting this issue intermittently:
Here is the troubleshooting log:
[fa7ec006-1020-4af7-8c84-d541e49b2367] 2021-06-09T11:33:22+05:30 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 2,
:started_at #t "2021-06-09T11:31:22.289520+05:30[Asia/Kolkata]",
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :query,
:middleware {:js-int-to-string? true},
:database 2,
:query
{:source-table 171,
:aggregation [[:distinct [:field 2167 nil]]],
:filter [:and [:= [:field 2182 nil] false] [:= [:field 2389 nil] "Yes"]]},
:parameters
[{:type "category", :value "2020-21", :target ["dimension" ["field" 2163 nil]]}
{:type "category", :value ["4" "5" "6"], :target ["dimension" ["field" 2191 nil]]}
{:type "category", :value ["00-05" "06-12" "13-18"], :target ["dimension" ["field" 2620 nil]]}],
:async? true,
:cache-ttl 819220},
:native
{:query
"SELECT count(distinct \"dbo\".\"Metabase_AKEB_Student_Master\".\"school_name\") AS \"count\" FROM \"dbo\".\"Metabase_AKEB_Student_Master\" WHERE (\"dbo\".\"Metabase_AKEB_Student_Master\".\"is_migrated\" = 0 AND \"dbo\".\"Metabase_AKEB_Student_Master\".\"ed_is_latest\" = ? AND \"dbo\".\"Metabase_AKEB_Student_Master\".\"academic_year\" = ? AND (\"dbo\".\"Metabase_AKEB_Student_Master\".\"age\" = 4 OR \"dbo\".\"Metabase_AKEB_Student_Master\".\"age\" = 5 OR \"dbo\".\"Metabase_AKEB_Student_Master\".\"age\" = 6) AND (\"dbo\".\"Metabase_AKEB_Student_Master\".\"AgeGroup\" = ? OR \"dbo\".\"Metabase_AKEB_Student_Master\".\"AgeGroup\" = ? OR \"dbo\".\"Metabase_AKEB_Student_Master\".\"AgeGroup\" = ?))",
:params ("Yes" "2020-21" "00-05" "06-12" "13-18")},
:status :failed,
:class org.eclipse.jetty.io.EofException,
:stacktrace
["org.eclipse.jetty.server.HttpConnection$SendCallback.reset(HttpConnection.java:724)"
"org.eclipse.jetty.server.HttpConnection$SendCallback.access$300(HttpConnection.java:683)"
"org.eclipse.jetty.server.HttpConnection.send(HttpConnection.java:542)"
"org.eclipse.jetty.server.HttpChannel.sendResponse(HttpChannel.java:833)"
"org.eclipse.jetty.server.HttpChannel.write(HttpChannel.java:910)"
"org.eclipse.jetty.server.HttpOutput.channelWrite(HttpOutput.java:284)"
"org.eclipse.jetty.server.HttpOutput.channelWrite(HttpOutput.java:268)"
"org.eclipse.jetty.server.HttpOutput.flush(HttpOutput.java:713)"
"java.base/java.util.zip.DeflaterOutputStream.flush(DeflaterOutputStream.java:282)"
"--> async.streaming_response$delay_output_stream$fn__16088.invoke(streaming_response.clj:119)"
"async.streaming_response.proxy$java.io.OutputStream$ff19274a.flush(Unknown Source)"
"query_processor.streaming.json$fn$reify__55213.finish_BANG_(json.clj:84)"
"query_processor.streaming$streaming_reducedf$fn__55713.invoke(streaming.clj:39)"
"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:64)"
"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___37182.invoke(default.clj:69)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:475)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:453)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:462)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:453)"
"driver.sql_jdbc$fn__80985.invokeStatic(sql_jdbc.clj:54)"
"driver.sql_jdbc$fn__80985.invoke(sql_jdbc.clj:52)"
"query_processor.context$executef.invokeStatic(context.clj:59)"
"query_processor.context$executef.invoke(context.clj:48)"
"query_processor.context.default$default_runf.invokeStatic(default.clj:68)"
"query_processor.context.default$default_runf.invoke(default.clj:66)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
"query_processor.reducible$pivot.invoke(reducible.clj:31)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__47305.invoke(mbql_to_native.clj:25)"
"query_processor.middleware.check_features$check_features$fn__46547.invoke(check_features.clj:39)"
"query_processor.middleware.limit$limit$fn__47291.invoke(limit.clj:37)"
"query_processor.middleware.cache$run_query_with_cache.invokeStatic(cache.clj:184)"
"query_processor.middleware.cache$run_query_with_cache.invoke(cache.clj:175)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__45999.invoke(cache.clj:210)"
"query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__47551.invoke(optimize_temporal_filters.clj:204)"
"query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__49481.invoke(validate_temporal_bucketing.clj:50)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__45118.invoke(auto_parse_filter_values.clj:43)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__41435.invoke(wrap_value_literals.clj:161)"
"query_processor.middleware.annotate$add_column_info$fn__41310.invoke(annotate.clj:605)"
"query_processor.middleware.permissions$check_query_permissions$fn__46419.invoke(permissions.clj:81)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__48409.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46620.invoke(cumulative_aggregations.clj:60)"
"query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__48708.invoke(resolve_joined_fields.clj:102)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__49021.invoke(resolve_joins.clj:171)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__44694.invoke(add_implicit_joins.clj:190)"
"query_processor.middleware.large_int_id$convert_id_to_string$fn__47255.invoke(large_int_id.clj:59)"
"query_processor.middleware.format_rows$format_rows$fn__47236.invoke(format_rows.clj:74)"
"query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__43988.invoke(add_default_temporal_unit.clj:23)"
"query_processor.middleware.desugar$desugar$fn__46686.invoke(desugar.clj:21)"
"query_processor.middleware.binning$update_binning_strategy$fn__45505.invoke(binning.clj:227)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__46222.invoke(resolve_fields.clj:34)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__44343.invoke(add_dimension_projections.clj:314)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__44572.invoke(add_implicit_clauses.clj:147)"
"query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__49430.invoke(upgrade_field_literals.clj:40)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__44857.invoke(add_source_metadata.clj:123)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__48583.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__45065.invoke(auto_bucket_datetimes.clj:147)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__46269.invoke(resolve_source_table.clj:45)"
"query_processor.middleware.parameters$substitute_parameters$fn__48391.invoke(parameters.clj:111)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__46321.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__46942.invoke(expand_macros.clj:155)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__44866.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__49383.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__48594$fn__48598.invoke(resolve_database_and_driver.clj:31)"
"driver$do_with_driver.invokeStatic(driver.clj:60)"
"driver$do_with_driver.invoke(driver.clj:56)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__48594.invoke(resolve_database_and_driver.clj:25)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__47182.invoke(fetch_source_query.clj:274)"
"query_processor.middleware.store$initialize_store$fn__49392$fn__49393.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__49392.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__49437.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__47318.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__44712.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49368.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__46563.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__48480.invoke(process_userland_query.clj:135)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__46503.invoke(catch_exceptions.clj:173)"
"query_processor.reducible$async_qp$qp_STAR___37989$thunk__37990.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___37989$fn__37992.invoke(reducible.clj:108)"],
:context :question,
:error nil,
:row_count 0,
:running_time 0,
:preprocessed
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :query,
:middleware {:js-int-to-string? true},
:user-parameters
[{:type :category, :value "2020-21", :target [:dimension [:field 2163 nil]]}
{:type :category, :value ["4" "5" "6"], :target [:dimension [:field 2191 nil]]}
{:type :category, :value ["00-05" "06-12" "13-18"], :target [:dimension [:field 2620 nil]]}],
:info
{:executed-by 1,
:context :question,
:card-id 84,
:query-hash
[88, -126, 33, 52, -35, 16, -98, -110, 56, -60, -37, -30, 39, 5, -19, 43, 11, -102, -79, -120, -40, 26, -58, -109,
9, -74, -77, -112, -104, 19, -68, -69]},
:database 2,
:query
{:source-table 171,
:aggregation [[:aggregation-options [:distinct [:field 2167 nil]] {:name "count"}]],
:filter
[:and
[:=
[:field 2182 nil]
[:value
false
{:base_type :type/Boolean,
:effective_type :type/Boolean,
:coercion_strategy nil,
:semantic_type :type/Category,
:database_type "bit",
:name "is_migrated"}]]
[:=
[:field 2389 nil]
[:value
"Yes"
{:base_type :type/Text,
:effective_type :type/Text,
:coercion_strategy nil,
:semantic_type nil,
:database_type "varchar",
:name "ed_is_latest"}]]
[:=
[:field 2163 nil]
[:value
"2020-21"
{:base_type :type/Text,
:effective_type :type/Text,
:coercion_strategy nil,
:semantic_type :type/Category,
:database_type "nvarchar",
:name "academic_year"}]]
[:or
[:=
[:field 2191 nil]
[:value
4
{:base_type :type/Integer,
:effective_type :type/Integer,
:coercion_strategy nil,
:semantic_type :type/Category,
:database_type "int",
:name "age"}]]
[:=
[:field 2191 nil]
[:value
5
{:base_type :type/Integer,
:effective_type :type/Integer,
:coercion_strategy nil,
:semantic_type :type/Category,
:database_type "int",
:name "age"}]]
[:=
[:field 2191 nil]
[:value
6
{:base_type :type/Integer,
:effective_type :type/Integer,
:coercion_strategy nil,
:semantic_type :type/Category,
:database_type "int",
:name "age"}]]]
[:or
[:=
[:field 2620 nil]
[:value
"00-05"
{:base_type :type/Text,
:effective_type :type/Text,
:coercion_strategy nil,
:semantic_type :type/Category,
:database_type "varchar",
:name "AgeGroup"}]]
[:=
[:field 2620 nil]
[:value
"06-12"
{:base_type :type/Text,
:effective_type :type/Text,
:coercion_strategy nil,
:semantic_type :type/Category,
:database_type "varchar",
:name "AgeGroup"}]]
[:=
[:field 2620 nil]
[:value
"13-18"
{:base_type :type/Text,
:effective_type :type/Text,
:coercion_strategy nil,
:semantic_type :type/Category,
:database_type "varchar",
:name "AgeGroup"}]]]]},
:async? true,
:cache-ttl 819220},
:data {:rows [], :cols []}}
Diagnostic Details:
{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:89.0) Gecko/20100101 Firefox/89.0",
"vendor": ""
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.11+9-Ubuntu-0ubuntu2.18.04",
"java.vendor": "Ubuntu",
"java.vendor.url": "https://ubuntu.com/",
"java.version": "11.0.11",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.11+9-Ubuntu-0ubuntu2.18.04",
"os.name": "Linux",
"os.version": "5.4.0-56-generic",
"user.language": "en",
"user.timezone": "Asia/Kolkata"
},
"metabase-info": {
"databases": [
"sqlserver"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.3 (Ubuntu 12.3-1.pgdg18.04+1)"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.18"
}
},
"run-mode": "prod",
"version": {
"date": "2021-05-17",
"tag": "v0.39.2",
"branch": "release-x.39.x",
"hash": "b0d9436"
},
"settings": {
"report-timezone": null
}
}
}