The user cannot save questions in a collection to which he has access

Bug reports
1

The user cannot save questions in a collection to which he has access.
You can view the collection, but you cannot save questions
This same user has access to the database and the table where he created the question.
Would you help me?

image
image1250Ă—476 17.7 KB

image
image1814Ă—255 9.78 KB

image
image715Ă—408 9.83 KB

2

Hi @brunasiq
Please post “Diagnostic Info” from Admin > Troubleshooting.
Are “LEGAL” and “Zion” sub-collections of another collection, which the user does not have access to?
https://github.com/metabase/metabase/issues/14052 - upvote by clicking :+1: on the first post

1 Like
3

Yes. They are “LEGAL” and “Zion” sub-collections from another collection, to which the user does not have access. We have not found how to give access to the entire collection.

[03eb0ea2-6072-4776-92cd-0dfa8bb021ca] 2020-12-16T15:26:57-03:00 ERROR metabase.public-settings.metastore Erro validando token: Houve um erro na checagem se esse token era válido Server returned HTTP response code: 403 for URL: https://store.metabase.com/api/71cb0d951e3dcdc00ad321283816ddc88ea43251fe819ff03bd8687084778a1c/v2/status
[03eb0ea2-6072-4776-92cd-0dfa8bb021ca] 2020-12-16T15:26:57-03:00 DEBUG metabase.middleware.log GET /api/session/properties 200 11,8 ms (2 DB calls) App DB connections: 0/13 Jetty threads: 3/50 (4 idle, 0 queued) (99 total active threads) Queries in flight: 0 (0 queued)
[03eb0ea2-6072-4776-92cd-0dfa8bb021ca] 2020-12-16T15:27:57-03:00 DEBUG metabase.middleware.log GET /api/search 200 280,8 ms (3 DB calls) App DB connections: 0/13 Jetty threads: 3/50 (4 idle, 0 queued) (96 total active threads) Queries in flight: 0 (0 queued)
[03eb0ea2-6072-4776-92cd-0dfa8bb021ca] 2020-12-16T15:27:59-03:00 DEBUG metabase.middleware.log GET /api/collection/5 200 14,6 ms (3 DB calls) App DB connections: 0/13 Jetty threads: 3/50 (4 idle, 0 queued) (96 total active threads) Queries in flight: 0 (0 queued)
[03eb0ea2-6072-4776-92cd-0dfa8bb021ca] 2020-12-16T15:27:59-03:00 DEBUG metabase.middleware.log GET /api/collection/5/items 200 53,6 ms (8 DB calls) App DB connections: 0/13 Jetty threads: 3/50 (4 idle, 0 queued) (96 total active threads) Queries in flight: 0 (0 queued)
[03eb0ea2-6072-4776-92cd-0dfa8bb021ca] 2020-12-16T15:28:07-03:00 DEBUG metabase.middleware.log POST /api/collection 200 39,2 ms (8 DB calls) App DB connections: 0/13 Jetty threads: 3/50 (4 idle, 0 queued) (97 total active threads) Queries in flight: 0 (0 queued)
[03eb0ea2-6072-4776-92cd-0dfa8bb021ca] 2020-12-16T15:28:08-03:00 DEBUG metabase.middleware.log GET /api/collection/5/items 200 46,6 ms (8 DB calls) App DB connections: 0/13 Jetty threads: 3/50 (4 idle, 0 queued) (97 total active threads) Queries in flight: 0 (0 queued)
[03eb0ea2-6072-4776-92cd-0dfa8bb021ca] 2020-12-16T15:28:16-03:00 DEBUG metabase.middleware.log GET /api/collection 200 20,4 ms (3 DB calls) App DB connections: 0/13 Jetty threads: 3/50 (4 idle, 0 queued) (97 total active threads) Queries in flight: 0 (0 queued)
[03eb0ea2-6072-4776-92cd-0dfa8bb021ca] 2020-12-16T15:28:45-03:00 INFO metabase.public-settings.metastore Checando com o MetaStore para ver se 71cb0d951e3dcdc00ad321283816ddc88ea43251fe819ff03bd8687084778a1c é válido...
[03eb0ea2-6072-4776-92cd-0dfa8bb021ca] 2020-12-16T15:28:45-03:00 ERROR metabase.public-settings.metastore Erro ao carregar o status do token:
[03eb0ea2-6072-4776-92cd-0dfa8bb021ca] 2020-12-16T15:28:45-03:00 ERROR metabase.public-settings.metastore Erro validando token: Houve um erro na checagem se esse token era válido Server returned HTTP response code: 403 for URL: https://store.metabase.com/api/71cb0d951e3dcdc00ad321283816ddc88ea43251fe819ff03bd8687084778a1c/v2/status
[03eb0ea2-6072-4776-92cd-0dfa8bb021ca] 2020-12-16T15:28:47-03:00 DEBUG metabase.middleware.log GET /api/user/current 200 33,9 ms (3 DB calls) App DB connections: 0/13 Jetty threads: 3/50 (4 idle, 0 queued) (97 total active threads) Queries in flight: 0 (0 queued)
[ad43987a-45c8-4dc9-8c71-8d4a358144ed] 2020-12-16T15:28:47-03:00 INFO metabase.public-settings.metastore Checando com o MetaStore para ver se 71cb0d951e3dcdc00ad321283816ddc88ea43251fe819ff03bd8687084778a1c é válido...
[ad43987a-45c8-4dc9-8c71-8d4a358144ed] 2020-12-16T15:28:47-03:00 ERROR metabase.public-settings.metastore Erro ao carregar o status do token:
[ad43987a-45c8-4dc9-8c71-8d4a358144ed] 2020-12-16T15:28:47-03:00 ERROR metabase.public-settings.metastore Erro validando token: Houve um erro na checagem se esse token era válido Server returned HTTP response code: 403 for URL: https://store.metabase.com/api/71cb0d951e3dcdc00ad321283816ddc88ea43251fe819ff03bd8687084778a1c/v2/status
[ad43987a-45c8-4dc9-8c71-8d4a358144ed] 2020-12-16T15:28:47-03:00 DEBUG metabase.middleware.log GET /api/session/properties 200 58,9 ms (2 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (104 total active threads) Queries in flight: 0 (0 queued)
[03eb0ea2-6072-4776-92cd-0dfa8bb021ca] 2020-12-16T15:28:47-03:00 DEBUG metabase.middleware.log GET /api/database 200 30,0 ms (3 DB calls) App DB connections: 0/13 Jetty threads: 3/50 (4 idle, 0 queued) (97 total active threads) Queries in flight: 0 (0 queued)
[03eb0ea2-6072-4776-92cd-0dfa8bb021ca] 2020-12-16T15:28:59-03:00 DEBUG metabase.middleware.log GET /api/database/4/schema/payment_slip 200 15,4 ms (5 DB calls) App DB connections: 0/13 Jetty threads: 3/50 (4 idle, 0 queued) (97 total active threads) Queries in flight: 0 (0 queued)
[03eb0ea2-6072-4776-92cd-0dfa8bb021ca] 2020-12-16T15:29:00-03:00 DEBUG metabase.middleware.log GET /api/table/182/query_metadata 200 66,8 ms (11 DB calls) App DB connections: 0/13 Jetty threads: 3/50 (4 idle, 0 queued) (97 total active threads) Queries in flight: 0 (0 queued)
[03eb0ea2-6072-4776-92cd-0dfa8bb021ca] 2020-12-16T15:29:00-03:00 DEBUG metabase.middleware.log GET /api/table/223/query_metadata 200 33,9 ms (8 DB calls) App DB connections: 0/13 Jetty threads: 3/50 (4 idle, 0 queued) (97 total active threads) Queries in flight: 0 (0 queued)
[03eb0ea2-6072-4776-92cd-0dfa8bb021ca] 2020-12-16T15:29:00-03:00 DEBUG metabase.middleware.log GET /api/table/181/query_metadata 200 32,4 ms (8 DB calls) App DB connections: 0/13 Jetty threads: 3/50 (4 idle, 0 queued) (97 total active threads) Queries in flight: 0 (0 queued)
[03eb0ea2-6072-4776-92cd-0dfa8bb021ca] 2020-12-16T15:29:02-03:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 966,0 ms (11 DB calls) App DB connections: 1/13 Jetty threads: 2/50 (5 idle, 0 queued) (98 total active threads) Queries in flight: 0 (0 queued)
[ad43987a-45c8-4dc9-8c71-8d4a358144ed] 2020-12-16T15:29:13-03:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 1,2 s (12 DB calls) App DB connections: 1/4 Jetty threads: 2/50 (5 idle, 0 queued) (107 total active threads) Queries in flight: 0 (0 queued)
[ad43987a-45c8-4dc9-8c71-8d4a358144ed] 2020-12-16T15:29:16-03:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 796,5 ms (11 DB calls) App DB connections: 1/4 Jetty threads: 2/50 (5 idle, 0 queued) (108 total active threads) Queries in flight: 1 (0 queued)
[ad43987a-45c8-4dc9-8c71-8d4a358144ed] 2020-12-16T15:29:21-03:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 210,7 ms (11 DB calls) App DB connections: 1/4 Jetty threads: 2/50 (5 idle, 0 queued) (109 total active threads) Queries in flight: 1 (0 queued)
[ad43987a-45c8-4dc9-8c71-8d4a358144ed] 2020-12-16T15:29:29-03:00 DEBUG metabase.middleware.log GET /api/database/4/schema/billet 200 15,0 ms (4 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (109 total active threads) Queries in flight: 0 (0 queued)
[ad43987a-45c8-4dc9-8c71-8d4a358144ed] 2020-12-16T15:29:30-03:00 DEBUG metabase.middleware.log GET /api/table/55/query_metadata 200 33,5 ms (9 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (109 total active threads) Queries in flight: 0 (0 queued)
[ad43987a-45c8-4dc9-8c71-8d4a358144ed] 2020-12-16T15:29:30-03:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 446,2 ms (11 DB calls) App DB connections: 1/4 Jetty threads: 2/50 (5 idle, 0 queued) (110 total active threads) Queries in flight: 0 (0 queued)
[03eb0ea2-6072-4776-92cd-0dfa8bb021ca] 2020-12-16T15:29:41-03:00 ERROR metabase.public-settings.metastore Erro validando token: Houve um erro na checagem se esse token era válido Server returned HTTP response code: 403 for URL: https://store.metabase.com/api/71cb0d951e3dcdc00ad321283816ddc88ea43251fe819ff03bd8687084778a1c/v2/status
[03eb0ea2-6072-4776-92cd-0dfa8bb021ca] 2020-12-16T15:29:41-03:00 WARN metabase.routes.index Locale 'en' not found.
[ad43987a-45c8-4dc9-8c71-8d4a358144ed] 2020-12-16T15:29:44-03:00 DEBUG metabase.middleware.log GET /api/user/current 200 11,3 ms (3 DB calls) App DB connections: 1/4 Jetty threads: 3/50 (4 idle, 0 queued) (110 total active threads) Queries in flight: 0 (0 queued)
[ad43987a-45c8-4dc9-8c71-8d4a358144ed] 2020-12-16T15:29:45-03:00 DEBUG metabase.middleware.log GET /api/database 200 29,5 ms (4 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (110 total active threads) Queries in flight: 0 (0 queued)
[ad43987a-45c8-4dc9-8c71-8d4a358144ed] 2020-12-16T15:29:45-03:00 INFO metabase.api.card Question's average execution duration is 889,0 ms; using 'magic' TTL of 9,0 s đź’ľ
[03eb0ea2-6072-4776-92cd-0dfa8bb021ca] 2020-12-16T15:29:45-03:00 INFO metabase.api.card Question's average execution duration is 874,0 ms; using 'magic' TTL of 9,0 s đź’ľ
[ad43987a-45c8-4dc9-8c71-8d4a358144ed] 2020-12-16T15:29:45-03:00 INFO metabase.api.card Question's average execution duration is 892,0 ms; using 'magic' TTL of 9,0 s