After we made the most recent Metabase update, we've had issues with questions loading. They end up at a screen that says "something's gone wrong". The questions load on their dashboards, but if you try to click into the individual question, the page doesn't load. We aren't even able to see the query written.
Hi @mihikaanaik
Post "Diagnostic Info" from Admin > Troubleshooting.
And post the full stacktrace error from Admin > Troubleshooting > Logs.
- Post "Diagnostic Info" from Admin > Troubleshooting.
- You need to provide the full stacktrace from the logs. That is only the query.
[9de90245-faad-4553-a7ab-b2ffd9cc4f3b] 2021-11-03T15:07:56-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 2,
:started_at #t "2021-11-03T15:07:49.207734-07:00[America/Los_Angeles]",
:via
[{:status :failed,
:class clojure.lang.ExceptionInfo,
:error "Error executing query",
:stacktrace
["--> driver.sql_jdbc.execute$execute_reducible_query$fn__40722.invoke(execute.clj:504)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:501)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:496)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
"driver.sql_jdbc$fn__89884.invokeStatic(sql_jdbc.clj:54)"
"driver.sql_jdbc$fn__89884.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__49996.invoke(mbql_to_native.clj:25)"
"query_processor.middleware.check_features$check_features$fn__50483.invoke(check_features.clj:39)"
"query_processor.middleware.limit$limit$fn__48369.invoke(limit.clj:37)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__50857.invoke(cache.clj:204)"
"query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__51850.invoke(optimize_temporal_filters.clj:204)"
"query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__51894.invoke(validate_temporal_bucketing.clj:50)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__50053.invoke(auto_parse_filter_values.clj:43)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__36884.invoke(wrap_value_literals.clj:161)"
"query_processor.middleware.annotate$add_column_info$fn__42025.invoke(annotate.clj:615)"
"query_processor.middleware.permissions$check_query_permissions$fn__46524.invoke(permissions.clj:108)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__51034.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46922.invoke(cumulative_aggregations.clj:60)"
"metabase_enterprise.sandbox.query_processor.middleware.row_level_restrictions$apply_row_level_permissions$fn__87763.invoke(row_level_restrictions.clj:338)"
"query_processor.middleware.visualization_settings$update_viz_settings$fn__46860.invoke(visualization_settings.clj:63)"
"query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47967.invoke(resolve_joined_fields.clj:102)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__51620.invoke(resolve_joins.clj:171)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__51156.invoke(add_implicit_joins.clj:190)"
"query_processor.middleware.large_int_id$convert_id_to_string$fn__47986.invoke(large_int_id.clj:59)"
"query_processor.middleware.format_rows$format_rows$fn__51208.invoke(format_rows.clj:74)"
"query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__47358.invoke(add_default_temporal_unit.clj:23)"
"query_processor.middleware.desugar$desugar$fn__46833.invoke(desugar.clj:21)"
"query_processor.middleware.binning$update_binning_strategy$fn__45774.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__46167.invoke(resolve_fields.clj:34)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__50408.invoke(add_dimension_projections.clj:312)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__50706.invoke(add_implicit_clauses.clj:147)"
"metabase_enterprise.sandbox.query_processor.middleware.row_level_restrictions$apply_row_level_permissions$fn__87763.invoke(row_level_restrictions.clj:338)"
"query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__48354.invoke(upgrade_field_literals.clj:40)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__47735.invoke(add_source_metadata.clj:123)"
"metabase_enterprise.sandbox.query_processor.middleware.column_level_perms_check$maybe_apply_column_level_perms_check$fn__86149.invoke(column_level_perms_check.clj:30)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__50956.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__49305.invoke(auto_bucket_datetimes.clj:147)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__46148.invoke(resolve_source_table.clj:45)"
"query_processor.middleware.parameters$substitute_parameters$fn__48959.invoke(parameters.clj:111)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__46221.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__52278.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__48738.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__51223.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50717$fn__50721.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__50717.invoke(resolve_database_and_driver.clj:25)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46771.invoke(fetch_source_query.clj:274)"
"query_processor.middleware.store$initialize_store$fn__46959$fn__46960.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__46959.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__51006.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__51013.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__48684.invoke(add_rows_truncated.clj:35)"
"metabase_enterprise.audit_app.query_processor.middleware.handle_audit_queries$handle_internal_queries$fn__40890.invoke(handle_audit_queries.clj:130)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49982.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__48702.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50992.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__51303.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___40178$thunk__40179.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___40178$fn__40181.invoke(reducible.clj:108)"],
:error_type :invalid-query,
:ex-data
{:sql
"-- Metabase:: userID: 450 queryType: native queryHash: 5bbbbc096c6f2830bd78d9c36235efccf21133bfa9fd8ac22cd6b8dc2ce5d693\nwith main_sql as \n(SELECT \n CASE \n WHEN completed_at IS NOT NULL THEN completed_at::DATE\n WHEN completed_at IS NULL AND start_time IS NOT NULL THEN start_time::DATE\n WHEN completed_at IS NULL AND start_time IS NULL THEN appointments.updated_at::DATE\n END AS appt_date, \n CASE \n WHEN LOWER(?) = 'testing site' THEN testing_sites.name\n ELSE facilities.name\n END as grouping,\n appointments.completed_at,\n appointments.appointment_window_id,\n appointment_windows.end_time,\n appointments.updated_at,\n appointments.canceled_at,\n appointments.source,\n appointments.walkin,\n appointments.created_at\nFROM appointments\n LEFT JOIN appointment_windows\n ON appointments.appointment_window_id = appointment_windows.id\n LEFT JOIN testing_sites \n ON testing_sites.id = appointments.testing_site_id \n LEFT JOIN facilities\n ON facilities.id = testing_sites.facility_id\nWHERE TRUE \n AND testing_sites.facility_id NOT IN (10, 195, 197, 343, 148, 180)\n AND TRIM(UPPER(testing_sites.state)) NOT IN ('CA','TX','FL', 'AL', 'MS', 'GA', 'SC', 'LA')\n AND (testing_sites.state IS NOT NULL AND testing_sites.state != '')\n \n \n )\n, no_show_rates as (\nSELECT \n grouping,\n ((non_completed_appts)*1.0)/total_appts as \"No Show Rate\",\n total_appts as \"Total Appts\"\nFROM\n (SELECT \n grouping,\n SUM(COUNT(*) FILTER (WHERE completed_at IS NULL AND appointment_window_id IS NOT NULL AND end_time < NOW()) + COUNT(*) FILTER (WHERE completed_at IS NULL AND (walkin IS TRUE OR source IN ('WALK_UP')) AND appt_date < NOW())) OVER(PARTITION BY grouping) as non_completed_appts,\n SUM(COUNT(*)) OVER(PARTITION BY grouping) as total_appts \n FROM \n main_sql \n WHERE \n appt_date >= current_date - 6\n AND appt_date <= NOW()\n GROUP BY\n 1) as t1) \n,untaken_slots as (\nSELECT \n CASE \n WHEN LOWER(?) = 'testing site' THEN testing_sites.name\n ELSE facilities.name\n END as grouping,\n SUM(slots_available)*1.0 / NULLIF(SUM(total_slots),0) as \"Untaken Slots %\",\n SUM(total_slots) as \"Total Slots\"\nFROM \n appointment_windows\n LEFT JOIN testing_sites ON testing_sites.id = appointment_windows.testing_site_id \n LEFT JOIN facilities ON facilities.id = testing_sites.facility_id\nWHERE TRUE\n AND appointment_windows.end_time < NOW()\n AND appointment_windows.end_time >= current_date - 6\n AND testing_sites.facility_id NOT IN (10, 195, 197, 343, 148)\n AND TRIM(UPPER(testing_sites.state)) NOT IN ('CA','TX','FL')\n AND (testing_sites.state IS NOT NULL AND testing_sites.state != '')\n \n \nGROUP BY \n 1)\n,walk_ups_and_positives as (\nSELECT\n CASE \n WHEN LOWER(?) = 'testing site' THEN testing_sites.name\n ELSE facilities.name\n END as grouping,\n testing_sites.state as \"State\",\n COUNT(*) FILTER (WHERE (appointments.walkin IS TRUE OR appointments.source IN ('WALK_UP')))*1.0 / NULLIF(COUNT(*),0) as \"Walk Up %\",\n COUNT(*) as \"# Samples Collected\",\n COUNT(*) FILTER (WHERE appointments.result IN ('POSITIVE')) as \"# Positives\", \n COUNT(*) FILTER (WHERE appointments.result IN ('POSITIVE'))*1.0 / NULLIF(COUNT(*),0) as \"% Positives\" \nFROM \n appointments \n LEFT JOIN testing_sites ON testing_sites.id = appointments.testing_site_id \n LEFT JOIN facilities ON facilities.id = testing_sites.facility_id\nWHERE TRUE\n AND testing_sites.facility_id NOT IN (10, 195, 197, 343, 148)\n AND TRIM(UPPER(testing_sites.state)) NOT IN ('CA','TX','FL')\n AND (testing_sites.state IS NOT NULL AND testing_sites.state != '')\n AND appointments.completed_at::date >= current_date - 6\n \n \nGROUP BY \n 1, 2) \n \nSELECT \n walk_ups_and_positives.grouping as \"Grouping\",\n \"State\",\n \"Untaken Slots %\",\n \"Total Slots\",\n \"No Show Rate\",\n \"Total Appts\",\n \"Walk Up %\",\n \"# Samples Collected\",\n \"# Positives\",\n \"% Positives\" \nFROM \n walk_ups_and_positives\n LEFT JOIN untaken_slots ON untaken_slots.grouping = walk_ups_and_positives.grouping\n LEFT JOIN no_show_rates ON no_show_rates.grouping = walk_ups_and_positives.grouping\nORDER BY\n 2",
:params ["testing site" "testing site" "testing site"],
:type :invalid-query}}],
:state "57014",
:error_type :invalid-query,
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :native,
:middleware {:js-int-to-string? true, :ignore-cached-results? false, :process-viz-settings? false},
:native
{:template-tags
{"snippet: National Filter"
{:id "4a901484-44b6-a0d1-3eec-6566b50230f4",
:name "snippet: National Filter",
:display-name "Snippet: national filter",
:type :snippet,
:snippet-name "National Filter",
:snippet-id 10},
"state"
{:id "eccf50aa-d6c0-88b2-cd9a-656b0cc70fdf",
:name "state",
:display-name "State",
:type :dimension,
:dimension [:field 227 nil],
:widget-type :location/state},
"facility_id"
{:id "c04a2828-5c7f-2166-526c-6b4d439bdff4",
:name "facility_id",
:display-name "Facility",
:type :dimension,
:dimension [:field 182 nil],
:widget-type :id},
"grouping"
{:id "d58835ef-813e-0155-d147-97489946dc21",
:name "grouping",
:display-name "Grouping",
:type :text,
:required true,
:default "testing site"}},
:query
"with main_sql as \n(SELECT \n CASE \n WHEN completed_at IS NOT NULL THEN completed_at::DATE\n WHEN completed_at IS NULL AND start_time IS NOT NULL THEN start_time::DATE\n WHEN completed_at IS NULL AND start_time IS NULL THEN appointments.updated_at::DATE\n END AS appt_date, \n CASE \n WHEN LOWER({{grouping}}) = 'testing site' THEN testing_sites.name\n ELSE facilities.name\n END as grouping,\n appointments.completed_at,\n appointments.appointment_window_id,\n appointment_windows.end_time,\n appointments.updated_at,\n appointments.canceled_at,\n appointments.source,\n appointments.walkin,\n appointments.created_at\nFROM appointments\n LEFT JOIN appointment_windows\n ON appointments.appointment_window_id = appointment_windows.id\n LEFT JOIN testing_sites \n ON testing_sites.id = appointments.testing_site_id \n LEFT JOIN facilities\n ON facilities.id = testing_sites.facility_id\nWHERE TRUE \n {{snippet: National Filter}}\n [[AND {{state}}]]\n [[AND {{facility_id}}]]\n )\n, no_show_rates as (\nSELECT \n grouping,\n ((non_completed_appts)*1.0)/total_appts as \"No Show Rate\",\n total_appts as \"Total Appts\"\nFROM\n (SELECT \n grouping,\n SUM(COUNT(*) FILTER (WHERE completed_at IS NULL AND appointment_window_id IS NOT NULL AND end_time < NOW()) + COUNT(*) FILTER (WHERE completed_at IS NULL AND (walkin IS TRUE OR source IN ('WALK_UP')) AND appt_date < NOW())) OVER(PARTITION BY grouping) as non_completed_appts,\n SUM(COUNT(*)) OVER(PARTITION BY grouping) as total_appts \n FROM \n main_sql \n WHERE \n appt_date >= current_date - 6\n AND appt_date <= NOW()\n GROUP BY\n 1) as t1) \n,untaken_slots as (\nSELECT \n CASE \n WHEN LOWER({{grouping}}) = 'testing site' THEN testing_sites.name\n ELSE facilities.name\n END as grouping,\n SUM(slots_available)*1.0 / NULLIF(SUM(total_slots),0) as \"Untaken Slots %\",\n SUM(total_slots) as \"Total Slots\"\nFROM \n appointment_windows\n LEFT JOIN testing_sites ON testing_sites.id = appointment_windows.testing_site_id \n LEFT JOIN facilities ON facilities.id = testing_sites.facility_id\nWHERE TRUE\n AND appointment_windows.end_time < NOW()\n AND appointment_windows.end_time >= current_date - 6\n AND testing_sites.facility_id NOT IN (10, 195, 197, 343, 148)\n AND TRIM(UPPER(testing_sites.state)) NOT IN ('CA','TX','FL')\n AND (testing_sites.state IS NOT NULL AND testing_sites.state != '')\n [[AND {{state}}]]\n [[AND {{facility_id}}]]\nGROUP BY \n 1)\n,walk_ups_and_positives as (\nSELECT\n CASE \n WHEN LOWER({{grouping}}) = 'testing site' THEN testing_sites.name\n ELSE facilities.name\n END as grouping,\n testing_sites.state as \"State\",\n COUNT(*) FILTER (WHERE (appointments.walkin IS TRUE OR appointments.source IN ('WALK_UP')))*1.0 / NULLIF(COUNT(*),0) as \"Walk Up %\",\n COUNT(*) as \"# Samples Collected\",\n COUNT(*) FILTER (WHERE appointments.result IN ('POSITIVE')) as \"# Positives\", \n COUNT(*) FILTER (WHERE appointments.result IN ('POSITIVE'))*1.0 / NULLIF(COUNT(*),0) as \"% Positives\" \nFROM \n appointments \n LEFT JOIN testing_sites ON testing_sites.id = appointments.testing_site_id \n LEFT JOIN facilities ON facilities.id = testing_sites.facility_id\nWHERE TRUE\n AND testing_sites.facility_id NOT IN (10, 195, 197, 343, 148)\n AND TRIM(UPPER(testing_sites.state)) NOT IN ('CA','TX','FL')\n AND (testing_sites.state IS NOT NULL AND testing_sites.state != '')\n AND appointments.completed_at::date >= current_date - 6\n [[AND {{facility_id}}]]\n [[AND {{state}}]]\nGROUP BY \n 1, 2) \n \nSELECT \n walk_ups_and_positives.grouping as \"Grouping\",\n \"State\",\n \"Untaken Slots %\",\n \"Total Slots\",\n \"No Show Rate\",\n \"Total Appts\",\n \"Walk Up %\",\n \"# Samples Collected\",\n \"# Positives\",\n \"% Positives\" \nFROM \n walk_ups_and_positives\n LEFT JOIN untaken_slots ON untaken_slots.grouping = walk_ups_and_positives.grouping\n LEFT JOIN no_show_rates ON no_show_rates.grouping = walk_ups_and_positives.grouping\nORDER BY\n 2\n "},
:database 2,
:parameters [],
:async? true,
:cache-ttl nil},
:status :failed,
:class org.postgresql.util.PSQLException,
:stacktrace
["org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2552)"
"org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2284)"
"org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:322)"
"org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481)"
"org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401)"
"org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164)"
"org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114)"
"com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:431)"
"--> driver.sql_jdbc.execute$fn__40640.invokeStatic(execute.clj:364)"
"driver.sql_jdbc.execute$fn__40640.invoke(execute.clj:362)"
"driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:377)"
"driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invoke(execute.clj:373)"
"driver.sql_jdbc.execute$execute_reducible_query$fn__40722.invoke(execute.clj:502)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:501)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:496)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
"driver.sql_jdbc$fn__89884.invokeStatic(sql_jdbc.clj:54)"
"driver.sql_jdbc$fn__89884.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__49996.invoke(mbql_to_native.clj:25)"
"query_processor.middleware.check_features$check_features$fn__50483.invoke(check_features.clj:39)"
"query_processor.middleware.limit$limit$fn__48369.invoke(limit.clj:37)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__50857.invoke(cache.clj:204)"
"query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__51850.invoke(optimize_temporal_filters.clj:204)"
"query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__51894.invoke(validate_temporal_bucketing.clj:50)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__50053.invoke(auto_parse_filter_values.clj:43)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__36884.invoke(wrap_value_literals.clj:161)"
"query_processor.middleware.annotate$add_column_info$fn__42025.invoke(annotate.clj:615)"
"query_processor.middleware.permissions$check_query_permissions$fn__46524.invoke(permissions.clj:108)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__51034.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46922.invoke(cumulative_aggregations.clj:60)"
"metabase_enterprise.sandbox.query_processor.middleware.row_level_restrictions$apply_row_level_permissions$fn__87763.invoke(row_level_restrictions.clj:338)"
"query_processor.middleware.visualization_settings$update_viz_settings$fn__46860.invoke(visualization_settings.clj:63)"
"query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47967.invoke(resolve_joined_fields.clj:102)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__51620.invoke(resolve_joins.clj:171)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__51156.invoke(add_implicit_joins.clj:190)"
"query_processor.middleware.large_int_id$convert_id_to_string$fn__47986.invoke(large_int_id.clj:59)"
"query_processor.middleware.format_rows$format_rows$fn__51208.invoke(format_rows.clj:74)"
"query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__47358.invoke(add_default_temporal_unit.clj:23)"
"query_processor.middleware.desugar$desugar$fn__46833.invoke(desugar.clj:21)"
"query_processor.middleware.binning$update_binning_strategy$fn__45774.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__46167.invoke(resolve_fields.clj:34)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__50408.invoke(add_dimension_projections.clj:312)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__50706.invoke(add_implicit_clauses.clj:147)"
"metabase_enterprise.sandbox.query_processor.middleware.row_level_restrictions$apply_row_level_permissions$fn__87763.invoke(row_level_restrictions.clj:338)"
"query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__48354.invoke(upgrade_field_literals.clj:40)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__47735.invoke(add_source_metadata.clj:123)"
"metabase_enterprise.sandbox.query_processor.middleware.column_level_perms_check$maybe_apply_column_level_perms_check$fn__86149.invoke(column_level_perms_check.clj:30)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__50956.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__49305.invoke(auto_bucket_datetimes.clj:147)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__46148.invoke(resolve_source_table.clj:45)"
"query_processor.middleware.parameters$substitute_parameters$fn__48959.invoke(parameters.clj:111)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__46221.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__52278.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__48738.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__51223.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50717$fn__50721.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__50717.invoke(resolve_database_and_driver.clj:25)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46771.invoke(fetch_source_query.clj:274)"
"query_processor.middleware.store$initialize_store$fn__46959$fn__46960.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__46959.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__51006.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__51013.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__48684.invoke(add_rows_truncated.clj:35)"
"metabase_enterprise.audit_app.query_processor.middleware.handle_audit_queries$handle_internal_queries$fn__40890.invoke(handle_audit_queries.clj:130)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49982.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__48702.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50992.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__51303.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___40178$thunk__40179.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___40178$fn__40181.invoke(reducible.clj:108)"],
:card_id 2531,
:context :question,
:error "ERROR: canceling statement due to user request",
:row_count 0,
:running_time 0,
:data {:rows [], :cols []}}
@mihikaanaik That is being cancelled by the database:
https://stackoverflow.com/questions/13114101/postgresql-error-canceling-statement-due-to-user-request
we're getting this error though - where the webpage doesn't load at all. The user isn't canceling the query.
I think we are not getting the proper logs for the queries we are trying to load. So when we go to Troubleshooting it is not showing logs for the questions that are showing up as "Something's gone wrong"
@mihikaanaik I'm not asking for logs, I'm asking for "Diagnostic Info" from Admin > Troubleshooting.
It's likely that the requests are intercepted by a reverse-proxy, which is causing all the problems.
https://www.metabase.com/docs/latest/troubleshooting-guide/proxies.html
Who knows, it's difficult to tell without logs or request data.
I would recommend that you revert to your backup before you upgraded.
{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.54 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.12+7",
"java.vendor": "Eclipse Foundation",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.12",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.12+7",
"os.name": "Linux",
"os.version": "4.14.243-185.433.amzn2.x86_64",
"user.language": "en",
"user.timezone": "America/Los_Angeles"
},
"metabase-info": {
"databases": [
"postgres",
"redshift"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.7"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.23"
}
},
"run-mode": "prod",
"version": {
"date": "2021-10-21",
"tag": "v1.41.1",
"branch": "release-x.41.x",
"hash": "68c0017"
},
"settings": {
"report-timezone": "US/Pacific"
}
}
}
is this what you're looking for?
@mihikaanaik So you are an Enterprise customer? Then please use the support email.
Which version did you upgrade from?
Are you seeing errors in the browser console logs, when you click the questions?
It's really difficult to understand where the problem is, but I would just recommend that you revert to your backup.