[bf21ac52-c5c9-4b16-8e4b-1277f9583e6f] 2020-10-12T21:38:13+08:00 DEBUG metabase.middleware.log POST /api/card/68/query 202 [ASYNC: completed] 287.9 ms (11 DB calls) Jetty threads: 4/50 (2 idle, 0 queued) (84 total active threads) Queries in flight: 0
[bf21ac52-c5c9-4b16-8e4b-1277f9583e6f] 2020-10-12T21:38:22+08:00 DEBUG metabase.middleware.log POST /api/card/68/query 202 [ASYNC: completed] 649.9 ms (14 DB calls) Jetty threads: 4/50 (2 idle, 0 queued) (84 total active threads) Queries in flight: 0
[bf21ac52-c5c9-4b16-8e4b-1277f9583e6f] 2020-10-12T21:38:43+08:00 WARN metabase.query-processor.middleware.process-userland-query 查询失败 {:status :failed,
:class clojure.lang.ExceptionInfo,
:error “没有运行查询的权限”,
:stacktrace
("–> query_processor.middleware.permissions$perms_exception.invokeStatic(permissions.clj:23)"
“query_processor.middleware.permissions$perms_exception.invoke(permissions.clj:22)”
“query_processor.middleware.permissions$fn__42821$check_ad_hoc_query_perms__42826$fn__42827.invoke(permissions.clj:32)”
“query_processor.middleware.permissions$fn__42821$check_ad_hoc_query_perms__42826.invoke(permissions.clj:28)”
“query_processor.middleware.permissions$fn__42844$check_query_permissions_STAR___42849$fn__42855.invoke(permissions.clj:40)”
“query_processor.middleware.permissions$fn__42844$check_query_permissions_STAR___42849.invoke(permissions.clj:34)”
“query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__41503.invoke(cumulative_aggregations.clj:57)”
“query_processor.middleware.resolve_joins$resolve_joins$fn__43430.invoke(resolve_joins.clj:184)”
“query_processor.middleware.limit$limit$fn__42138.invoke(limit.clj:19)”
“query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__46195.invoke(results_metadata.clj:87)”
“query_processor.middleware.format_rows$format_rows$fn__42126.invoke(format_rows.clj:76)”
“query_processor.middleware.add_dimension_projections$add_remapping$fn__38215.invoke(add_dimension_projections.clj:232)”
“query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__38866.invoke(add_source_metadata.clj:107)”
“query_processor.middleware.resolve_source_table$resolve_source_tables$fn__43480.invoke(resolve_source_table.clj:46)”
“query_processor.middleware.add_row_count_and_status$add_row_count_and_status$fn__38703.invoke(add_row_count_and_status.clj:16)”
“query_processor.middleware.driver_specific$process_query_in_context$fn__41578.invoke(driver_specific.clj:12)”
“query_processor.middleware.resolve_driver$resolve_driver$fn__43094.invoke(resolve_driver.clj:22)”
“query_processor.middleware.store$initialize_store$fn__46220$fn__46221.invoke(store.clj:11)”
“query_processor.store$do_with_store.invokeStatic(store.clj:46)”
“query_processor.store$do_with_store.invoke(store.clj:40)”
“query_processor.middleware.store$initialize_store$fn__46220.invoke(store.clj:10)”
“query_processor.middleware.async$async__GT_sync$fn__37366.invoke(async.clj:23)”
“query_processor.middleware.async_wait$runnable$fn__40619.invoke(async_wait.clj:89)”),
:query
{:type “native”,
:middleware {:userland-query? true, :skip-results-metadata? true},
:native
{:query
“select * from mb_qa_result\nwhere [[{{work_date}}–]] 工作日期 >= date_trunc(‘month’, current_date)::DATE “,
:template-tags {:work_date {:id “fd0d9399-f284-23fa-4e95-0e426ea98849”, :name “work_date”, :display-name “工作日期”, :type “dimension”, :dimension [“field-id” 18676], :widget-type “date/range”}}},
:parameters [{:type “date/range”, :target [“dimension” [“template-tag” “work_date”]], :value “2020-09-01~2020-09-10”}],
:async? true,
:cache-ttl nil,
:info
{:executed-by 22,
:context :xlsx-download,
:query-hash [29, 33, 96, 98, 33, 7, -79, -46, 94, 68, -78, -82, 30, 61, 7, 59, 83, 91, 32, -7, -33, 107, -82, -122, 63, 122, -98, 39, 65, -121, -56, 90]}},
:ex-data
{:required-permissions #{”/db/3/native/”},
:actual-permissions
#{"/collection/20/read/" “/db/3/schema/public/table/1816/” “/collection/55/read/” “/db/3/schema/public/table/1739/” “/collection/26/” “/collection/10/read/” “/db/3/schema/public/table/1820/”
“/db/3/schema/public/table/1817/” “/db/3/schema/public/table/1846/” “/db/3/schema/public/table/1845/” “/db/3/schema/public/table/1783/” “/db/3/schema/public/table/636/”
“/db/3/schema/public/table/1743/” “/db/3/schema/public/table/1821/” “/collection/54/read/” “/collection/42/read/” “/db/3/schema/public/table/1776/” “/db/3/schema/public/table/1781/”
“/db/3/schema/public/table/1779/” “/db/3/schema/public/table/1792/” “/db/3/schema/public/table/1793/” “/db/3/schema/public/table/1818/” “/db/3/schema/public/table/1819/”
“/db/3/schema/public/table/1780/” “/db/3/schema/public/table/563/” “/collection/11/read/” “/db/3/schema/public/table/1741/” “/collection/29/read/” “/collection/68/read/”
“/db/3/schema/public/table/1785/” “/db/3/schema/public/table/1844/” “/db/3/schema/public/table/1782/” “/db/3/schema/public/table/1786/”},
:permissions-error? true}}
[bf21ac52-c5c9-4b16-8e4b-1277f9583e6f] 2020-10-12T21:38:43+08:00 DEBUG metabase.middleware.log POST /api/dataset/xlsx 400 108.4 ms (12 DB calls)
“没有运行查询的权限”
“没有运行查询的权限” means “no permissions to run query”
it required {"/db/3/native/"} permission