Many errors in Metabase log

Get Help
1

Hi

when I open Metabase log, I found many errors like

May 19 16:00:47 WARN metabase.query-processor.middleware.process-userland-query :: Query failure {:status :failed,
:class java.lang.Exception,
:error “java.lang.Exception”,
:stacktrace
("–> query_processor$fn__40397.invokeStatic(query_processor.clj:169)"
“query_processor$fn__40397.invoke(query_processor.clj:169)”
“query_processor__init.load(Unknown Source)”
“query_processor__init.(Unknown Source)”
“query_processor.async$loading__6706__auto____31425.invoke(async.clj:1)”
“query_processor.async__init.load(Unknown Source)”
“query_processor.async__init.(Unknown Source)”
“api.dataset$loading__6706__auto____43878.invoke(dataset.clj:1)”
“api.dataset__init.load(Unknown Source)”
“api.dataset__init.(Unknown Source)”
“routes$loading__6706__auto____60989.invoke(routes.clj:1)”
“routes__init.load(Unknown Source)”
“routes__init.(Unknown Source)”
“handler$loading__6706__auto____60987.invoke(handler.clj:1)”
“handler__init.load(Unknown Source)”
“handler__init.(Unknown Source)”
“core$loading__6706__auto____60985.invoke(core.clj:2)”
“core__init.load(Unknown Source)”
“core__init.(Unknown Source)”
“core.(Unknown Source)”),
:query
{:type “query”,
:query {:source-table 70499, :aggregation [“count”], :filter [“and” ["=" 1160420 3494]]},
:middleware {:add-default-userland-constraints? true, :userland-query? true, :disable-mbql->native? true},
:info
{:executed-by 97,
:context :ad-hoc,
:card-id nil,
:nested? false,
:query-hash [-66, -30, 29, 0, -43, -53, -110, -15, 79, 17, 114, 66, 47, 7, 20, 102, 3, -15, 82, -28, 89, -56, -52, 5, 111, -67, -34, -56, -41, -126, 45, 78]},
:constraints {:max-results 10000, :max-results-bare-rows 2000},
:results-promise
#<Promise@a630c17:
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:settings {},
:type :query,
:middleware {:add-default-userland-constraints? true, :userland-query? true, :disable-mbql->native? true},
:info
{:executed-by 97,
:context :ad-hoc,
:nested? false,
:query-hash [-66, -30, 29, 0, -43, -53, -110, -15, 79, 17, 114, 66, 47, 7, 20, 102, 3, -15, 82, -28, 89, -56, -52, 5, 111, -67, -34, -56, -41, -126, 45, 78]},
:database 16,
:driver :postgres,
:query {:source-table 70499, :aggregation [[:count]], :filter [:= [:field-id 1160420] [:value 3494 {:base_type :type/UUID, :special_type :type/FK, :database_type “uuid”}]]}}>}}

May 19 16:00:47 ERROR metabase.query-processor.middleware.mbql-to-native :: Error transforming MBQL query to native:
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:settings {},
:type :query,
:results-promise #<Promise@6aa7972: :not-delivered>,
:middleware {:add-default-userland-constraints? true, :userland-query? true},
:info
{:executed-by 97,
:context :ad-hoc,
:nested? false,
:query-hash [-66, -30, 29, 0, -43, -53, -110, -15, 79, 17, 114, 66, 47, 7, 20, 102, 3, -15, 82, -28, 89, -56, -52, 5, 111, -67, -34, -56, -41, -126, 45, 78]},
:database 16,
:driver :postgres,
:query {:source-table 70499, :aggregation [[:count]], :filter [:= [:field-id 1160420] [:value 3494 {:base_type :type/UUID, :special_type :type/FK, :database_type “uuid”}]]}}

May 19 16:00:47 WARN metabase.query-processor.middleware.process-userland-query :: Query failure {:status :failed,
:class java.lang.ClassCastException,
:error “class java.lang.Integer cannot be cast to class java.lang.String (java.lang.Integer and java.lang.String are in module java.base of loader ‘bootstrap’)”,
:stacktrace
("–> driver.postgres$fn__62762.invokeStatic(postgres.clj:145)"
“driver.postgres$fn__62762.invoke(postgres.clj:141)”
“driver.sql.query_processor$fn__35408.invokeStatic(query_processor.clj:409)”
“driver.sql.query_processor$fn__35408.invoke(query_processor.clj:408)”
“driver.sql.query_processor$fn__35438.invokeStatic(query_processor.clj:426)”
“driver.sql.query_processor$fn__35438.invoke(query_processor.clj:424)”
“driver.sql.query_processor$apply_top_level_clauses.invokeStatic(query_processor.clj:515)”
“driver.sql.query_processor$apply_top_level_clauses.invoke(query_processor.clj:510)”
“driver.sql.query_processor$apply_clauses.invokeStatic(query_processor.clj:573)”
“driver.sql.query_processor$apply_clauses.invoke(query_processor.clj:564)”
“driver.sql.query_processor$build_honeysql_form.invokeStatic(query_processor.clj:579)”
“driver.sql.query_processor$build_honeysql_form.invoke(query_processor.clj:575)”
“driver.sql.query_processor$mbql__GT_native.invokeStatic(query_processor.clj:609)”
“driver.sql.query_processor$mbql__GT_native.invoke(query_processor.clj:605)”
“driver.sql$fn__35587.invokeStatic(sql.clj:22)”
“driver.sql$fn__35587.invoke(sql.clj:21)”
“query_processor.middleware.mbql_to_native$query__GT_native_form$fn__34651.invoke(mbql_to_native.clj:16)”
“query_processor.middleware.mbql_to_native$query__GT_native_form.invokeStatic(mbql_to_native.clj:16)”
“query_processor.middleware.mbql_to_native$query__GT_native_form.invoke(mbql_to_native.clj:11)”
“query_processor.middleware.mbql_to_native$mbql__GT_native$fn__34658.invoke(mbql_to_native.clj:32)”
“query_processor.middleware.annotate$result_rows_maps__GT_vectors$fn__32695.invoke(annotate.clj:368)”
“query_processor.middleware.annotate$add_column_info$fn__32600.invoke(annotate.clj:303)”
“query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__34138.invoke(cumulative_aggregations.clj:57)”
“query_processor.middleware.limit$limit$fn__34631.invoke(limit.clj:19)”
“query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__40243.invoke(results_metadata.clj:86)”
“query_processor.middleware.format_rows$format_rows$fn__34619.invoke(format_rows.clj:26)”
“query_processor.middleware.add_dimension_projections$add_remapping$fn__31752.invoke(add_dimension_projections.clj:236)”
“query_processor.middleware.add_row_count_and_status$add_row_count_and_status$fn__32146.invoke(add_row_count_and_status.clj:16)”
“query_processor.middleware.driver_specific$process_query_in_context$fn__34380.invoke(driver_specific.clj:12)”
“query_processor.middleware.resolve_driver$resolve_driver$fn__37209.invoke(resolve_driver.clj:15)”
“query_processor.middleware.bind_effective_timezone$bind_effective_timezone$fn__33550$fn__33551.invoke(bind_effective_timezone.clj:9)”
“util.date$call_with_effective_timezone.invokeStatic(date.clj:88)”
“util.date$call_with_effective_timezone.invoke(date.clj:77)”
“query_processor.middleware.bind_effective_timezone$bind_effective_timezone$fn__33550.invoke(bind_effective_timezone.clj:8)”
“query_processor.middleware.store$initialize_store$fn__40268$fn__40269.invoke(store.clj:11)”
“query_processor.store$do_with_new_store.invokeStatic(store.clj:35)”
“query_processor.store$do_with_new_store.invoke(store.clj:31)”
“query_processor.middleware.store$initialize_store$fn__40268.invoke(store.clj:10)”
“query_processor.middleware.async$async__GT_sync$fn__33146.invoke(async.clj:19)”
“query_processor.middleware.async_wait$wait_for_turn$fn__33370.invoke(async_wait.clj:93)”
“query_processor.middleware.cache$maybe_return_cached_results$fn__33976.invoke(cache.clj:129)”
“query_processor.middleware.validate$validate_query$fn__40277.invoke(validate.clj:10)”
“query_processor.middleware.normalize_query$normalize$fn__34667.invoke(normalize_query.clj:11)”
“query_processor.middleware.catch_exceptions$catch_exceptions$fn__34031.invoke(catch_exceptions.clj:98)”
“query_processor.middleware.process_userland_query$process_userland_query$fn__37070.invoke(process_userland_query.clj:157)”
“query_processor.middleware.constraints$add_default_userland_constraints$fn__34081.invoke(constraints.clj:42)”
“query_processor.middleware.async$async_setup$fn__33210.invoke(async.clj:85)”
“query_processor$fn__40397$receive_native_query__40402$fn__40403.invoke(query_processor.clj:183)”
“query_processor$query__GT_native.invokeStatic(query_processor.clj:212)”
“query_processor$query__GT_native.invoke(query_processor.clj:204)”
“query_processor.middleware.catch_exceptions$fn__33990$fn__33992$fn__33995.invoke(catch_exceptions.clj:38)”
“query_processor.middleware.catch_exceptions$fn__33990$fn__33992.invoke(catch_exceptions.clj:37)”
“query_processor.middleware.catch_exceptions$fn__33990.invokeStatic(catch_exceptions.clj:34)”
“query_processor.middleware.catch_exceptions$fn__33990.invoke(catch_exceptions.clj:16)”
“query_processor.middleware.catch_exceptions$catch_exceptions$fn__34031$raise__34032.invoke(catch_exceptions.clj:96)”
“query_processor.middleware.async$async__GT_sync$fn__33146.invoke(async.clj:21)”
“query_processor.middleware.async_wait$runnable$fn__33277.invoke(async_wait.clj:71)”),
:query
{:type “query”,
:query {:source-table 70499, :aggregation [“count”], :filter [“and” ["=" 1160420 3494]]},
:middleware {:add-default-userland-constraints? true, :userland-query? true},
:info
{:executed-by 97,
:context :ad-hoc,
:card-id nil,
:nested? false,
:query-hash [-66, -30, 29, 0, -43, -53, -110, -15, 79, 17, 114, 66, 47, 7, 20, 102, 3, -15, 82, -28, 89, -56, -52, 5, 111, -67, -34, -56, -41, -126, 45, 78]},
:constraints {:max-results 10000, :max-results-bare-rows 2000},
:results-promise #<Promise@6aa7972: :not-delivered>}}

May 19 16:00:47 WARN metabase.query-processor.middleware.process-userland-query :: Query failure {:status :failed,
:class java.lang.ClassCastException,
:error “class java.lang.Integer cannot be cast to class java.lang.String (java.lang.Integer and java.lang.String are in module java.base of loader ‘bootstrap’)”,
:stacktrace
("–> driver.postgres$fn__62762.invokeStatic(postgres.clj:145)"
“driver.postgres$fn__62762.invoke(postgres.clj:141)”
“driver.sql.query_processor$fn__35408.invokeStatic(query_processor.clj:409)”
“driver.sql.query_processor$fn__35408.invoke(query_processor.clj:408)”
“driver.sql.query_processor$fn__35438.invokeStatic(query_processor.clj:426)”
“driver.sql.query_processor$fn__35438.invoke(query_processor.clj:424)”
“driver.sql.query_processor$apply_top_level_clauses.invokeStatic(query_processor.clj:515)”
“driver.sql.query_processor$apply_top_level_clauses.invoke(query_processor.clj:510)”
“driver.sql.query_processor$apply_clauses.invokeStatic(query_processor.clj:573)”
“driver.sql.query_processor$apply_clauses.invoke(query_processor.clj:564)”
“driver.sql.query_processor$build_honeysql_form.invokeStatic(query_processor.clj:579)”
“driver.sql.query_processor$build_honeysql_form.invoke(query_processor.clj:575)”
“driver.sql.query_processor$mbql__GT_native.invokeStatic(query_processor.clj:609)”
“driver.sql.query_processor$mbql__GT_native.invoke(query_processor.clj:605)”
“driver.sql$fn__35587.invokeStatic(sql.clj:22)”
“driver.sql$fn__35587.invoke(sql.clj:21)”
“query_processor.middleware.mbql_to_native$query__GT_native_form$fn__34651.invoke(mbql_to_native.clj:16)”
“query_processor.middleware.mbql_to_native$query__GT_native_form.invokeStatic(mbql_to_native.clj:16)”
“query_processor.middleware.mbql_to_native$query__GT_native_form.invoke(mbql_to_native.clj:11)”
“query_processor.middleware.mbql_to_native$mbql__GT_native$fn__34658.invoke(mbql_to_native.clj:32)”
“query_processor.middleware.annotate$result_rows_maps__GT_vectors$fn__32695.invoke(annotate.clj:368)”
“query_processor.middleware.annotate$add_column_info$fn__32600.invoke(annotate.clj:303)”
“query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__34138.invoke(cumulative_aggregations.clj:57)”
“query_processor.middleware.limit$limit$fn__34631.invoke(limit.clj:19)”
“query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__40243.invoke(results_metadata.clj:86)”
“query_processor.middleware.format_rows$format_rows$fn__34619.invoke(format_rows.clj:26)”
“query_processor.middleware.add_dimension_projections$add_remapping$fn__31752.invoke(add_dimension_projections.clj:236)”
“query_processor.middleware.add_row_count_and_status$add_row_count_and_status$fn__32146.invoke(add_row_count_and_status.clj:16)”
“query_processor.middleware.driver_specific$process_query_in_context$fn__34380.invoke(driver_specific.clj:12)”
“query_processor.middleware.resolve_driver$resolve_driver$fn__37209.invoke(resolve_driver.clj:15)”
“query_processor.middleware.bind_effective_timezone$bind_effective_timezone$fn__33550$fn__33551.invoke(bind_effective_timezone.clj:9)”
“util.date$call_with_effective_timezone.invokeStatic(date.clj:88)”
“util.date$call_with_effective_timezone.invoke(date.clj:77)”
“query_processor.middleware.bind_effective_timezone$bind_effective_timezone$fn__33550.invoke(bind_effective_timezone.clj:8)”
“query_processor.middleware.store$initialize_store$fn__40268$fn__40269.invoke(store.clj:11)”
“query_processor.store$do_with_new_store.invokeStatic(store.clj:35)”
“query_processor.store$do_with_new_store.invoke(store.clj:31)”
“query_processor.middleware.store$initialize_store$fn__40268.invoke(store.clj:10)”
“query_processor.middleware.async$async__GT_sync$fn__33146.invoke(async.clj:19)”
“query_processor.middleware.async_wait$runnable$fn__33277.invoke(async_wait.clj:71)”),
:query
{:type “query”,
:query {:source-table 70499, :aggregation [“count”], :filter [“and” ["=" 1160420 3494]]},
:async? true,
:middleware {:add-default-userland-constraints? true, :userland-query? true},
:info
{:executed-by 97,
:context :ad-hoc,
:card-id nil,
:nested? false,
:query-hash [-66, -30, 29, 0, -43, -53, -110, -15, 79, 17, 114, 66, 47, 7, 20, 102, 3, -15, 82, -28, 89, -56, -52, 5, 111, -67, -34, -56, -41, -126, 45, 78]},
:constraints {:max-results 10000, :max-results-bare-rows 2000}},
:preprocessed
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:settings {},
:type :query,
:middleware {:add-default-userland-constraints? true, :userland-query? true},
:info
{:executed-by 97,
:context :ad-hoc,
:nested? false,
:query-hash [-66, -30, 29, 0, -43, -53, -110, -15, 79, 17, 114, 66, 47, 7, 20, 102, 3, -15, 82, -28, 89, -56, -52, 5, 111, -67, -34, -56, -41, -126, 45, 78]},
:database 16,
:driver :postgres,
:query {:source-table 70499, :aggregation [[:count]], :filter [:= [:field-id 1160420] [:value 3494 {:base_type :type/UUID, :special_type :type/FK, :database_type “uuid”}]]}},
:native nil}

2

Hi @faresalokeeli
Which version of Metabase?
Which database are you connected to - type and version?

3

Hi Flamber

we have Metabase 0.32.7, and the metadata is MySQL 8
total size ( 4G)

4

@faresalokeeli
I would recommend upgrading to 0.32.8, since it fixes a couple of other issues (specially language translations).
I meant, which database do you connect to - not the metadata database?

5

I will install new version
all issues come from connections to MySQL Galera cluster 5.6

we connect through Virtual IP (HAproxy) load balancer, and load balancer distributes connections to nodes.

6

now i upgrade to last version and this is there first issue i have

May 21 17:23:25 DEBUG metabase.plugins.jdbc-proxy :: Registering JDBC proxy driver for class com.microsoft.sqlserver.jdbc.SQLServerDriver…
May 21 17:23:25 WARN metabase.query-processor.middleware.process-userland-query :: Query failure {:status :failed,
:class java.sql.SQLException,
:error “No suitable driver”,
:stacktrace
(“java.sql/java.sql.DriverManager.getDriver(DriverManager.java:298)”
“–> db.connection_pool$proxy_data_source.invokeStatic(connection_pool.clj:20)”
“db.connection_pool$proxy_data_source.invoke(connection_pool.clj:16)”
“db.connection_pool$unpooled_data_source.invokeStatic(connection_pool.clj:51)”
“db.connection_pool$unpooled_data_source.invoke(connection_pool.clj:49)”
“db.connection_pool$pooled_data_source.invokeStatic(connection_pool.clj:57)”
“db.connection_pool$pooled_data_source.invoke(connection_pool.clj:53)”
“driver.sql_jdbc.connection$create_pool_BANG_.invokeStatic(connection.clj:50)”
“driver.sql_jdbc.connection$create_pool_BANG_.invoke(connection.clj:43)”
“driver.sql_jdbc.connection$db__GT_pooled_connection_spec.invokeStatic(connection.clj:103)”
“driver.sql_jdbc.connection$db__GT_pooled_connection_spec.invoke(connection.clj:84)”
“driver.sql_jdbc.execute$execute_query$fn__62602.invoke(execute.clj:286)”
“driver.sql_jdbc.execute$do_with_try_catch.invokeStatic(execute.clj:216)”
“driver.sql_jdbc.execute$do_with_try_catch.invoke(execute.clj:210)”
“driver.sql_jdbc.execute$execute_query.invokeStatic(execute.clj:284)”
“driver.sql_jdbc.execute$execute_query.invoke(execute.clj:278)”
“driver.sql_jdbc$fn__62845.invokeStatic(sql_jdbc.clj:48)”
“driver.sql_jdbc$fn__62845.invoke(sql_jdbc.clj:47)”
“query_processor$fn__40384$execute_query__40389$fn__40390.invoke(query_processor.clj:61)”
“query_processor$fn__40384$execute_query__40389.invoke(query_processor.clj:55)”
“query_processor.middleware.mbql_to_native$mbql__GT_native$fn__34664.invoke(mbql_to_native.clj:36)”
“query_processor.middleware.annotate$result_rows_maps__GT_vectors$fn__32695.invoke(annotate.clj:368)”
“query_processor.middleware.annotate$add_column_info$fn__32600.invoke(annotate.clj:303)”
“query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__34144.invoke(cumulative_aggregations.clj:57)”
“query_processor.middleware.limit$limit$fn__34637.invoke(limit.clj:19)”
“query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__40249.invoke(results_metadata.clj:86)”
“query_processor.middleware.format_rows$format_rows$fn__34625.invoke(format_rows.clj:26)”
“query_processor.middleware.add_dimension_projections$add_remapping$fn__31752.invoke(add_dimension_projections.clj:234)”
“query_processor.middleware.add_row_count_and_status$add_row_count_and_status$fn__32146.invoke(add_row_count_and_status.clj:16)”
“query_processor.middleware.driver_specific$process_query_in_context$fn__34386.invoke(driver_specific.clj:12)”
“query_processor.middleware.resolve_driver$resolve_driver$fn__37215.invoke(resolve_driver.clj:15)”
“query_processor.middleware.bind_effective_timezone$bind_effective_timezone$fn__33550$fn__33551.invoke(bind_effective_timezone.clj:9)”
“util.date$call_with_effective_timezone.invokeStatic(date.clj:88)”
“util.date$call_with_effective_timezone.invoke(date.clj:77)”
“query_processor.middleware.bind_effective_timezone$bind_effective_timezone$fn__33550.invoke(bind_effective_timezone.clj:8)”
“query_processor.middleware.store$initialize_store$fn__40274$fn__40275.invoke(store.clj:11)”
“query_processor.store$do_with_new_store.invokeStatic(store.clj:35)”
“query_processor.store$do_with_new_store.invoke(store.clj:31)”
“query_processor.middleware.store$initialize_store$fn__40274.invoke(store.clj:10)”
“query_processor.middleware.async$async__GT_sync$fn__33146.invoke(async.clj:19)”
“query_processor.middleware.async_wait$runnable$fn__33277.invoke(async_wait.clj:71)”),
:query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :native,
:middleware {:userland-query? true},
:native
{:query
"\r\n–inc_prior_id\r\nselect \r\n\t\t\tcase i.inc_status when ‘o’ then ‘Open’ \r\n\t\t\t\t\t\t when ‘p’ then ‘Resloved’\r\n\t\t\t\t\t\t when ‘c’ then ‘Closed’ end ‘Event Status’,\r\n count(distinct i.incident_id) ‘Number of Events’\r\nfrom incident i join inc_cat c on i.inc_cat_id=c.inc_cat_id \r\njoin inc_major m on m.inc_major_id=c.inc_major_id \r\njoin inc_data d on d.incident_id=i.incident_id\r\njoin dbo.sectn_dept s ON i.sectn_dept_id=s.sectn_dept_id \r\njoin inc_prior p on p.inc_prior_id=i.inc_prior_id\r\nwhere m.inc_major_id in (17,16,4,2,3) and i.csg_id=4\r\nand datediff(day, convert(date,i.date_logged),convert(date,getdate())) <= 7\r\nand d.sub_event_type in (‘s’,‘n’)\r\ngroup by case i.inc_status when ‘o’ then ‘Open’ \r\n\t\t\t\t\t\t when ‘p’ then ‘Resloved’\r\n\t\t\t\t\t\t when ‘c’ then ‘Closed’ end \r\n "},
:info
{:executed-by 10,
:context :question,
:card-id 86,
:dashboard-id nil,
:query-hash [57, 69, -75, 19, -11, 24, 86, -106, 120, 37, 55, -70, 35, -12, -125, -14, 66, -110, 15, 66, 91, -87, 116, 71, 76, 98, -24, -91, -1, -11, 9, 49]},
:parameters [],
:async? true,
:cache-ttl 1}}

May 21 17:23:25 WARN metabase.query-processor.middleware.process-userland-query :: Query failure {:status :failed,
:class java.sql.SQLException,
:error “No suitable driver”,
:stacktrace
(“java.sql/java.sql.DriverManager.getDriver(DriverManager.java:298)”
“–> db.connection_pool$proxy_data_source.invokeStatic(connection_pool.clj:20)”
“db.connection_pool$proxy_data_source.invoke(connection_pool.clj:16)”
“db.connection_pool$unpooled_data_source.invokeStatic(connection_pool.clj:51)”
“db.connection_pool$unpooled_data_source.invoke(connection_pool.clj:49)”
“db.connection_pool$pooled_data_source.invokeStatic(connection_pool.clj:57)”
“db.connection_pool$pooled_data_source.invoke(connection_pool.clj:53)”
“driver.sql_jdbc.connection$create_pool_BANG_.invokeStatic(connection.clj:50)”
“driver.sql_jdbc.connection$create_pool_BANG_.invoke(connection.clj:43)”
“driver.sql_jdbc.connection$db__GT_pooled_connection_spec.invokeStatic(connection.clj:103)”
“driver.sql_jdbc.connection$db__GT_pooled_connection_spec.invoke(connection.clj:84)”
“driver.sql_jdbc.execute$execute_query$fn__62602.invoke(execute.clj:286)”
“driver.sql_jdbc.execute$do_with_try_catch.invokeStatic(execute.clj:216)”
“driver.sql_jdbc.execute$do_with_try_catch.invoke(execute.clj:210)”
“driver.sql_jdbc.execute$execute_query.invokeStatic(execute.clj:284)”
“driver.sql_jdbc.execute$execute_query.invoke(execute.clj:278)”
“driver.sql_jdbc$fn__62845.invokeStatic(sql_jdbc.clj:48)”
“driver.sql_jdbc$fn__62845.invoke(sql_jdbc.clj:47)”
“query_processor$fn__40384$execute_query__40389$fn__40390.invoke(query_processor.clj:61)”
“query_processor$fn__40384$execute_query__40389.invoke(query_processor.clj:55)”
“query_processor.middleware.mbql_to_native$mbql__GT_native$fn__34664.invoke(mbql_to_native.clj:36)”
“query_processor.middleware.annotate$result_rows_maps__GT_vectors$fn__32695.invoke(annotate.clj:368)”
“query_processor.middleware.annotate$add_column_info$fn__32600.invoke(annotate.clj:303)”
“query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__34144.invoke(cumulative_aggregations.clj:57)”
“query_processor.middleware.limit$limit$fn__34637.invoke(limit.clj:19)”
“query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__40249.invoke(results_metadata.clj:86)”
“query_processor.middleware.format_rows$format_rows$fn__34625.invoke(format_rows.clj:26)”
“query_processor.middleware.add_dimension_projections$add_remapping$fn__31752.invoke(add_dimension_projections.clj:234)”
“query_processor.middleware.add_row_count_and_status$add_row_count_and_status$fn__32146.invoke(add_row_count_and_status.clj:16)”
“query_processor.middleware.driver_specific$process_query_in_context$fn__34386.invoke(driver_specific.clj:12)”
“query_processor.middleware.resolve_driver$resolve_driver$fn__37215.invoke(resolve_driver.clj:15)”
“query_processor.middleware.bind_effective_timezone$bind_effective_timezone$fn__33550$fn__33551.invoke(bind_effective_timezone.clj:9)”
“util.date$call_with_effective_timezone.invokeStatic(date.clj:88)”
“util.date$call_with_effective_timezone.invoke(date.clj:77)”
“query_processor.middleware.bind_effective_timezone$bind_effective_timezone$fn__33550.invoke(bind_effective_timezone.clj:8)”
“query_processor.middleware.store$initialize_store$fn__40274$fn__40275.invoke(store.clj:11)”
“query_processor.store$do_with_new_store.invokeStatic(store.clj:35)”
“query_processor.store$do_with_new_store.invoke(store.clj:31)”
“query_processor.middleware.store$initialize_store$fn__40274.invoke(store.clj:10)”
“query_processor.middleware.async$async__GT_sync$fn__33146.invoke(async.clj:19)”
“query_processor.middleware.async_wait$runnable$fn__33277.invoke(async_wait.clj:71)”),
:query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :native,
:middleware {:userland-query? true},
:native
{:query
“\r\n–inc_prior_id\r\nselect \r\n\t\t\t–case i.inc_status when ‘o’ then ‘Open’ \r\n\t\t\t\t–\t\t when ‘p’ then ‘Resloved’\r\n\t\t\t\t\t–\t when ‘c’ then ‘Closed’ end ‘Event Status’,\r\n \r\nisnull(case when i.inc_status = ‘o’ then \r\ncase when getdate() <= i.inc_resolve_due then ‘NOT breached’ \r\n\t\twhen getdate() > i.inc_resolve_due then ‘breached’ \r\n\t\tend \r\n\t\telse \r\n case when i.inc_resolve_act <= i.inc_resolve_due then ‘NOT breached’ \r\n\t\twhen i.inc_resolve_act > i.inc_resolve_due then ‘breached’ \r\n\t\tend end ,‘Hold’) ‘SLA’ ,\r\ncount( distinct i.incident_id) ‘Number of Events’\r\nfrom incident i join inc_cat c on i.inc_cat_id=c.inc_cat_id \r\njoin inc_major m on m.inc_major_id=c.inc_major_id \r\njoin inc_data d on d.incident_id=i.incident_id\r\njoin dbo.sectn_dept s ON i.sectn_dept_id=s.sectn_dept_id \r\njoin inc_prior p on p.inc_prior_id=i.inc_prior_id\r\nwhere m.inc_major_id in (17,16,4,2,3) and i.csg_id=4\r\nand datediff(day, convert(date,i.date_logged),convert(date,getdate())) <= 7\r\n–convert(date,i.date_logged)=convert(date,getdate())\r\n–convert(date,i.date_logged)>=‘2018-10-16’\r\nand d.sub_event_type in (‘s’,‘n’)\r\n\r\n\r\ngroup by \r\n–case i.inc_status when ‘o’ then ‘Open’ \r\n\t–\t\t\t\t\t when ‘p’ then ‘Resloved’\r\n\t\t–\t\t\t\t when ‘c’ then ‘Closed’ end,\r\n\t\tisnull(case when i.inc_status = ‘o’ then \r\ncase when getdate() <= i.inc_resolve_due then ‘NOT breached’ \r\n\t\twhen getdate() > i.inc_resolve_due then ‘breached’ \r\n\t\tend \r\n\t\telse \r\n case when i.inc_resolve_act <= i.inc_resolve_due then ‘NOT breached’ \r\n\t\twhen i.inc_resolve_act > i.inc_resolve_due then ‘breached’ \r\n\t\tend end ,‘Hold’)”},
:info
{:executed-by 10,
:context :question,
:card-id 87,
:dashboard-id nil,
:query-hash [-8, -12, -32, -46, 84, -108, 113, -30, 99, 95, 85, -11, -56, 8, -31, -65, 72, -122, -29, 45, -35, 108, 41, 58, -118, -58, -66, 118, 113, 98, 65, 103]},
:parameters [],
:async? true,
:cache-ttl 1}}

…

7

@faresalokeeli
Do you see the warning for all queries or is it only Native Query (SQL) where the query starts with \r\n--inc_prior_id\r\n ?

8

we did not see same warning for all queries
may for this query only