Join in 2 models leading to "Card 734 does not exist"

1

I am joining 1 reasonably complex model with a simpler one and getting this error:

Card 734 does not exist.

image
image1768×1294 191 KB

What could that be?

Diagnostic info:

{
  "browser-info": {
    "language": "en",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.21+9",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.21",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.21+9",
    "os.name": "Linux",
    "os.version": "4.14.330-176.540.amzn1.x86_64",
    "user.language": "en",
    "user.timezone": "US/Pacific"
  },
  "metabase-info": {
    "databases": [
      "h2",
      "mysql",
      "athena"
    ],
    "hosting-env": "unknown",
    "application-database": "mysql",
    "application-database-details": {
      "database": {
        "name": "MySQL",
        "version": "8.0.33"
      },
      "jdbc-driver": {
        "name": "MariaDB Connector/J",
        "version": "2.7.10"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2024-01-11",
      "tag": "v0.48.3",
      "hash": "80d8323"
    },
    "settings": {
      "report-timezone": null
    }
  }
}

relevant log from logs:

[088fd0f0-9612-4ca4-a820-9329355677b0] 2024-01-17T14:12:59-03:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: Card 734 does not exist.
{:database_id 4,
 :started_at #t "2024-01-17T09:12:59.155129-08:00[US/Pacific]",
 :action_id nil,
 :json_query
 {:database 4,
  :type "query",
  :query
  {:joins
   [{:fields "all",
     :strategy "left-join",
     :alias "vehicleType and fuelType from Utilization Mockup V3 - Make",
     :condition
     ["="
      ["field" "make" {:base-type "type/Text"}]
      ["field"
       3401
       {:base-type "type/Text", :join-alias "vehicleType and fuelType from Utilization Mockup V3 - Make"}]],
     :source-table "card__734"}],
   :limit 10,
   :source-table "card__442"},
  :parameters [],
  :middleware {:js-int-to-string? true, :add-default-userland-constraints? true}},
 :native nil,
 :status :failed,
 :class clojure.lang.ExceptionInfo,
 :stacktrace
 ["--> query_processor.middleware.fetch_source_query$card_id__GT_source_query_and_metadata.invokeStatic(fetch_source_query.clj:128)"
  "query_processor.middleware.fetch_source_query$card_id__GT_source_query_and_metadata.invoke(fetch_source_query.clj:119)"
  "query_processor.middleware.fetch_source_query$card_id__GT_source_query_and_metadata.invokeStatic(fetch_source_query.clj:123)"
  "query_processor.middleware.fetch_source_query$card_id__GT_source_query_and_metadata.invoke(fetch_source_query.clj:119)"
  "query_processor.middleware.fetch_source_query$check_for_circular_references.invokeStatic(fetch_source_query.clj:207)"
  "query_processor.middleware.fetch_source_query$check_for_circular_references.invoke(fetch_source_query.clj:199)"
  "query_processor.middleware.fetch_source_query$check_for_circular_references.invokeStatic(fetch_source_query.clj:204)"
  "query_processor.middleware.fetch_source_query$check_for_circular_references.invoke(fetch_source_query.clj:199)"
  "query_processor.middleware.fetch_source_query$resolve_all.invokeStatic(fetch_source_query.clj:271)"
  "query_processor.middleware.fetch_source_query$resolve_all.invoke(fetch_source_query.clj:263)"
  "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables_STAR_.invokeStatic(fetch_source_query.clj:288)"
  "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables_STAR_.invoke(fetch_source_query.clj:278)"
  "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__65723.invoke(fetch_source_query.clj:295)"
  "query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__71617$fn__71621.invoke(resolve_database_and_driver.clj:77)"
  "driver$do_with_driver.invokeStatic(driver.clj:94)"
  "driver$do_with_driver.invoke(driver.clj:89)"
  "query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__71617.invoke(resolve_database_and_driver.clj:76)"
  "query_processor.middleware.store$initialize_store$fn__66130$fn__66131.invoke(store.clj:14)"
  "query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:169)"
  "query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
  "query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:158)"
  "query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
  "query_processor.middleware.store$initialize_store$fn__66130.invoke(store.clj:13)"
  "query_processor.middleware.resolve_database_and_driver$resolve_database$fn__71614.invoke(resolve_database_and_driver.clj:60)"
  "query_processor.middleware.normalize_query$normalize$fn__71919.invoke(normalize_query.clj:38)"
  "query_processor.middleware.enterprise$fn__71554$handle_audit_app_internal_queries__71555$fn__71557.invoke(enterprise.clj:96)"
  "query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__71565.invoke(enterprise.clj:103)"
  "query_processor.middleware.constraints$add_default_userland_constraints$fn__68663.invoke(constraints.clj:81)"
  "query_processor.middleware.process_userland_query$process_userland_query$fn__71850.invoke(process_userland_query.clj:156)"
  "query_processor.middleware.catch_exceptions$catch_exceptions$fn__72438.invoke(catch_exceptions.clj:171)"
  "query_processor.reducible$async_qp$qp_STAR___61171$thunk__61173.invoke(reducible.clj:126)"
  "query_processor.reducible$async_qp$qp_STAR___61171.invoke(reducible.clj:132)"
  "query_processor.reducible$sync_qp$qp_STAR___61183.doInvoke(reducible.clj:153)"
  "query_processor$process_userland_query.invokeStatic(query_processor.clj:401)"
  "query_processor$process_userland_query.doInvoke(query_processor.clj:397)"
  "query_processor$process_query_and_save_execution_BANG_.invokeStatic(query_processor.clj:415)"
  "query_processor$process_query_and_save_execution_BANG_.invoke(query_processor.clj:405)"
  "query_processor$process_query_and_save_with_max_results_constraints_BANG_.invokeStatic(query_processor.clj:430)"
  "query_processor$process_query_and_save_with_max_results_constraints_BANG_.invoke(query_processor.clj:420)"
  "api.dataset$run_query_async$fn__95140.invoke(dataset.clj:79)"
  "query_processor.streaming$streaming_response_STAR_$fn__51680$fn__51682.invoke(streaming.clj:168)"
  "query_processor.streaming$streaming_response_STAR_$fn__51680.invoke(streaming.clj:167)"
  "async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:69)"
  "async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:67)"
  "async.streaming_response$do_f_async$task__43041.invoke(streaming_response.clj:88)"],
 :card_id 442,
 :context :ad-hoc,
 :error "Card 734 does not exist.",
 :row_count 0,
 :running_time 0,
 :preprocessed nil,
 :ex-data {:card-id 734},
 :data {:rows [], :cols []}}

This "All Vehicles Monthly..." model also gives me some error when trying to GROUP BY specific fields, not all of them:
"Unknown column 'source.department' in 'field list'"

Maybe a relevant info is that this model is a result of some models in a row, some transformations going on, and at some point in the past in a previous model I updated the column name from department to site.

Looking at the log below, seems to be related to the cache?

Relevant log below:

[088fd0f0-9612-4ca4-a820-9329355677b0] 2024-01-17T14:23:21-03:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: Unknown column 'source.department' in 'field list'
{:database_id 4,
 :started_at #t "2024-01-17T09:23:20.905132-08:00[US/Pacific]",
 :via
 [{:status :failed,
   :class org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException,
   :error "Unknown column 'source.department' in 'field list'",
   :stacktrace
   ["org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)"
    "org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:195)"
    "org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:263)"
    "org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:356)"
    "org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:500)"
    "com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)"
    "--> driver.sql_jdbc.execute$fn__78816.invokeStatic(execute.clj:560)"
    "driver.sql_jdbc.execute$fn__78816.invoke(execute.clj:558)"
    "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:568)"
    "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invoke(execute.clj:565)"
    "driver.sql_jdbc.execute$execute_reducible_query$fn__78897$fn__78898.invoke(execute.clj:696)"
    "driver.sql_jdbc.execute$execute_reducible_query$fn__78897.invoke(execute.clj:695)"
    "driver.sql_jdbc.execute$fn__78692$fn__78693.invoke(execute.clj:388)"
    "driver.sql_jdbc.execute$fn__78657$_AMPERSAND_f__78658.invoke(execute.clj:334)"
    "driver.sql_jdbc.execute$fn__78657$fn__78661.invoke(execute.clj:317)"
    "driver.sql_jdbc.execute$fn__78692.invokeStatic(execute.clj:382)"
    "driver.sql_jdbc.execute$fn__78692.invoke(execute.clj:380)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:689)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:678)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:686)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:678)"
    "driver.sql_jdbc$fn__107797.invokeStatic(sql_jdbc.clj:82)"
    "driver.sql_jdbc$fn__107797.invoke(sql_jdbc.clj:80)"
    "query_processor.context$executef.invokeStatic(context.clj:60)"
    "query_processor.context$executef.invoke(context.clj:49)"
    "query_processor.context.default$default_runf.invokeStatic(default.clj:44)"
    "query_processor.context.default$default_runf.invoke(default.clj:42)"
    "query_processor.context$runf.invokeStatic(context.clj:46)"
    "query_processor.context$runf.invoke(context.clj:40)"
    "query_processor.reducible$identity_qp.invokeStatic(reducible.clj:39)"
    "query_processor.reducible$identity_qp.invoke(reducible.clj:36)"
    "query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___71706.invoke(cache.clj:229)"
    "query_processor.middleware.permissions$check_query_permissions$fn__65626.invoke(permissions.clj:140)"
    "query_processor.middleware.enterprise$check_download_permissions_middleware$fn__71527.invoke(enterprise.clj:51)"
    "query_processor.middleware.enterprise$maybe_apply_column_level_perms_check_middleware$fn__71537.invoke(enterprise.clj:64)"
    "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__70774.invoke(mbql_to_native.clj:24)"
    "query_processor$fn__72834$combined_post_process__72839$combined_post_process_STAR___72840.invoke(query_processor.clj:261)"
    "query_processor$fn__72834$combined_pre_process__72835$combined_pre_process_STAR___72836.invoke(query_processor.clj:258)"
    "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__65723.invoke(fetch_source_query.clj:299)"
    "query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__71617$fn__71621.invoke(resolve_database_and_driver.clj:77)"
    "driver$do_with_driver.invokeStatic(driver.clj:94)"
    "driver$do_with_driver.invoke(driver.clj:89)"
    "query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__71617.invoke(resolve_database_and_driver.clj:76)"
    "query_processor.middleware.store$initialize_store$fn__66130$fn__66131.invoke(store.clj:14)"
    "query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:169)"
    "query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
    "query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:158)"
    "query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
    "query_processor.middleware.store$initialize_store$fn__66130.invoke(store.clj:13)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database$fn__71614.invoke(resolve_database_and_driver.clj:60)"
    "query_processor.middleware.normalize_query$normalize$fn__71919.invoke(normalize_query.clj:38)"
    "query_processor.middleware.enterprise$fn__71554$handle_audit_app_internal_queries__71555$fn__71557.invoke(enterprise.clj:96)"
    "query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__71565.invoke(enterprise.clj:103)"
    "query_processor.middleware.constraints$add_default_userland_constraints$fn__68663.invoke(constraints.clj:81)"
    "query_processor.middleware.process_userland_query$process_userland_query$fn__71850.invoke(process_userland_query.clj:156)"
    "query_processor.middleware.catch_exceptions$catch_exceptions$fn__72438.invoke(catch_exceptions.clj:171)"
    "query_processor.reducible$async_qp$qp_STAR___61171$thunk__61173.invoke(reducible.clj:126)"
    "query_processor.reducible$async_qp$qp_STAR___61171.invoke(reducible.clj:132)"
    "query_processor.reducible$sync_qp$qp_STAR___61183.doInvoke(reducible.clj:153)"
    "query_processor$process_userland_query.invokeStatic(query_processor.clj:401)"
    "query_processor$process_userland_query.doInvoke(query_processor.clj:397)"
    "query_processor$process_query_and_save_execution_BANG_.invokeStatic(query_processor.clj:415)"
    "query_processor$process_query_and_save_execution_BANG_.invoke(query_processor.clj:405)"
    "query_processor$process_query_and_save_with_max_results_constraints_BANG_.invokeStatic(query_processor.clj:430)"
    "query_processor$process_query_and_save_with_max_results_constraints_BANG_.invoke(query_processor.clj:420)"
    "api.dataset$run_query_async$fn__95140.invoke(dataset.clj:79)"
    "query_processor.streaming$streaming_response_STAR_$fn__51680$fn__51682.invoke(streaming.clj:168)"
    "query_processor.streaming$streaming_response_STAR_$fn__51680.invoke(streaming.clj:167)"
    "async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:69)"
    "async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:67)"
    "async.streaming_response$do_f_async$task__43041.invoke(streaming_response.clj:88)"],
   :state "42S22"}
  {:status :failed,
   :class java.sql.SQLSyntaxErrorException,
   :error "(conn=1983661) Unknown column 'source.department' in 'field list'",
   :stacktrace
   ["org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)"
    "org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158)"
    "org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:262)"
    "org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:362)"
    "org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:500)"
    "com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)"
    "--> driver.sql_jdbc.execute$fn__78816.invokeStatic(execute.clj:560)"
    "driver.sql_jdbc.execute$fn__78816.invoke(execute.clj:558)"
    "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:568)"
    "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invoke(execute.clj:565)"
    "driver.sql_jdbc.execute$execute_reducible_query$fn__78897$fn__78898.invoke(execute.clj:696)"
    "driver.sql_jdbc.execute$execute_reducible_query$fn__78897.invoke(execute.clj:695)"
    "driver.sql_jdbc.execute$fn__78692$fn__78693.invoke(execute.clj:388)"
    "driver.sql_jdbc.execute$fn__78657$_AMPERSAND_f__78658.invoke(execute.clj:334)"
    "driver.sql_jdbc.execute$fn__78657$fn__78661.invoke(execute.clj:317)"
    "driver.sql_jdbc.execute$fn__78692.invokeStatic(execute.clj:382)"
    "driver.sql_jdbc.execute$fn__78692.invoke(execute.clj:380)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:689)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:678)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:686)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:678)"
    "driver.sql_jdbc$fn__107797.invokeStatic(sql_jdbc.clj:82)"
    "driver.sql_jdbc$fn__107797.invoke(sql_jdbc.clj:80)"
    "query_processor.context$executef.invokeStatic(context.clj:60)"
    "query_processor.context$executef.invoke(context.clj:49)"
    "query_processor.context.default$default_runf.invokeStatic(default.clj:44)"
    "query_processor.context.default$default_runf.invoke(default.clj:42)"
    "query_processor.context$runf.invokeStatic(context.clj:46)"
    "query_processor.context$runf.invoke(context.clj:40)"
    "query_processor.reducible$identity_qp.invokeStatic(reducible.clj:39)"
    "query_processor.reducible$identity_qp.invoke(reducible.clj:36)"
    "query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___71706.invoke(cache.clj:229)"
    "query_processor.middleware.permissions$check_query_permissions$fn__65626.invoke(permissions.clj:140)"
    "query_processor.middleware.enterprise$check_download_permissions_middleware$fn__71527.invoke(enterprise.clj:51)"
    "query_processor.middleware.enterprise$maybe_apply_column_level_perms_check_middleware$fn__71537.invoke(enterprise.clj:64)"
    "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__70774.invoke(mbql_to_native.clj:24)"
    "query_processor$fn__72834$combined_post_process__72839$combined_post_process_STAR___72840.invoke(query_processor.clj:261)"
    "query_processor$fn__72834$combined_pre_process__72835$combined_pre_process_STAR___72836.invoke(query_processor.clj:258)"
    "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__65723.invoke(fetch_source_query.clj:299)"
    "query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__71617$fn__71621.invoke(resolve_database_and_driver.clj:77)"
    "driver$do_with_driver.invokeStatic(driver.clj:94)"
    "driver$do_with_driver.invoke(driver.clj:89)"
    "query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__71617.invoke(resolve_database_and_driver.clj:76)"
    "query_processor.middleware.store$initialize_store$fn__66130$fn__66131.invoke(store.clj:14)"
    "query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:169)"
    "query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
    "query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:158)"
    "query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
    "query_processor.middleware.store$initialize_store$fn__66130.invoke(store.clj:13)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database$fn__71614.invoke(resolve_database_and_driver.clj:60)"
    "query_processor.middleware.normalize_query$normalize$fn__71919.invoke(normalize_query.clj:38)"
    "query_processor.middleware.enterprise$fn__71554$handle_audit_app_internal_queries__71555$fn__71557.invoke(enterprise.clj:96)"
    "query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__71565.invoke(enterprise.clj:103)"
    "query_processor.middleware.constraints$add_default_userland_constraints$fn__68663.invoke(constraints.clj:81)"
    "query_processor.middleware.process_userland_query$process_userland_query$fn__71850.invoke(process_userland_query.clj:156)"
    "query_processor.middleware.catch_exceptions$catch_exceptions$fn__72438.invoke(catch_exceptions.clj:171)"
    "query_processor.reducible$async_qp$qp_STAR___61171$thunk__61173.invoke(reducible.clj:126)"
    "query_processor.reducible$async_qp$qp_STAR___61171.invoke(reducible.clj:132)"
    "query_processor.reducible$sync_qp$qp_STAR___61183.doInvoke(reducible.clj:153)"
    "query_processor$process_userland_query.invokeStatic(query_processor.clj:401)"
    "query_processor$process_userland_query.doInvoke(query_processor.clj:397)"
    "query_processor$process_query_and_save_execution_BANG_.invokeStatic(query_processor.clj:415)"
    "query_processor$process_query_and_save_execution_BANG_.invoke(query_processor.clj:405)"
    "query_processor$process_query_and_save_with_max_results_constraints_BANG_.invokeStatic(query_processor.clj:430)"
    "query_processor$process_query_and_save_with_max_results_constraints_BANG_.invoke(query_processor.clj:420)"
    "api.dataset$run_query_async$fn__95140.invoke(dataset.clj:79)"
    "query_processor.streaming$streaming_response_STAR_$fn__51680$fn__51682.invoke(streaming.clj:168)"
    "query_processor.streaming$streaming_response_STAR_$fn__51680.invoke(streaming.clj:167)"
    "async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:69)"
    "async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:67)"
    "async.streaming_response$do_f_async$task__43041.invoke(streaming_response.clj:88)"],
   :state "42S22"}
  {:status :failed,
   :class clojure.lang.ExceptionInfo,
   :error "Error executing query: (conn=1983661) Unknown column 'source.department' in 'field list'",
   :stacktrace
   ["--> driver.sql_jdbc.execute$execute_reducible_query$fn__78897$fn__78898.invoke(execute.clj:698)"
    "driver.sql_jdbc.execute$execute_reducible_query$fn__78897.invoke(execute.clj:695)"
    "driver.sql_jdbc.execute$fn__78692$fn__78693.invoke(execute.clj:388)"
    "driver.sql_jdbc.execute$fn__78657$_AMPERSAND_f__78658.invoke(execute.clj:334)"
    "driver.sql_jdbc.execute$fn__78657$fn__78661.invoke(execute.clj:317)"
    "driver.sql_jdbc.execute$fn__78692.invokeStatic(execute.clj:382)"
    "driver.sql_jdbc.execute$fn__78692.invoke(execute.clj:380)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:689)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:678)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:686)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:678)"
    "driver.sql_jdbc$fn__107797.invokeStatic(sql_jdbc.clj:82)"
    "driver.sql_jdbc$fn__107797.invoke(sql_jdbc.clj:80)"
    "query_processor.context$executef.invokeStatic(context.clj:60)"
    "query_processor.context$executef.invoke(context.clj:49)"
    "query_processor.context.default$default_runf.invokeStatic(default.clj:44)"
    "query_processor.context.default$default_runf.invoke(default.clj:42)"
    "query_processor.context$runf.invokeStatic(context.clj:46)"
    "query_processor.context$runf.invoke(context.clj:40)"
    "query_processor.reducible$identity_qp.invokeStatic(reducible.clj:39)"
    "query_processor.reducible$identity_qp.invoke(reducible.clj:36)"
    "query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___71706.invoke(cache.clj:229)"
    "query_processor.middleware.permissions$check_query_permissions$fn__65626.invoke(permissions.clj:140)"
    "query_processor.middleware.enterprise$check_download_permissions_middleware$fn__71527.invoke(enterprise.clj:51)"
    "query_processor.middleware.enterprise$maybe_apply_column_level_perms_check_middleware$fn__71537.invoke(enterprise.clj:64)"
    "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__70774.invoke(mbql_to_native.clj:24)"
    "query_processor$fn__72834$combined_post_process__72839$combined_post_process_STAR___72840.invoke(query_processor.clj:261)"
    "query_processor$fn__72834$combined_pre_process__72835$combined_pre_process_STAR___72836.invoke(query_processor.clj:258)"
    "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__65723.invoke(fetch_source_query.clj:299)"
    "query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__71617$fn__71621.invoke(resolve_database_and_driver.clj:77)"
    "driver$do_with_driver.invokeStatic(driver.clj:94)"
    "driver$do_with_driver.invoke(driver.clj:89)"
    "query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__71617.invoke(resolve_database_and_driver.clj:76)"
    "query_processor.middleware.store$initialize_store$fn__66130$fn__66131.invoke(store.clj:14)"
    "query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:169)"
    "query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
    "query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:158)"
    "query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
    "query_processor.middleware.store$initialize_store$fn__66130.invoke(store.clj:13)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database$fn__71614.invoke(resolve_database_and_driver.clj:60)"
    "query_processor.middleware.normalize_query$normalize$fn__71919.invoke(normalize_query.clj:38)"
    "query_processor.middleware.enterprise$fn__71554$handle_audit_app_internal_queries__71555$fn__71557.invoke(enterprise.clj:96)"
    "query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__71565.invoke(enterprise.clj:103)"
    "query_processor.middleware.constraints$add_default_userland_constraints$fn__68663.invoke(constraints.clj:81)"
    "query_processor.middleware.process_userland_query$process_userland_query$fn__71850.invoke(process_userland_query.clj:156)"
    "query_processor.middleware.catch_exceptions$catch_exceptions$fn__72438.invoke(catch_exceptions.clj:171)"
    "query_processor.reducible$async_qp$qp_STAR___61171$thunk__61173.invoke(reducible.clj:126)"
    "query_processor.reducible$async_qp$qp_STAR___61171.invoke(reducible.clj:132)"
    "query_processor.reducible$sync_qp$qp_STAR___61183.doInvoke(reducible.clj:153)"
    "query_processor$process_userland_query.invokeStatic(query_processor.clj:401)"
    "query_processor$process_userland_query.doInvoke(query_processor.clj:397)"
    "query_processor$process_query_and_save_execution_BANG_.invokeStatic(query_processor.clj:415)"
    "query_processor$process_query_and_save_execution_BANG_.invoke(query_processor.clj:405)"
    "query_processor$process_query_and_save_with_max_results_constraints_BANG_.invokeStatic(query_processor.clj:430)"
    "query_processor$process_query_and_save_with_max_results_constraints_BANG_.invoke(query_processor.clj:420)"
    "api.dataset$run_query_async$fn__95140.invoke(dataset.clj:79)"
    "query_processor.streaming$streaming_response_STAR_$fn__51680$fn__51682.invoke(streaming.clj:168)"
    "query_processor.streaming$streaming_response_STAR_$fn__51680.invoke(streaming.clj:167)"
    "async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:69)"
    "async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:67)"
    "async.streaming_response$do_f_async$task__43041.invoke(streaming_response.clj:88)"],
   :error_type :invalid-query,
   :ex-data
   {:driver :mysql,
    :sql
    ["-- Metabase:: userID: 10 queryType: MBQL queryHash: 3b276ee60cb01b58b3f9173b466bf5a0281cb5f81bfc61cbbe3d2c27cf5726a4"
     "SELECT"
     "  `source`.`department` AS `department`"
     "FROM"
     "  ("
     "    select"
     "      *"
     "    from"
     "      `metabase_cache_db493_4`.`model_442_all_vehicl`"
     "  ) AS `source`"
     "GROUP BY"
     "  `source`.`department`"
     "ORDER BY"
     "  `source`.`department` ASC"
     "LIMIT"
     "  10"],
    :params nil,
    :type :invalid-query}}],
 :action_id nil,
 :state "42S22",
 :error_type :invalid-query,
 :json_query
 {:database 4,
  :type "query",
  :query {:breakout [["field" 3762 {:base-type "type/Text"}]], :limit 10, :source-table "card__442"},
  :parameters [],
  :middleware {:js-int-to-string? true, :add-default-userland-constraints? true}},
 :native
 {:query
  "SELECT `source`.`department` AS `department` FROM (select * from `metabase_cache_db493_4`.`model_442_all_vehicl`) AS `source` GROUP BY `source`.`department` ORDER BY `source`.`department` ASC LIMIT 10",
  :params nil},
 :status :failed,
 :class java.sql.SQLException,
 :stacktrace
 ["org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1693)"
  "org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1555)"
  "org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1518)"
  "org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:257)"
  "org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:356)"
  "org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:500)"
  "com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)"
  "--> driver.sql_jdbc.execute$fn__78816.invokeStatic(execute.clj:560)"
  "driver.sql_jdbc.execute$fn__78816.invoke(execute.clj:558)"
  "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:568)"
  "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invoke(execute.clj:565)"
  "driver.sql_jdbc.execute$execute_reducible_query$fn__78897$fn__78898.invoke(execute.clj:696)"
  "driver.sql_jdbc.execute$execute_reducible_query$fn__78897.invoke(execute.clj:695)"
  "driver.sql_jdbc.execute$fn__78692$fn__78693.invoke(execute.clj:388)"
  "driver.sql_jdbc.execute$fn__78657$_AMPERSAND_f__78658.invoke(execute.clj:334)"
  "driver.sql_jdbc.execute$fn__78657$fn__78661.invoke(execute.clj:317)"
  "driver.sql_jdbc.execute$fn__78692.invokeStatic(execute.clj:382)"
  "driver.sql_jdbc.execute$fn__78692.invoke(execute.clj:380)"
  "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:689)"
  "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:678)"
  "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:686)"
  "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:678)"
  "driver.sql_jdbc$fn__107797.invokeStatic(sql_jdbc.clj:82)"
  "driver.sql_jdbc$fn__107797.invoke(sql_jdbc.clj:80)"
  "query_processor.context$executef.invokeStatic(context.clj:60)"
  "query_processor.context$executef.invoke(context.clj:49)"
  "query_processor.context.default$default_runf.invokeStatic(default.clj:44)"
  "query_processor.context.default$default_runf.invoke(default.clj:42)"
  "query_processor.context$runf.invokeStatic(context.clj:46)"
  "query_processor.context$runf.invoke(context.clj:40)"
  "query_processor.reducible$identity_qp.invokeStatic(reducible.clj:39)"
  "query_processor.reducible$identity_qp.invoke(reducible.clj:36)"
  "query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___71706.invoke(cache.clj:229)"
  "query_processor.middleware.permissions$check_query_permissions$fn__65626.invoke(permissions.clj:140)"
  "query_processor.middleware.enterprise$check_download_permissions_middleware$fn__71527.invoke(enterprise.clj:51)"
  "query_processor.middleware.enterprise$maybe_apply_column_level_perms_check_middleware$fn__71537.invoke(enterprise.clj:64)"
  "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__70774.invoke(mbql_to_native.clj:24)"
  "query_processor$fn__72834$combined_post_process__72839$combined_post_process_STAR___72840.invoke(query_processor.clj:261)"
  "query_processor$fn__72834$combined_pre_process__72835$combined_pre_process_STAR___72836.invoke(query_processor.clj:258)"
  "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__65723.invoke(fetch_source_query.clj:299)"
  "query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__71617$fn__71621.invoke(resolve_database_and_driver.clj:77)"
  "driver$do_with_driver.invokeStatic(driver.clj:94)"
  "driver$do_with_driver.invoke(driver.clj:89)"
  "query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__71617.invoke(resolve_database_and_driver.clj:76)"
  "query_processor.middleware.store$initialize_store$fn__66130$fn__66131.invoke(store.clj:14)"
  "query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:169)"
  "query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
  "query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:158)"
  "query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
  "query_processor.middleware.store$initialize_store$fn__66130.invoke(store.clj:13)"
  "query_processor.middleware.resolve_database_and_driver$resolve_database$fn__71614.invoke(resolve_database_and_driver.clj:60)"
  "query_processor.middleware.normalize_query$normalize$fn__71919.invoke(normalize_query.clj:38)"
  "query_processor.middleware.enterprise$fn__71554$handle_audit_app_internal_queries__71555$fn__71557.invoke(enterprise.clj:96)"
  "query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__71565.invoke(enterprise.clj:103)"
  "query_processor.middleware.constraints$add_default_userland_constraints$fn__68663.invoke(constraints.clj:81)"
  "query_processor.middleware.process_userland_query$process_userland_query$fn__71850.invoke(process_userland_query.clj:156)"
  "query_processor.middleware.catch_exceptions$catch_exceptions$fn__72438.invoke(catch_exceptions.clj:171)"
  "query_processor.reducible$async_qp$qp_STAR___61171$thunk__61173.invoke(reducible.clj:126)"
  "query_processor.reducible$async_qp$qp_STAR___61171.invoke(reducible.clj:132)"
  "query_processor.reducible$sync_qp$qp_STAR___61183.doInvoke(reducible.clj:153)"
  "query_processor$process_userland_query.invokeStatic(query_processor.clj:401)"
  "query_processor$process_userland_query.doInvoke(query_processor.clj:397)"
  "query_processor$process_query_and_save_execution_BANG_.invokeStatic(query_processor.clj:415)"
  "query_processor$process_query_and_save_execution_BANG_.invoke(query_processor.clj:405)"
  "query_processor$process_query_and_save_with_max_results_constraints_BANG_.invokeStatic(query_processor.clj:430)"
  "query_processor$process_query_and_save_with_max_results_constraints_BANG_.invoke(query_processor.clj:420)"
  "api.dataset$run_query_async$fn__95140.invoke(dataset.clj:79)"
  "query_processor.streaming$streaming_response_STAR_$fn__51680$fn__51682.invoke(streaming.clj:168)"
  "query_processor.streaming$streaming_response_STAR_$fn__51680.invoke(streaming.clj:167)"
  "async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:69)"
  "async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:67)"
  "async.streaming_response$do_f_async$task__43041.invoke(streaming_response.clj:88)"],
 :card_id 442,
 :context :ad-hoc,
 :error "Unknown column 'source.department' in 'field list'",
 :row_count 0,
 :running_time 0,
 :preprocessed
1 Like
2

same here

3

Does it happen only on 48? ... Do you have Model caching enabled?

4

@TonyC 48 as in Metabase version? if that's the case no. I've updated from 46 to 48 and the issue continued.

I have caching enable.

Partially the "card doesn't exist" stopped showing up, I don't know why, but this other one is still going on consistently:

This "All Vehicles Monthly..." model also gives me some error when trying to GROUP BY specific fields, not all of them:
"Unknown column 'source.department' in 'field list'"
5

@TonyC is there a way to "restart" the cache? I thought about disabling and re-enabling it, but maybe there is a better approach.

6

That might be helpful and you can try! I am still not sure why that happened

7

I still can't make it work. Disabling cache doesn't do any help. Mine happens on every joins involving two different database source. running 0.48.3

8

I disabled and re-enabled the model caching, didn't work.

This might be related to this: Caching a model with columns with repeated names will generate invalid queries · Issue #25014 · metabase/metabase · GitHub

My models use the same name in subsequent models.

9

happens on every joins involving two different database source

Happens to me too. I believe this just simply is not a feature. See github discussion below

Though there should be hacky workarounds

10

we will post soon in our docs how to make this happen

1 Like
11

to be clear: my use case isn't using different databases. it just happens randomly using 1 database.

12

@Luiggi could you please update this thread too when it is ready

13

Hello there, any update on the docs for this?

Thank you.
Sarah.

14

I am experiencing the same error message when joining an uploaded csv model to models created the my connected Oracle databasel. Any update on the fix? Running v48.5.