Hello,
I am trying to run a native query on a postgresql database. The moment I hit the execute statement button, I get the screen "Sorry, you do not have permissions to see that."
Here is the logs:
{:database_id 34,
:started_at #t "2023-04-28T17:38:57.864557Z[GMT]",
:via
[{:status :failed,
:class clojure.lang.ExceptionInfo,
:error "Error executing query: ERROR: canceling statement due to user request",
:stacktrace
["--> driver.sql_jdbc.execute$execute_reducible_query$fn__55245.invoke(execute.clj:502)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:499)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:494)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
"driver.sql_jdbc$fn__86207.invokeStatic(sql_jdbc.clj:54)"
"driver.sql_jdbc$fn__86207.invoke(sql_jdbc.clj:52)"
"query_processor.context$executef.invokeStatic(context.clj:59)"
"query_processor.context$executef.invoke(context.clj:48)"
"query_processor.context.default$default_runf.invokeStatic(default.clj:67)"
"query_processor.context.default$default_runf.invoke(default.clj:65)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)"
"query_processor.reducible$identity_qp.invoke(reducible.clj:9)"
"query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___52622.invoke(cache.clj:220)"
"query_processor.middleware.permissions$check_query_permissions$fn__48143.invoke(permissions.clj:109)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__51567.invoke(mbql_to_native.clj:23)"
"query_processor$fn__54098$combined_post_process__54103$combined_post_process_STAR___54104.invoke(query_processor.clj:212)"
"query_processor$fn__54098$combined_pre_process__54099$combined_pre_process_STAR___54100.invoke(query_processor.clj:209)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52543$fn__52548.invoke(resolve_database_and_driver.clj:35)"
"driver$do_with_driver.invokeStatic(driver.clj:75)"
"driver$do_with_driver.invoke(driver.clj:71)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52543.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__48578.invoke(fetch_source_query.clj:353)"
"query_processor.middleware.store$initialize_store$fn__48766$fn__48767.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:44)"
"query_processor.store$do_with_store.invoke(store.clj:38)"
"query_processor.middleware.store$initialize_store$fn__48766.invoke(store.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__52815.invoke(normalize_query.clj:22)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__49848.invoke(constraints.clj:53)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__52754.invoke(process_userland_query.clj:145)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__53126.invoke(catch_exceptions.clj:167)"
"query_processor.reducible$async_qp$qp_STAR___44981$thunk__44983.invoke(reducible.clj:100)"
"query_processor.reducible$async_qp$qp_STAR___44981.invoke(reducible.clj:106)"
"query_processor.reducible$async_qp$qp_STAR___44981.invoke(reducible.clj:91)"
"query_processor.reducible$sync_qp$qp_STAR___44992.doInvoke(reducible.clj:126)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:331)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:327)"
"query_processor$fn__54145$process_query_and_save_execution_BANG___54154$fn__54157.invoke(query_processor.clj:342)"
"query_processor$fn__54145$process_query_and_save_execution_BANG___54154.invoke(query_processor.clj:335)"
"query_processor$fn__54189$process_query_and_save_with_max_results_constraints_BANG___54198$fn__54201.invoke(query_processor.clj:354)"
"query_processor$fn__54189$process_query_and_save_with_max_results_constraints_BANG___54198.invoke(query_processor.clj:347)"
"api.dataset$run_query_async$fn__68895.invoke(dataset.clj:69)"
"query_processor.streaming$streaming_response_STAR_$fn__40099$fn__40100.invoke(streaming.clj:162)"
"query_processor.streaming$streaming_response_STAR_$fn__40099.invoke(streaming.clj:161)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:65)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:63)"
"async.streaming_response$do_f_async$task__19006.invoke(streaming_response.clj:84)"],
:error_type :invalid-query,
:ex-data
{:sql
"-- Metabase:: userID: 1 queryType: MBQL queryHash: f5a17da4ec86e6fecd0381b28a18065c3332c94f78421603a40c2c85a06d7e04\nSELECT (CAST(date_trunc('week', (\"public\".\"enabled_quests\".\"updated_at\" + (INTERVAL '1 day'))) AS timestamp) + (INTERVAL '-1 day')) AS \"updated_at\" FROM \"public\".\"enabled_quests\" LEFT JOIN \"public\".\"enabled_user_quests\" \"Enabled User Quests\" ON \"public\".\"enabled_quests\".\"id\" = \"Enabled User Quests\".\"quest_id\" WHERE (\"Enabled User Quests\".\"status\" = ? AND \"public\".\"enabled_quests\".\"enabled\" = TRUE) GROUP BY (CAST(date_trunc('week', (\"public\".\"enabled_quests\".\"updated_at\" + (INTERVAL '1 day'))) AS timestamp) + (INTERVAL '-1 day')) ORDER BY (CAST(date_trunc('week', (\"public\".\"enabled_quests\".\"updated_at\" + (INTERVAL '1 day'))) AS timestamp) + (INTERVAL '-1 day')) ASC LIMIT 2000",
:params ("CLAIMED"),
:type :invalid-query}}],
:state "57014",
:error_type :invalid-query,
:json_query
{:database 34,
:query
{:source-table 185,
:joins
[{:fields "all",
:source-table 205,
:condition ["=" ["field" 1876 nil] ["field" 2196 {:join-alias "Enabled User Quests"}]],
:alias "Enabled User Quests"}],
:filter ["and" ["=" ["field" 2192 {:join-alias "Enabled User Quests"}] "CLAIMED"] ["=" ["field" 1881 nil] true]],
:breakout [["field" 1874 {:temporal-unit "week"}]]},
:type "query",
:parameters [],
:middleware {:js-int-to-string? true, :add-default-userland-constraints? true}},
:native
{:query
"SELECT (CAST(date_trunc('week', (\"public\".\"enabled_quests\".\"updated_at\" + (INTERVAL '1 day'))) AS timestamp) + (INTERVAL '-1 day')) AS \"updated_at\" FROM \"public\".\"enabled_quests\" LEFT JOIN \"public\".\"enabled_user_quests\" \"Enabled User Quests\" ON \"public\".\"enabled_quests\".\"id\" = \"Enabled User Quests\".\"quest_id\" WHERE (\"Enabled User Quests\".\"status\" = ? AND \"public\".\"enabled_quests\".\"enabled\" = TRUE) GROUP BY (CAST(date_trunc('week', (\"public\".\"enabled_quests\".\"updated_at\" + (INTERVAL '1 day'))) AS timestamp) + (INTERVAL '-1 day')) ORDER BY (CAST(date_trunc('week', (\"public\".\"enabled_quests\".\"updated_at\" + (INTERVAL '1 day'))) AS timestamp) + (INTERVAL '-1 day')) ASC LIMIT 1048575",
:params ("CLAIMED")},
:status :failed,
:class org.postgresql.util.PSQLException,
:stacktrace
["org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676)"
"org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366)"
"org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356)"
"org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496)"
"org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413)"
"org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190)"
"org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:134)"
"com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1471)"
"--> driver.sql_jdbc.execute$fn__55163.invokeStatic(execute.clj:363)"
"driver.sql_jdbc.execute$fn__55163.invoke(execute.clj:361)"
"driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:376)"
"driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invoke(execute.clj:372)"
"driver.sql_jdbc.execute$execute_reducible_query$fn__55245.invoke(execute.clj:500)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:499)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:494)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
"driver.sql_jdbc$fn__86207.invokeStatic(sql_jdbc.clj:54)"
"driver.sql_jdbc$fn__86207.invoke(sql_jdbc.clj:52)"
"query_processor.context$executef.invokeStatic(context.clj:59)"
"query_processor.context$executef.invoke(context.clj:48)"
"query_processor.context.default$default_runf.invokeStatic(default.clj:67)"
"query_processor.context.default$default_runf.invoke(default.clj:65)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)"
"query_processor.reducible$identity_qp.invoke(reducible.clj:9)"
"query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___52622.invoke(cache.clj:220)"
"query_processor.middleware.permissions$check_query_permissions$fn__48143.invoke(permissions.clj:109)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__51567.invoke(mbql_to_native.clj:23)"
"query_processor$fn__54098$combined_post_process__54103$combined_post_process_STAR___54104.invoke(query_processor.clj:212)"
"query_processor$fn__54098$combined_pre_process__54099$combined_pre_process_STAR___54100.invoke(query_processor.clj:209)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52543$fn__52548.invoke(resolve_database_and_driver.clj:35)"
"driver$do_with_driver.invokeStatic(driver.clj:75)"
"driver$do_with_driver.invoke(driver.clj:71)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52543.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__48578.invoke(fetch_source_query.clj:353)"
"query_processor.middleware.store$initialize_store$fn__48766$fn__48767.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:44)"
"query_processor.store$do_with_store.invoke(store.clj:38)"
"query_processor.middleware.store$initialize_store$fn__48766.invoke(store.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__52815.invoke(normalize_query.clj:22)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__49848.invoke(constraints.clj:53)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__52754.invoke(process_userland_query.clj:145)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__53126.invoke(catch_exceptions.clj:167)"
"query_processor.reducible$async_qp$qp_STAR___44981$thunk__44983.invoke(reducible.clj:100)"
"query_processor.reducible$async_qp$qp_STAR___44981.invoke(reducible.clj:106)"
"query_processor.reducible$async_qp$qp_STAR___44981.invoke(reducible.clj:91)"
"query_processor.reducible$sync_qp$qp_STAR___44992.doInvoke(reducible.clj:126)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:331)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:327)"
"query_processor$fn__54145$process_query_and_save_execution_BANG___54154$fn__54157.invoke(query_processor.clj:342)"
"query_processor$fn__54145$process_query_and_save_execution_BANG___54154.invoke(query_processor.clj:335)"
"query_processor$fn__54189$process_query_and_save_with_max_results_constraints_BANG___54198$fn__54201.invoke(query_processor.clj:354)"
"query_processor$fn__54189$process_query_and_save_with_max_results_constraints_BANG___54198.invoke(query_processor.clj:347)"
"api.dataset$run_query_async$fn__68895.invoke(dataset.clj:69)"
"query_processor.streaming$streaming_response_STAR_$fn__40099$fn__40100.invoke(streaming.clj:162)"
"query_processor.streaming$streaming_response_STAR_$fn__40099.invoke(streaming.clj:161)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:65)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:63)"
"async.streaming_response$do_f_async$task__19006.invoke(streaming_response.clj:84)"],
:card_id nil,
:context :ad-hoc,
:error "ERROR: canceling statement due to user request",
:row_count 0,
:running_time 0,
:preprocessed
{:database 34,
:query
{:source-table 185,
:filter
[:and
[:=
[:field 2192 {:join-alias "Enabled User Quests"}]
[:value
"CLAIMED"
{:base_type :type/Text,
:effective_type :type/Text,
:coercion_strategy nil,
:semantic_type :type/Category,
:database_type "varchar",
:name "status"}]]
[:=
[:field 1881 nil]
[:value
true
{:base_type :type/Boolean,
:effective_type :type/Boolean,
:coercion_strategy nil,
:semantic_type :type/Category,
:database_type "bool",
:name "enabled"}]]],
:breakout [[:field 1874 {:temporal-unit :week}]],
:order-by [[:asc [:field 1874 {:temporal-unit :week}]]],
:joins
[{:alias "Enabled User Quests",
:strategy :left-join,
:fields
[[:field 2190 {:join-alias "Enabled User Quests"}]
[:field 2189 {:temporal-unit :default, :join-alias "Enabled User Quests"}]
[:field 2196 {:join-alias "Enabled User Quests"}]
[:field 2195 {:temporal-unit :default, :join-alias "Enabled User Quests"}]
[:field 2194 {:temporal-unit :default, :join-alias "Enabled User Quests"}]
[:field 2192 {:join-alias "Enabled User Quests"}]
[:field 2191 {:join-alias "Enabled User Quests"}]
[:field 2193 {:join-alias "Enabled User Quests"}]],
:source-table 205,
:condition [:= [:field 1876 nil] [:field 2196 {:join-alias "Enabled User Quests"}]]}],
:limit 1048575,
:metabase.query-processor.middleware.limit/original-limit nil},
:type :query,
:middleware {:js-int-to-string? true, :add-default-userland-constraints? true},
:info {:executed-by 1, :context :ad-hoc}},
:data {:rows [], :cols []}}
any idea why this is happening? I'm the admin by the way