Query suddenly stopped working

Hi friends,

My metaphase query suddenly stopped working today.
I get a message that there was a problem with my question.

Under show error details it says:

ERROR: column products.products - product_id__name does not exist Position: 1490

I'm a total beginner and didn't set anything up - in the process of learning.

I know its connected Postgres but outside of that I'm lost.
Any help would be greatly appreciated.

the column in the database no longer exists or changed the name. Try searching for the column in the DB or force a sync in Metabase

1 Like

Hi @EricMK
Post "Diagnostic Info" from Admin > Troubleshooting.
And the full error is available in Admin > Troubleshooting > Logs.

1 Like

Hi flamber! thank you for the insight!
This is what I see in the logs, would be grateful for any insight on this!

{
"browser-info": {
"language": "en",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.1 Safari/605.1.15",
"vendor": "Apple Computer, Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.14.1+1",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.14.1",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.14.1+1",
"os.name": "Linux",
"os.version": "4.14.219-164.354.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"postgres",
"h2"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "11.9"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.23"
}
},
"run-mode": "prod",
"version": {
"date": "2022-02-28",
"tag": "v1.42.2",
"branch": "release-x.42.x",
"hash": "d6ff494"
},
"settings": {
"report-timezone": "US/Central"
}
}
}

@EricMK When you see the error, then go to Admin > Troubleshooting > Logs, scroll towards the bottom, which will have a very big detailed stacktrace. I need to see that.

Something makes me think that you are seeing this issue:
https://github.com/metabase/metabase/issues/20809 - upvote by clicking :+1: on the first post

1 Like

Thank you flamber! I'm very grateful for your help on this! The log is 350,000 characters which exceeds the limit to post, should I paste everything in separate posts or is there a section I should zone in on? I searched for all the sections that contained the word "error". please let me know if pasting the rest in separate posts is helpful! Super grateful for the help!

[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:20:59-06:00 WARN metabase.models.field Invalid Field :semantic_type :type/Number: falling back to null
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:20:59-06:00 DEBUG metabase.server.middleware.log GET /api/table/card__15/query_metadata 200 22.2 ms (6 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (3 idle, 0 queued) (106 total active threads) Queries in flight: 0 (0 queued)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:20:59-06:00 DEBUG metabase.server.middleware.log GET /api/collection/4 200 27.1 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (106 total active threads) Queries in flight: 0 (0 queued)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:20:59-06:00 INFO metabase.query-processor.middleware.fetch-source-query Fetched source query from Card 15:
{:source-table 6,
:joins
[{:source-table 11,
:condition [:= [:field 81 nil] [:field 91 {:join-alias "products - product_id"}]],
:alias "products - product_id",
:fields [[:field 89 {:join-alias "products - product_id"}] [:field 91 {:join-alias "products - product_id"}]]}
{:fields [[:field 63 {:join-alias "locations - location_id"}] [:field 75 {:join-alias "locations - location_id"}]],
:source-table 8,
:condition [:= [:field 86 nil] [:field 75 {:join-alias "locations - location_id"}]],
:alias "locations - location_id"}],
:filter [:= [:field 85 nil] "Active"],
:fields [[:field 83 nil] [:expression "Key"]],
:expressions {:Key [:concat [:field 81 nil] [:field 86 nil]]}}

[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:20:59-06:00 INFO metabase.query-processor.middleware.fetch-source-query Fetched source query from Card 15:
{:source-table 6,
:joins
[{:source-table 11,
:condition [:= [:field 81 nil] [:field 91 {:join-alias "products - product_id"}]],
:alias "products - product_id",
:fields [[:field 89 {:join-alias "products - product_id"}] [:field 91 {:join-alias "products - product_id"}]]}
{:fields [[:field 63 {:join-alias "locations - location_id"}] [:field 75 {:join-alias "locations - location_id"}]],
:source-table 8,
:condition [:= [:field 86 nil] [:field 75 {:join-alias "locations - location_id"}]],
:alias "locations - location_id"}],
:filter [:= [:field 85 nil] "Active"],
:fields [[:field 83 nil] [:expression "Key"]],
:expressions {:Key [:concat [:field 81 nil] [:field 86 nil]]}}

[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:20:59-06:00 WARN metabase.models.field Invalid Field :semantic_type :type/Number: falling back to null
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:20:59-06:00 WARN metabase.models.field Invalid Field :semantic_type :type/Number: falling back to null
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:20:59-06:00 WARN metabase.models.field Invalid Field :semantic_type :type/Number: falling back to null
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:20:59-06:00 WARN metabase.models.field Invalid Field :semantic_type :type/Number: falling back to null
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:20:59-06:00 WARN metabase.models.field Invalid Field :semantic_type :type/Number: falling back to null
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:21:00-06:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 2,
:started_at #t "2022-03-04T21:20:59.373736Z[GMT]",
:via
[{:status :failed,
:class clojure.lang.ExceptionInfo,
:error "Error executing query: ERROR: column products.products - product_id__name does not exist\n Position: 1490",
:stacktrace
["--> driver.sql_jdbc.execute$execute_reducible_query$fn__42755.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__86845.invokeStatic(sql_jdbc.clj:54)"
"driver.sql_jdbc$fn__86845.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__50607.invoke(mbql_to_native.clj:25)"
"query_processor.middleware.check_features$check_features$fn__51353.invoke(check_features.clj:42)"
"query_processor.middleware.limit$limit$fn__48943.invoke(limit.clj:37)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__51736.invoke(cache.clj:204)"
"query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__52800.invoke(optimize_temporal_filters.clj:204)"
"query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__52844.invoke(validate_temporal_bucketing.clj:50)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__50664.invoke(auto_parse_filter_values.clj:43)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__37386.invoke(wrap_value_literals.clj:161)"
"query_processor.middleware.annotate$add_column_info$fn__42217.invoke(annotate.clj:659)"
"query_processor.middleware.permissions$check_query_permissions$fn__47240.invoke(permissions.clj:108)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__51958.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__47636.invoke(cumulative_aggregations.clj:60)"
"metabase_enterprise.sandbox.query_processor.middleware.row_level_restrictions$apply_row_level_permissions$fn__84700.invoke(row_level_restrictions.clj:338)"
"query_processor.middleware.visualization_settings$update_viz_settings$fn__47574.invoke(visualization_settings.clj:63)"
"query_processor.middleware.escape_join_aliases$escape_join_aliases_middleware$fn__48984.invoke(escape_join_aliases.clj:64)"
"query_processor.middleware.fix_bad_references$fix_bad_references_middleware$fn__51923.invoke(fix_bad_references.clj:91)"
"query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__48521.invoke(resolve_joined_fields.clj:111)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__52570.invoke(resolve_joins.clj:178)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__52112.invoke(add_implicit_joins.clj:246)"
"query_processor.middleware.large_int_id$convert_id_to_string$fn__48540.invoke(large_int_id.clj:59)"
"query_processor.middleware.format_rows$format_rows$fn__52164.invoke(format_rows.clj:74)"
"query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__47908.invoke(add_default_temporal_unit.clj:23)"
"query_processor.middleware.desugar$desugar$fn__47547.invoke(desugar.clj:21)"
"query_processor.middleware.binning$update_binning_strategy$fn__46487.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__46882.invoke(resolve_fields.clj:34)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__51290.invoke(add_dimension_projections.clj:487)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__51584.invoke(add_implicit_clauses.clj:164)"
"metabase_enterprise.sandbox.query_processor.middleware.row_level_restrictions$apply_row_level_permissions$fn__84700.invoke(row_level_restrictions.clj:338)"
"query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__48928.invoke(upgrade_field_literals.clj:117)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__48285.invoke(add_source_metadata.clj:125)"
"metabase_enterprise.sandbox.query_processor.middleware.column_level_perms_check$maybe_apply_column_level_perms_check$fn__83099.invoke(column_level_perms_check.clj:30)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__51835.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__49922.invoke(auto_bucket_datetimes.clj:147)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__46863.invoke(resolve_source_table.clj:45)"
"query_processor.middleware.parameters$substitute_parameters$fn__49576.invoke(parameters.clj:109)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__46936.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__53228.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__49356.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__52179.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51595$fn__51600.invoke(resolve_database_and_driver.clj:35)"
"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__51595.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__47482.invoke(fetch_source_query.clj:286)"
"query_processor.middleware.store$initialize_store$fn__47673$fn__47674.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__47673.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__51930.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__51937.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__49302.invoke(add_rows_truncated.clj:35)"
"metabase_enterprise.audit_app.query_processor.middleware.handle_audit_queries$handle_internal_queries$fn__42923.invoke(handle_audit_queries.clj:130)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__50593.invoke(results_metadata.clj:82)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__49320.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__51871.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__52259.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___40953$thunk__40954.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___40953$fn__40956.invoke(reducible.clj:108)"],
:error_type :invalid-query,
:ex-data
{:sql
"-- Metabase:: userID: 3 queryType: MBQL queryHash: 9d805a6feddaeb359a1b7ed51a4fa484e6d5fb7c202843f32e3adff5a7517244\nSELECT "source"."name" AS "name", "source"."dropoffs__dropoff" AS "dropoffs__dropoff", "source"."visits - visit_id__date" AS "visits - visit_id__date", "source"."locations - location_id__name" AS "locations - location_id__name", "source"."Question 15__shed" AS "Question 15__shed" FROM (SELECT "public"."products"."name" AS "name", "public"."products"."sku" AS "sku", "public"."products"."description" AS "description", "public"."products"."bundle_size" AS "bundle_size", "public"."products"."list_price" AS "list_price", "public"."products"."created_at" AS "created_at", "public"."products"."updated_at" AS "updated_at", "public"."products"."status" AS "status", "public"."products"."id" AS "id", "public"."products"."sort_order" AS "sort_order", concat("public"."products"."id", "visits - visit_id"."location_id") AS "Key2", "dropoffs"."dropoff" AS "dropoffs__dropoff", "visits - visit_id"."date" AS "visits - visit_id__date", "locations - location_id"."name" AS "locations - location_id__name", "Question 15"."shed" AS "Question 15__shed", "visits - visit_id"."location_id" AS "visits - visit_id__location_id", "dropoffs"."product_id" AS "dropoffs__product_id", "dropoffs"."visit_id" AS "dropoffs__visit_id", "visits - visit_id"."id" AS "visits - visit_id__id", "locations - location_id"."id" AS "locations - location_id__id", "Question 15"."Key" AS "Question 15__Key", "public"."products"."products - product_id__name" AS "products - product_id__name", "public"."products"."products - product_id__id" AS "products - product_id__id" FROM "public"."products" LEFT JOIN "public"."dropoffs" "dropoffs" ON "public"."products"."id" = "dropoffs"."product_id" LEFT JOIN "public"."visits" "visits - visit_id" ON "dropoffs"."visit_id" = "visits - visit_id"."id" LEFT JOIN "public"."locations" "locations - location_id" ON "visits - visit_id"."location_id" = "locations - location_id"."id" LEFT JOIN (SELECT "source"."shed" AS "shed", "source"."Key" AS "Key", "source"."products - product_id__name" AS "products - product_id__name", "source"."products - product_id__id" AS "products - product_id__id", "source"."locations - location_id__name" AS "locations - location_id__name", "source"."locations - location_id__id" AS "locations - location_id__id" FROM (SELECT "public"."pars"."id" AS "id", "public"."pars"."product_id" AS "product_id", "public"."pars"."location_id" AS "location_id", "public"."pars"."price" AS "price", "public"."pars"."shed" AS "shed", "public"."pars"."weekly" AS "weekly", "public"."pars"."created_at" AS "created_at", "public"."pars"."updated_at" AS "updated_at", "public"."pars"."status" AS "status", concat("public"."pars"."product_id", "public"."pars"."location_id") AS "Key", "products - product_id"."name" AS "products - product_id__name", "products - product_id"."id" AS "products - product_id__id", "locations - location_id"."name" AS "locations - location_id__name", "locations - location_id"."id" AS "locations - location_id__id" FROM "public"."pars" LEFT JOIN "public"."products" "products - product_id" ON "public"."pars"."product_id" = "products - product_id"."id" LEFT JOIN "public"."locations" "locations - location_id" ON "public"."pars"."location_id" = "locations - location_id"."id") "source" WHERE "source"."status" = ?) "Question 15" ON concat("public"."products"."id", "visits - visit_id"."location_id") = "Question 15"."Key") "source" WHERE ("source"."dropoffs__dropoff" > 0 AND "source"."visits - visit_id__date" >= CAST((CAST(now() AS timestamp) + (INTERVAL '-1 day')) AS date) AND "source"."visits - visit_id__date" < CAST(now() AS date)) ORDER BY "source"."locations - location_id__name" ASC LIMIT 2000",
:params ("Active"),
:type :invalid-query}}],
:state "42703",
:error_type :invalid-query,
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :query,
:middleware {:js-int-to-string? true, :ignore-cached-results? false, :process-viz-settings? false},
:database 2,
:query
{:source-table 11,
:joins
[{:fields [[:field 60 {:join-alias "dropoffs"}]],
:source-table 9,
:condition [:= [:field 91 nil] [:field 59 {:join-alias "dropoffs"}]],
:alias "dropoffs"}
{:fields [[:field 113 {:join-alias "visits - visit_id"}]],
:source-table 13,
:condition [:= [:field 62 {:join-alias "dropoffs"}] [:field 111 {:join-alias "visits - visit_id"}]],
:alias "visits - visit_id"}
{:fields [[:field 63 {:join-alias "locations - location_id"}]],
:source-table 8,
:condition
[:= [:field 110 {:join-alias "visits - visit_id"}] [:field 75 {:join-alias "locations - location_id"}]],
:alias "locations - location_id"}
{:fields [[:field 83 {:join-alias "Question 15"}]],
:source-table "card__15",
:condition [:= [:expression "Key2"] [:field "Key" {:base-type :type/Text, :join-alias "Question 15"}]],
:alias "Question 15",
:strategy :left-join}],
:filter
[:and
[:> [:field 60 {:join-alias "dropoffs"}] 0]
[:time-interval [:field 113 {:join-alias "visits - visit_id"}] -1 :day]],
:expressions {:Key2 [:concat [:field 91 nil] [:field 110 {:join-alias "visits - visit_id"}]]},
:order-by [[:asc [:field 63 {:join-alias "locations - location_id"}]]],
:fields [[:field 89 nil]]},
:parameters [],
:async? true,
:cache-ttl nil},
:native
{:query
"SELECT "source"."name" AS "name", "source"."dropoffs__dropoff" AS "dropoffs__dropoff", "source"."visits - visit_id__date" AS "visits - visit_id__date", "source"."locations - location_id__name" AS "locations - location_id__name", "source"."Question 15__shed" AS "Question 15__shed" FROM (SELECT "public"."products"."name" AS "name", "public"."products"."sku" AS "sku", "public"."products"."description" AS "description", "public"."products"."bundle_size" AS "bundle_size", "public"."products"."list_price" AS "list_price", "public"."products"."created_at" AS "created_at", "public"."products"."updated_at" AS "updated_at", "public"."products"."status" AS "status", "public"."products"."id" AS "id", "public"."products"."sort_order" AS "sort_order", concat("public"."products"."id", "visits - visit_id"."location_id") AS "Key2", "dropoffs"."dropoff" AS "dropoffs__dropoff", "visits - visit_id"."date" AS "visits - visit_id__date", "locations - location_id"."name" AS "locations - location_id__name", "Question 15"."shed" AS "Question 15__shed", "visits - visit_id"."location_id" AS "visits - visit_id__location_id", "dropoffs"."product_id" AS "dropoffs__product_id", "dropoffs"."visit_id" AS "dropoffs__visit_id", "visits - visit_id"."id" AS "visits - visit_id__id", "locations - location_id"."id" AS "locations - location_id__id", "Question 15"."Key" AS "Question 15__Key", "public"."products"."products - product_id__name" AS "products - product_id__name", "public"."products"."products - product_id__id" AS "products - product_id__id" FROM "public"."products" LEFT JOIN "public"."dropoffs" "dropoffs" ON "public"."products"."id" = "dropoffs"."product_id" LEFT JOIN "public"."visits" "visits - visit_id" ON "dropoffs"."visit_id" = "visits - visit_id"."id" LEFT JOIN "public"."locations" "locations - location_id" ON "visits - visit_id"."location_id" = "locations - location_id"."id" LEFT JOIN (SELECT "source"."shed" AS "shed", "source"."Key" AS "Key", "source"."products - product_id__name" AS "products - product_id__name", "source"."products - product_id__id" AS "products - product_id__id", "source"."locations - location_id__name" AS "locations - location_id__name", "source"."locations - location_id__id" AS "locations - location_id__id" FROM (SELECT "public"."pars"."id" AS "id", "public"."pars"."product_id" AS "product_id", "public"."pars"."location_id" AS "location_id", "public"."pars"."price" AS "price", "public"."pars"."shed" AS "shed", "public"."pars"."weekly" AS "weekly", "public"."pars"."created_at" AS "created_at", "public"."pars"."updated_at" AS "updated_at", "public"."pars"."status" AS "status", concat("public"."pars"."product_id", "public"."pars"."location_id") AS "Key", "products - product_id"."name" AS "products - product_id__name", "products - product_id"."id" AS "products - product_id__id", "locations - location_id"."name" AS "locations - location_id__name", "locations - location_id"."id" AS "locations - location_id__id" FROM "public"."pars" LEFT JOIN "public"."products" "products - product_id" ON "public"."pars"."product_id" = "products - product_id"."id" LEFT JOIN "public"."locations" "locations - location_id" ON "public"."pars"."location_id" = "locations - location_id"."id") "source" WHERE "source"."status" = ?) "Question 15" ON concat("public"."products"."id", "visits - visit_id"."location_id") = "Question 15"."Key") "source" WHERE ("source"."dropoffs__dropoff" > 0 AND "source"."visits - visit_id__date" >= CAST((CAST(now() AS timestamp) + (INTERVAL '-1 day')) AS date) AND "source"."visits - visit_id__date" < CAST(now() AS date)) ORDER BY "source"."locations - location_id__name" ASC LIMIT 2000",
:params ("Active")},
: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:1471)"
"--> driver.sql_jdbc.execute$fn__42673.invokeStatic(execute.clj:364)"
"driver.sql_jdbc.execute$fn__42673.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__42755.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__86845.invokeStatic(sql_jdbc.clj:54)"
"driver.sql_jdbc$fn__86845.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__50607.invoke(mbql_to_native.clj:25)"
"query_processor.middleware.check_features$check_features$fn__51353.invoke(check_features.clj:42)"
"query_processor.middleware.limit$limit$fn__48943.invoke(limit.clj:37)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__51736.invoke(cache.clj:204)"
"query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__52800.invoke(optimize_temporal_filters.clj:204)"
"query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__52844.invoke(validate_temporal_bucketing.clj:50)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__50664.invoke(auto_parse_filter_values.clj:43)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__37386.invoke(wrap_value_literals.clj:161)"
"query_processor.middleware.annotate$add_column_info$fn__42217.invoke(annotate.clj:659)"
"query_processor.middleware.permissions$check_query_permissions$fn__47240.invoke(permissions.clj:108)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__51958.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__47636.invoke(cumulative_aggregations.clj:60)"
"metabase_enterprise.sandbox.query_processor.middleware.row_level_restrictions$apply_row_level_permissions$fn__84700.invoke(row_level_restrictions.clj:338)"
"query_processor.middleware.visualization_settings$update_viz_settings$fn__47574.invoke(visualization_settings.clj:63)"
"query_processor.middleware.escape_join_aliases$escape_join_aliases_middleware$fn__48984.invoke(escape_join_aliases.clj:64)"
"query_processor.middleware.fix_bad_references$fix_bad_references_middleware$fn__51923.invoke(fix_bad_references.clj:91)"
"query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__48521.invoke(resolve_joined_fields.clj:111)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__52570.invoke(resolve_joins.clj:178)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__52112.invoke(add_implicit_joins.clj:246)"
"query_processor.middleware.large_int_id$convert_id_to_string$fn__48540.invoke(large_int_id.clj:59)"
"query_processor.middleware.format_rows$format_rows$fn__52164.invoke(format_rows.clj:74)"
"query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__47908.invoke(add_default_temporal_unit.clj:23)"
"query_processor.middleware.desugar$desugar$fn__47547.invoke(desugar.clj:21)"
"query_processor.middleware.binning$update_binning_strategy$fn__46487.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__46882.invoke(resolve_fields.clj:34)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__51290.invoke(add_dimension_projections.clj:487)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__51584.invoke(add_implicit_clauses.clj:164)"
"metabase_enterprise.sandbox.query_processor.middleware.row_level_restrictions$apply_row_level_permissions$fn__84700.invoke(row_level_restrictions.clj:338)"
"query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__48928.invoke(upgrade_field_literals.clj:117)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__48285.invoke(add_source_metadata.clj:125)"
"metabase_enterprise.sandbox.query_processor.middleware.column_level_perms_check$maybe_apply_column_level_perms_check$fn__83099.invoke(column_level_perms_check.clj:30)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__51835.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__49922.invoke(auto_bucket_datetimes.clj:147)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__46863.invoke(resolve_source_table.clj:45)"
"query_processor.middleware.parameters$substitute_parameters$fn__49576.invoke(parameters.clj:109)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__46936.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__53228.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__49356.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__52179.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51595$fn__51600.invoke(resolve_database_and_driver.clj:35)"
"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__51595.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__47482.invoke(fetch_source_query.clj:286)"
"query_processor.middleware.store$initialize_store$fn__47673$fn__47674.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__47673.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__51930.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__51937.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__49302.invoke(add_rows_truncated.clj:35)"
"metabase_enterprise.audit_app.query_processor.middleware.handle_audit_queries$handle_internal_queries$fn__42923.invoke(handle_audit_queries.clj:130)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__50593.invoke(results_metadata.clj:82)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__49320.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__51871.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__52259.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___40953$thunk__40954.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___40953$fn__40956.invoke(reducible.clj:108)"],
:card_id 19,
:context :question,
:error "ERROR: column products.products - product_id__name does not exist\n Position: 1490",
: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, :process-viz-settings? false},
:info
{:executed-by 3,
:context :question,
:card-id 19,
:card-name "Yesterday's dropoffs",
:query-hash
[-99, -128, 90, 111, -19, -38, -21, 53, -102, 27, 126, -43, 26, 79, -92, -124, -26, -43, -5, 124, 32, 40, 67, -13,
46, 58, -33, -11, -89, 81, 114, 68]},
:database 2,
:query
{:source-table 11,
:filter
[:and
[:>
[:field 60 {:join-alias "dropoffs"}]
[:value
0

  {:base_type :type/Integer,
   :effective_type :type/Integer,
   :coercion_strategy nil,
   :semantic_type :type/Quantity,
   :database_type "int4",
   :name "dropoff"}]]
[:>= [:field 113 {:join-alias "visits - visit_id", :temporal-unit :default}] [:relative-datetime -1 :day]]
[:< [:field 113 {:join-alias "visits - visit_id", :temporal-unit :default}] [:relative-datetime 0 :day]]],

:expressions {:Key2 [:concat [:field 91 nil] [:field 110 {:join-alias "visits - visit_id"}]]},
:order-by [[:asc [:field 63 {:join-alias "locations - location_id"}]]],
:fields
[[:field 89 nil]
[:field 60 {:join-alias "dropoffs"}]
[:field 113 {:join-alias "visits - visit_id", :temporal-unit :default}]
[:field 63 {:join-alias "locations - location_id"}]
[:field 83 {:join-alias "Question 15"}]],
:joins
[{:alias "dropoffs",
:strategy :left-join,
:fields [[:field 60 {:join-alias "dropoffs"}]],
:source-table 9,
:condition [:= [:field 91 nil] [:field 59 {:join-alias "dropoffs"}]]}
{:alias "visits - visit_id",
:strategy :left-join,
:fields [[:field 113 {:join-alias "visits - visit_id", :temporal-unit :default}]],
:source-table 13,
:condition [:= [:field 62 {:join-alias "dropoffs"}] [:field 111 {:join-alias "visits - visit_id"}]]}
{:alias "locations - location_id",
:strategy :left-join,
:fields [[:field 63 {:join-alias "locations - location_id"}]],
:source-table 8,
:condition
[:= [:field 110 {:join-alias "visits - visit_id"}] [:field 75 {:join-alias "locations - location_id"}]]}
{:alias "Question 15",
:strategy :left-join,
:fields [[:field 83 {:join-alias "Question 15"}]],
:condition [:= [:expression "Key2"] [:field "Key" {:base-type :type/Text, :join-alias "Question 15"}]],
:source-card-id 15,
:source-query
{:source-table 6,
:filter
[:=
[:field 85 nil]
[:value
"Active"
{:base_type :type/Text,
:effective_type :type/Text,
:coercion_strategy nil,
:semantic_type :type/Enum,
:database_type "text",
:name "status"}]],
:fields
[[:field 83 nil]
[:expression "Key"]
[:field 89 {:join-alias "products - product_id"}]
[:field 91 {:join-alias "products - product_id"}]
[:field 63 {:join-alias "locations - location_id"}]
[:field 75 {:join-alias "locations - location_id"}]],
:expressions {:Key [:concat [:field 81 nil] [:field 86 nil]]},
:joins
[{:alias "products - product_id",
:strategy :left-join,
:source-table 11,
:condition [:= [:field 81 nil] [:field 91 {:join-alias "products - product_id"}]],
:fields [[:field 89 {:join-alias "products - product_id"}] [:field 91 {:join-alias "products - product_id"}]]}
{:alias "locations - location_id",
:strategy :left-join,
:fields
[[:field 63 {:join-alias "locations - location_id"}] [:field 75 {:join-alias "locations - location_id"}]],
:source-table 8,
:condition [:= [:field 86 nil] [:field 75 {:join-alias "locations - location_id"}]]}]},
:source-metadata
[{:semantic_type nil,
:coercion_strategy nil,
:name "shed",
:field_ref [:field 83 nil],
:effective_type :type/Integer,
:id 83,
:display_name "Shed",
:fingerprint
{:global {:distinct-count 40, :nil% 0.009433962264150943},
:type
{:type/Number
{:min 0.0,
:q1 5.732050807568877,
:q3 175.7284274447472,
:max 2000.0,
:sd 260.04066387234116,
:avg 144.43809523809523}}},
:base_type :type/Integer}
{:name "Key",
:display_name "Key",
:base_type :type/Text,
:semantic_type nil,
:field_ref [:expression "Key"],
:fingerprint
{:global {:distinct-count 293, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 34.0}}}}
{:semantic_type :type/Name,
:coercion_strategy nil,
:name "name",
:field_ref [:field 89 {:join-alias "products - product_id"}],
:effective_type :type/Text,
:id 89,
:display_name "products - product_id โ†’ Name",
:fingerprint
{:global {:distinct-count 39, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0,
:percent-url 0.0,
:percent-email 0.0,
:percent-state 0.0,
:average-length 12.512820512820513}}},
:base_type :type/Text}
{:semantic_type :type/PK,
:coercion_strategy nil,
:name "id",
:field_ref [:field 91 {:join-alias "products - product_id"}],
:effective_type :type/Text,
:id 91,
:display_name "products - product_id โ†’ ID",
:fingerprint nil,
:base_type :type/Text}
{:semantic_type :type/Name,
:coercion_strategy nil,
:name "name_2",
:field_ref [:field 63 {:join-alias "locations - location_id"}],
:effective_type :type/Text,
:id 63,
:display_name "locations - location_id โ†’ Name",
:fingerprint
{:global {:distinct-count 37, :nil% 0.0},
:type
{:type/Text
{:percent-json 0.0,
:percent-url 0.0,
:percent-email 0.0,
:percent-state 0.0,
:average-length 24.216216216216218}}},
:base_type :type/Text}
{:semantic_type :type/PK,
:coercion_strategy nil,
:name "id_2",
:field_ref [:field 75 {:join-alias "locations - location_id"}],
:effective_type :type/Text,
:id 75,
:display_name "locations - location_id โ†’ ID",
:fingerprint nil,
:base_type :type/Text}]}],
:limit 2000},
:async? true},
:data {:rows [], :cols []}}

[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:21:00-06:00 DEBUG metabase.server.middleware.log POST /api/card/19/query 202 [ASYNC: completed] 1.5 s (22 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (5 idle, 0 queued) (106 total active threads) Queries in flight: 0 (0 queued); postgres DB 2 connections: 0/2 (0 threads blocked)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:00-06:00 INFO metabase.task.sync-databases Starting sync task for Database 1.
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:00-06:00 INFO metabase.sync.util STARTING: Sync metadata for h2 Database 1 'Sample Database'
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:00-06:00 INFO metabase.sync.util STARTING: step 'sync-timezone' for h2 Database 1 'Sample Database'
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:00-06:00 INFO metabase.sync.util FINISHED: step 'sync-timezone' for h2 Database 1 'Sample Database' (6.5 ms)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:00-06:00 INFO metabase.sync.util STARTING: step 'sync-tables' for h2 Database 1 'Sample Database'
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:00-06:00 INFO metabase.sync.sync-metadata.tables Updating description for tables: (Table 'PUBLIC.PEOPLE' Table 'PUBLIC.REVIEWS' Table 'PUBLIC.ORDERS' Table 'PUBLIC.PRODUCTS')
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:00-06:00 INFO metabase.sync.util FINISHED: step 'sync-tables' for h2 Database 1 'Sample Database' (37.1 ms)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:00-06:00 INFO metabase.sync.util STARTING: step 'sync-fields' for h2 Database 1 'Sample Database'
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:00-06:00 INFO metabase.sync.util FINISHED: step 'sync-fields' for h2 Database 1 'Sample Database' (476.5 ms)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:00-06:00 INFO metabase.sync.util STARTING: step 'sync-fks' for h2 Database 1 'Sample Database'
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:00-06:00 INFO metabase.sync.util FINISHED: step 'sync-fks' for h2 Database 1 'Sample Database' (27.4 ms)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:00-06:00 INFO metabase.sync.util STARTING: step 'sync-metabase-metadata' for h2 Database 1 'Sample Database'
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:01-06:00 INFO metabase.sync.util FINISHED: step 'sync-metabase-metadata' for h2 Database 1 'Sample Database' (454.1 ms)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:01-06:00 INFO metabase.sync.util FINISHED: Sync metadata for h2 Database 1 'Sample Database' (1.0 s)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:01-06:00 INFO metabase.sync.util STARTING: Analyze data for h2 Database 1 'Sample Database'
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:01-06:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for h2 Database 1 'Sample Database'
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:01-06:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [ยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยท] :disappointed: 15% Table 4 'PUBLIC.REVIEWS'
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:01-06:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [
ยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยท] :confused: 31% Table 1 'PUBLIC.PRODUCTS'
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:01-06:00 INFO metabase.sync.util FINISHED: step 'fingerprint-fields' for h2 Database 1 'Sample Database' (13.7 ms)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:01-06:00 INFO metabase.sync.util STARTING: step 'classify-fields' for h2 Database 1 'Sample Database'
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:01-06:00 INFO metabase.sync.analyze classify-fields Analyzed [
ยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยท] :grimacing: 46% Table 4 'PUBLIC.REVIEWS'
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:01-06:00 INFO metabase.sync.analyze classify-fields Analyzed [
ยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยท] :relieved: 62% Table 1 'PUBLIC.PRODUCTS'
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:01-06:00 INFO metabase.sync.util FINISHED: step 'classify-fields' for h2 Database 1 'Sample Database' (5.7 ms)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:01-06:00 INFO metabase.sync.util STARTING: step 'classify-tables' for h2 Database 1 'Sample Database'
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:01-06:00 INFO metabase.sync.analyze classify-tables Analyzed [
***********************ยทยทยทยทยทยทยทยทยทยทยทยท] :yum: 77% Table 4 'PUBLIC.REVIEWS'
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:01-06:00 INFO metabase.sync.analyze classify-tables Analyzed [**********************************************ยทยทยทยท] :heart_eyes: 92% Table 1 'PUBLIC.PRODUCTS'
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:01-06:00 INFO metabase.sync.util FINISHED: step 'classify-tables' for h2 Database 1 'Sample Database' (5.6 ms)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:34:01-06:00 INFO metabase.sync.util FINISHED: Analyze data for h2 Database 1 'Sample Database' (53.9 ms)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:57:27-06:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 7.7 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (3 idle, 0 queued) (101 total active threads) Queries in flight: 0 (0 queued)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:57:27-06:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 22.6 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (101 total active threads) Queries in flight: 0 (0 queued)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:57:27-06:00 DEBUG metabase.server.middleware.log GET /api/database 200 6.8 ms (3 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (3 idle, 0 queued) (101 total active threads) Queries in flight: 0 (0 queued)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:57:27-06:00 DEBUG metabase.server.middleware.log GET /api/card/20 200 26.7 ms (10 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (3 idle, 0 queued) (101 total active threads) Queries in flight: 0 (0 queued)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:57:27-06:00 DEBUG metabase.server.middleware.log GET /api/alert/question/20 200 4.3 ms (1 DB calls) App DB connections: 5/15 Jetty threads: 8/50 (0 idle, 0 queued) (104 total active threads) Queries in flight: 0 (0 queued)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:57:27-06:00 WARN metabase.models.field Invalid Field :semantic_type :type/Number: falling back to null
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:57:27-06:00 WARN metabase.models.field Invalid Field :semantic_type :type/Number: falling back to null
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:57:27-06:00 DEBUG metabase.server.middleware.log GET /api/table/13/query_metadata 200 112.6 ms (11 DB calls) App DB connections: 0/15 Jetty threads: 7/50 (1 idle, 0 queued) (104 total active threads) Queries in flight: 0 (0 queued)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:57:27-06:00 DEBUG metabase.server.middleware.log GET /api/table/9/query_metadata 200 122.4 ms (10 DB calls) App DB connections: 3/15 Jetty threads: 7/50 (1 idle, 0 queued) (104 total active threads) Queries in flight: 0 (0 queued)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:57:27-06:00 DEBUG metabase.server.middleware.log GET /api/table/8/query_metadata 200 122.0 ms (8 DB calls) App DB connections: 2/15 Jetty threads: 6/50 (2 idle, 0 queued) (104 total active threads) Queries in flight: 0 (0 queued)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:57:27-06:00 DEBUG metabase.server.middleware.log GET /api/table/card__15/query_metadata 200 148.3 ms (6 DB calls) App DB connections: 1/15 Jetty threads: 6/50 (2 idle, 0 queued) (104 total active threads) Queries in flight: 0 (0 queued)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:57:27-06:00 DEBUG metabase.server.middleware.log GET /api/table/11/query_metadata 200 169.9 ms (8 DB calls) App DB connections: 0/15 Jetty threads: 6/50 (2 idle, 0 queued) (105 total active threads) Queries in flight: 0 (0 queued)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:57:27-06:00 DEBUG metabase.server.middleware.log GET /api/collection/4 200 6.1 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (5 idle, 0 queued) (105 total active threads) Queries in flight: 0 (0 queued)
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:57:28-06:00 INFO metabase.query-processor.middleware.fetch-source-query Fetched source query from Card 15:
{:source-table 6,
:joins
[{:source-table 11,
:condition [:= [:field 81 nil] [:field 91 {:join-alias "products - product_id"}]],
:alias "products - product_id",
:fields [[:field 89 {:join-alias "products - product_id"}] [:field 91 {:join-alias "products - product_id"}]]}
{:fields [[:field 63 {:join-alias "locations - location_id"}] [:field 75 {:join-alias "locations - location_id"}]],
:source-table 8,
:condition [:= [:field 86 nil] [:field 75 {:join-alias "locations - location_id"}]],
:alias "locations - location_id"}],
:filter [:= [:field 85 nil] "Active"],
:fields [[:field 83 nil] [:expression "Key"]],
:expressions {:Key [:concat [:field 81 nil] [:field 86 nil]]}}

[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:57:28-06:00 INFO metabase.query-processor.middleware.fetch-source-query Fetched source query from Card 15:
{:source-table 6,
:joins
[{:source-table 11,
:condition [:= [:field 81 nil] [:field 91 {:join-alias "products - product_id"}]],
:alias "products - product_id",
:fields [[:field 89 {:join-alias "products - product_id"}] [:field 91 {:join-alias "products - product_id"}]]}
{:fields [[:field 63 {:join-alias "locations - location_id"}] [:field 75 {:join-alias "locations - location_id"}]],
:source-table 8,
:condition [:= [:field 86 nil] [:field 75 {:join-alias "locations - location_id"}]],
:alias "locations - location_id"}],
:filter [:= [:field 85 nil] "Active"],
:fields [[:field 83 nil] [:expression "Key"]],
:expressions {:Key [:concat [:field 81 nil] [:field 86 nil]]}}

[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:57:28-06:00 WARN metabase.models.field Invalid Field :semantic_type :type/Number: falling back to null
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:57:28-06:00 WARN metabase.models.field Invalid Field :semantic_type :type/Number: falling back to null
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:57:28-06:00 WARN metabase.models.field Invalid Field :semantic_type :type/Number: falling back to null
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:57:28-06:00 WARN metabase.models.field Invalid Field :semantic_type :type/Number: falling back to null
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:57:28-06:00 WARN metabase.models.field Invalid Field :semantic_type :type/Number: falling back to null
[4452bd84-4070-426e-8e0d-16c8be7e48e6] 2022-03-04T15:57:29-06:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 2,
:started_at #t "2022-03-04T21:57:28.081590Z[GMT]",
:via
[{:status :failed,
:class clojure.lang.ExceptionInfo,
:error "Error executing query: ERROR: column products.products - product_id__name does not exist\n Position: 1490",
:stacktrace
["--> driver.sql_jdbc.execute$execute_reducible_query$fn__42755.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__86845.invokeStatic(sql_jdbc.clj:54)"
"driver.sql_jdbc$fn__86845.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__50607.invoke(mbql_to_native.clj:25)"
"query_processor.middleware.check_features$check_features$fn__51353.invoke(check_features.clj:42)"
"query_processor.middleware.limit$limit$fn__48943.invoke(limit.clj:37)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__51736.invoke(cache.clj:204)"
"query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__52800.invoke(optimize_temporal_filters.clj:204)"
"query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__52844.invoke(validate_temporal_bucketing.clj:50)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__50664.invoke(auto_parse_filter_values.clj:43)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__37386.invoke(wrap_value_literals.clj:161)"
"query_processor.middleware.annotate$add_column_info$fn__42217.invoke(annotate.clj:659)"
"query_processor.middleware.permissions$check_query_permissions$fn__47240.invoke(permissions.clj:108)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__51958.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__47636.invoke(cumulative_aggregations.clj:60)"
"metabase_enterprise.sandbox.query_processor.middleware.row_level_restrictions$apply_row_level_permissions$fn__84700.invoke(row_level_restrictions.clj:338)"
"query_processor.middleware.visualization_settings$update_viz_settings$fn__47574.invoke(visualization_settings.clj:63)"
"query_processor.middleware.escape_join_aliases$escape_join_aliases_middleware$fn__48984.invoke(escape_join_aliases.clj:64)"
"query_processor.middleware.fix_bad_references$fix_bad_references_middleware$fn__51923.invoke(fix_bad_references.clj:91)"
"query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__48521.invoke(resolve_joined_fields.clj:111)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__52570.invoke(resolve_joins.clj:178)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__52112.invoke(add_implicit_joins.clj:246)"
"query_processor.middleware.large_int_id$convert_id_to_string$fn__48540.invoke(large_int_id.clj:59)"
"query_processor.middleware.format_rows$format_rows$fn__52164.invoke(format_rows.clj:74)"
"query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__47908.invoke(add_default_temporal_unit.clj:23)"
"query_processor.middleware.desugar$desugar$fn__47547.invoke(desugar.clj:21)"
"query_processor.middleware.binning$update_binning_strategy$fn__46487.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__46882.invoke(resolve_fields.clj:34)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__51290.invoke(add_dimension_projections.clj:487)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__51584.invoke(add_implicit_clauses.clj:164)"
"metabase_enterprise.sandbox.query_processor.middleware.row_level_restrictions$apply_row_level_permissions$fn__84700.invoke(row_level_restrictions.clj:338)"
"query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__48928.invoke(upgrade_field_literals.clj:117)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__48285.invoke(add_source_metadata.clj:125)"
"metabase_enterprise.sandbox.query_processor.middleware.column_level_perms_check$maybe_apply_column_level_perms_check$fn__83099.invoke(column_level_perms_check.clj:30)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__51835.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__49922.invoke(auto_bucket_datetimes.clj:147)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__46863.invoke(resolve_source_table.clj:45)"
"query_processor.middleware.parameters$substitute_parameters$fn__49576.invoke(parameters.clj:109)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__46936.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__53228.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__49356.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__52179.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51595$fn__51600.invoke(resolve_database_and_driver.clj:35)"
"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__51595.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__47482.invoke(fetch_source_query.clj:286)"
"query_processor.middleware.store$initialize_store$fn__47673$fn__47674.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__47673.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__51930.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__51937.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__49302.invoke(add_rows_truncated.clj:35)"
"metabase_enterprise.audit_app.query_processor.middleware.handle_audit_queries$handle_internal_queries$fn__42923.invoke(handle_audit_queries.clj:130)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__50593.invoke(results_metadata.clj:82)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__49320.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__51871.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__52259.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___40953$thunk__40954.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___40953$fn__40956.invoke(reducible.clj:108)"],
:error_type :invalid-query,
:ex-data
{:sql
"-- Metabase:: userID: 3 queryType: MBQL queryHash: 658fc9ba5027cc6eee1b0216edc8b496a4908f52d57845f5b4426d14ebe05448\nSELECT "source"."name" AS "name", "source"."dropoffs__dropoff" AS "dropoffs__dropoff", "source"."visits - visit_id__date" AS "visits - visit_id__date", "source"."locations - location_id__name" AS "locations - location_id__name", "source"."Question 15__shed" AS "Question 15__shed" FROM (SELECT "public"."products"."name" AS "name", "public"."products"."sku" AS "sku", "public"."products"."description" AS "description", "public"."products"."bundle_size" AS "bundle_size", "public"."products"."list_price" AS "list_price", "public"."products"."created_at" AS "created_at", "public"."products"."updated_at" AS "updated_at", "public"."products"."status" AS "status", "public"."products"."id" AS "id", "public"."products"."sort_order" AS "sort_order", concat("public"."products"."id", "visits - visit_id"."location_id") AS "Key2", "dropoffs"."dropoff" AS "dropoffs__dropoff", "visits - visit_id"."date" AS "visits - visit_id__date", "locations - location_id"."name" AS "locations - location_id__name", "Question 15"."shed" AS "Question 15__shed", "visits - visit_id"."location_id" AS "visits - visit_id__location_id", "dropoffs"."product_id" AS "dropoffs__product_id", "dropoffs"."visit_id" AS "dropoffs__visit_id", "visits - visit_id"."id" AS "visits - visit_id__id", "locations - location_id"."id" AS "locations - location_id__id", "Question 15"."Key" AS "Question 15__Key", "public"."products"."products - product_id__name" AS "products - product_id__name", "public"."products"."products - product_id__id" AS "products - product_id__id" FROM "public"."products" LEFT JOIN "public"."dropoffs" "dropoffs" ON "public"."products"."id" = "dropoffs"."product_id" LEFT JOIN "public"."visits" "visits - visit_id" ON "dropoffs"."visit_id" = "visits - visit_id"."id" LEFT JOIN "public"."locations" "locations - location_id" ON "visits - visit_id"."location_id" = "locations - location_id"."id" LEFT JOIN (SELECT "source"."shed" AS "shed", "source"."Key" AS "Key", "source"."products - product_id__name" AS "products - product_id__name", "source"."products - product_id__id" AS "products - product_id__id", "source"."locations - location_id__name" AS "locations - location_id__name", "source"."locations - location_id__id" AS "locations - location_id__id" FROM (SELECT "public"."pars"."id" AS "id", "public"."pars"."product_id" AS "product_id", "public"."pars"."location_id" AS "location_id", "public"."pars"."price" AS "price", "public"."pars"."shed" AS "shed", "public"."pars"."weekly" AS "weekly", "public"."pars"."created_at" AS "created_at", "public"."pars"."updated_at" AS "updated_at", "public"."pars"."status" AS "status", concat("public"."pars"."product_id", "public"."pars"."location_id") AS "Key", "products - product_id"."name" AS "products - product_id__name", "products - product_id"."id" AS "products - product_id__id", "locations - location_id"."name" AS "locations - location_id__name", "locations - location_id"."id" AS "locations - location_id__id" FROM "public"."pars" LEFT JOIN "public"."products" "products - product_id" ON "public"."pars"."product_id" = "products - product_id"."id" LEFT JOIN "public"."locations" "locations - location_id" ON "public"."pars"."location_id" = "locations - location_id"."id") "source" WHERE "source"."status" = ?) "Question 15" ON concat("public"."products"."id", "visits - visit_id"."location_id") = "Question 15"."Key") "source" WHERE ("source"."dropoffs__dropoff" > 0 AND "source"."visits - visit_id__date" >= CAST(now() AS date) AND "source"."visits - visit_id__date" < CAST((CAST(now() AS timestamp) + (INTERVAL '1 day')) AS date)) ORDER BY "source"."locations - location_id__name" ASC LIMIT 2000",
:params ("Active"),
:type :invalid-query}}],
:state "42703",
:error_type :invalid-query,
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :query,
:middleware {:js-int-to-string? true, :ignore-cached-results? false, :process-viz-settings? false},
:database 2,
:query
{:source-table 11,
:joins
[{:fields [[:field 60 {:join-alias "dropoffs"}]],
:source-table 9,
:condition [:= [:field 91 nil] [:field 59 {:join-alias "dropoffs"}]],
:alias "dropoffs"}
{:fields [[:field 113 {:join-alias "visits - visit_id"}]],
:source-table 13,
:condition [:= [:field 62 {:join-alias "dropoffs"}] [:field 111 {:join-alias "visits - visit_id"}]],
:alias "visits - visit_id"}
{:fields [[:field 63 {:join-alias "locations - location_id"}]],
:source-table 8,
:condition
[:= [:field 110 {:join-alias "visits - visit_id"}] [:field 75 {:join-alias "locations - location_id"}]],
:alias "locations - location_id"}
{:fields [[:field 83 {:join-alias "Question 15"}]],
:source-table "card__15",
:condition [:= [:expression "Key2"] [:field "Key" {:base-type :type/Text, :join-alias "Question 15"}]],
:alias "Question 15",
:strategy :left-join}],
:filter
[:and
[:> [:field 60 {:join-alias "dropoffs"}] 0]
[:time-interval [:field 113 {:join-alias "visits - visit_id"}] :current :day]],
:expressions {:Key2 [:concat [:field 91 nil] [:field 110 {:join-alias "visits - visit_id"}]]},
:order-by [[:asc [:field 63 {:join-alias "locations - location_id"}]]],
:fields [[:field 89 nil]]},
:parameters [],
:async? true,
:cache-ttl nil},
:native
{:query
"SELECT "source"."name" AS "name", "source"."dropoffs__dropoff" AS "dropoffs__dropoff", "source"."visits - visit_id__date" AS "visits - visit_id__date", "source"."locations - location_id__name" AS "locations - location_id__name", "source"."Question 15__shed" AS "Question 15__shed" FROM (SELECT "public"."products"."name" AS "name", "public"."products"."sku" AS "sku", "public"."products"."description" AS "description", "public"."products"."bundle_size" AS "bundle_size", "public"."products"."list_price" AS "list_price", "public"."products"."created_at" AS "created_at", "public"."products"."updated_at" AS "updated_at", "public"."products"."status" AS "status", "public"."products"."id" AS "id", "public"."products"."sort_order" AS "sort_order", concat("public"."products"."id", "visits - visit_id"."location_id") AS "Key2", "dropoffs"."dropoff" AS "dropoffs__dropoff", "visits - visit_id"."date" AS "visits - visit_id__date", "locations - location_id"."name" AS "locations - location_id__name", "Question 15"."shed" AS "Question 15__shed", "visits - visit_id"."location_id" AS "visits - visit_id__location_id", "dropoffs"."product_id" AS "dropoffs__product_id", "dropoffs"."visit_id" AS "dropoffs__visit_id", "visits - visit_id"."id" AS "visits - visit_id__id", "locations - location_id"."id" AS "locations - location_id__id", "Question 15"."Key" AS "Question 15__Key", "public"."products"."products - product_id__name" AS "products - product_id__name", "public"."products"."products - product_id__id" AS "products - product_id__id" FROM "public"."products" LEFT JOIN "public"."dropoffs" "dropoffs" ON "public"."products"."id" = "dropoffs"."product_id" LEFT JOIN "public"."visits" "visits - visit_id" ON "dropoffs"."visit_id" = "visits - visit_id"."id" LEFT JOIN "public"."locations" "locations - location_id" ON "visits - visit_id"."location_id" = "locations - location_id"."id" LEFT JOIN (SELECT "source"."shed" AS "shed", "source"."Key" AS "Key", "source"."products - product_id__name" AS "products - product_id__name", "source"."products - product_id__id" AS "products - product_id__id", "source"."locations - location_id__name" AS "locations - location_id__name", "source"."locations - location_id__id" AS "locations - location_id__id" FROM (SELECT "public"."pars"."id" AS "id", "public"."pars"."product_id" AS "product_id", "public"."pars"."location_id" AS "location_id", "public"."pars"."price" AS "price", "public"."pars"."shed" AS "shed", "public"."pars"."weekly" AS "weekly", "public"."pars"."created_at" AS "created_at", "public"."pars"."updated_at" AS "updated_at", "public"."pars"."status" AS "status", concat("public"."pars"."product_id", "public"."pars"."location_id") AS "Key", "products - product_id"."name" AS "products - product_id__name", "products - product_id"."id" AS "products - product_id__id", "locations - location_id"."name" AS "locations - location_id__name", "locations - location_id"."id" AS "locations - location_id__id" FROM "public"."pars" LEFT JOIN "public"."products" "products - product_id" ON "public"."pars"."product_id" = "products - product_id"."id" LEFT JOIN "public"."locations" "locations - location_id" ON "public"."pars"."location_id" = "locations - location_id"."id") "source" WHERE "source"."status" = ?) "Question 15" ON concat("public"."products"."id", "visits - visit_id"."location_id") = "Question 15"."Key") "source" WHERE ("source"."dropoffs__dropoff" > 0 AND "source"."visits - visit_id__date" >= CAST(now() AS date) AND "source"."visits - visit_id__date" < CAST((CAST(now() AS timestamp) + (INTERVAL '1 day')) AS date)) ORDER BY "source"."locations - location_id__name" ASC LIMIT 2000",
:params ("Active")},
: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:1471)"
"--> driver.sql_jdbc.execute$fn__42673.invokeStatic(execute.clj:364)"
"driver.sql_jdbc.execute$fn__42673.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__42755.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__86845.invokeStatic(sql_jdbc.clj:54)"
"driver.sql_jdbc$fn__86845.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__50607.invoke(mbql_to_native.clj:25)"
"query_processor.middleware.check_features$check_features$fn__51353.invoke(check_features.clj:42)"
"query_processor.middleware.limit$limit$fn__48943.invoke(limit.clj:37)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__51736.invoke(cache.clj:204)"
"query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__52800.invoke(optimize_temporal_filters.clj:204)"
"query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__52844.invoke(validate_temporal_bucketing.clj:50)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__50664.invoke(auto_parse_filter_values.clj:43)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__37386.invoke(wrap_value_literals.clj:161)"
"query_processor.middleware.annotate$add_column_info$fn__42217.invoke(annotate.clj:659)"
"query_processor.middleware.permissions$check_query_permissions$fn__47240.invoke(permissions.clj:108)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__51958.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__47636.invoke(cumulative_aggregations.clj:60)"
"metabase_enterprise.sandbox.query_processor.middleware.row_level_restrictions$apply_row_level_permissions$fn__84700.invoke(row_level_restrictions.clj:338)"
"query_processor.middleware.visualization_settings$update_viz_settings$fn__47574.invoke(visualization_settings.clj:63)"
"query_processor.middleware.escape_join_aliases$escape_join_aliases_middleware$fn__48984.invoke(escape_join_aliases.clj:64)"
"query_processor.middleware.fix_bad_references$fix_bad_references_middleware$fn__51923.invoke(fix_bad_references.clj:91)"
"query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__48521.invoke(resolve_joined_fields.clj:111)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__52570.invoke(resolve_joins.clj:178)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__52112.invoke(add_implicit_joins.clj:246)"
"query_processor.middleware.large_int_id$convert_id_to_string$fn__48540.invoke(large_int_id.clj:59)"
"query_processor.middleware.format_rows$format_rows$fn__52164.invoke(format_rows.clj:74)"
"query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__47908.invoke(add_default_temporal_unit.clj:23)"
"query_processor.middleware.desugar$desugar$fn__47547.invoke(desugar.clj:21)"
"query_processor.middleware.binning$update_binning_strategy$fn__46487.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__46882.invoke(resolve_fields.clj:34)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__51290.invoke(add_dimension_projections.clj:487)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__51584.invoke(add_implicit_clauses.clj:164)"
"metabase_enterprise.sandbox.query_processor.middleware.row_level_restrictions$apply_row_level_permissions$fn__84700.invoke(row_level_restrictions.clj:338)"
"query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__48928.invoke(upgrade_field_literals.clj:117)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__48285.invoke(add_source_metadata.clj:125)"
"metabase_enterprise.sandbox.query_processor.middleware.column_level_perms_check$maybe_apply_column_level_perms_check$fn__83099.invoke(column_level_perms_check.clj:30)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__51835.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__49922.invoke(auto_bucket_datetimes.clj:147)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__46863.invoke(resolve_source_table.clj:45)"
"query_processor.middleware.parameters$substitute_parameters$fn__49576.invoke(parameters.clj:109)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__46936.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__53228.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__49356.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__52179.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51595$fn__51600.invoke(resolve_database_and_driver.clj:35)"
"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__51595.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__47482.invoke(fetch_source_query.clj:286)"
"query_processor.middleware.store$initialize_store$fn__47673$fn__47674.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__47673.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__51930.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__51937.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__49302.invoke(add_rows_truncated.clj:35)"
"metabase_enterprise.audit_app.query_processor.middleware.handle_audit_queries$handle_internal_queries$fn__42923.invoke(handle_audit_queries.clj:130)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__50593.invoke(results_metadata.clj:82)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__49320.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__51871.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__52259.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___40953$thunk__40954.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___40953$fn__40956.invoke(reducible.clj:108)"],
:card_id 20,
:context :question,
:error "ERROR: column products.products - product_id__name does not exist\n Position: 1490",
: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, :process-viz-settings? false},
:info
{:executed-by 3,
:context :question,
:card-id 20,
:card-name "Today's Dropoffs",
:query-hash
[101, -113, -55, -70, 80, 39, -52, 110, -18, 27, 2, 22, -19, -56, -76, -106, -92, -112, -113, 82, -43, 120, 69, -11,
-76, 66, 109, 20, -21, -32, 84, 72]},
:database 2,
:query
{:source-table 11,
:filter
[:and
[:>
[:field 60 {:join-alias "dropoffs"}]
[:value
0

@EricMK Yes, there are a lot of logs, but only the things relating to the error you are currently seeing is relevant.

You are seeing the issue I referenced in previous comment. Notice that you have multiple Saved Questions, which has filters, which you use as the based for a new question.

1 Like

Got it fixed! Thank you super much!!!!