I am joining 1 reasonably complex model with a simpler one and getting this error:
Card 734 does not exist.
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