You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "OskarSorensen (via GitHub)" <gi...@apache.org> on 2023/05/22 12:15:31 UTC
[GitHub] [superset] OskarSorensen opened a new issue, #24171: Fatal error when fetching data from cache using a Guest Token with RLS
OskarSorensen opened a new issue, #24171:
URL: https://github.com/apache/superset/issues/24171
#### How to reproduce the bug
With GLOBAL_ASYNC_QUERIES enabled view an embedded dashboard with the `superset-ui/embedded-sdk` NPM package using a guest token. When Superset has finished processing the queries and notifies the frontend to go fetch the specific cache key (`api/v1/chart/data/{cache_key}`) a fatal error and a HTTP 422 Unprocessable Entity is returned instead. After some experimentation I've found out that this only happens if a RLS clause has been added to the quest token. It seems like the presence of an RLS clause causes this - even if the clause is simply `1 = 1`. If a guest token without RLS is used then it works as expected.
### Expected results
That the request with the guest token containing an RLS clause can successfully fetch data from `api/v1/chart/data/{cache_key}`
### Actual results
Fatal error and HTTP 422 Unprocessable Entity
### Environment
- browser type and version: `Chrome 113.0.5672.127`
- superset version: `2.1.0`
- python version: (docker)
- node.js version: (docker)
- any feature flags active: `ENABLE_TEMPLATE_PROCESSING, DASHBOARD_RBAC, DASHBOARD_CROSS_FILTERS, EMBEDDED_SUPERSET, DRILL_TO_DETAIL, DASHBOARD_NATIVE_FILTERS, HORIZONTAL_FILTER_BAR, GLOBAL_ASYNC_QUERIES, GLOBAL_ASYNC_QUERIES_TRANSPORT = "polling"`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Fatal error when fetching data from cache using a Guest Token with RLS [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #24171:
URL: https://github.com/apache/superset/issues/24171#issuecomment-2059476253
Seems this was resolved in 3.1. Closing!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Fatal error when fetching data from cache using a Guest Token with RLS [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #24171:
URL: https://github.com/apache/superset/issues/24171#issuecomment-1973598836
The related PR seems stuck, but hopefully we can get that picked back up. If anyone else wants to adopt it, that's fine too. Otherwise we may close this issue as stale at some point.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] Ben-Vencill commented on issue #24171: Fatal error when fetching data from cache using a Guest Token with RLS
Posted by "Ben-Vencill (via GitHub)" <gi...@apache.org>.
Ben-Vencill commented on issue #24171:
URL: https://github.com/apache/superset/issues/24171#issuecomment-1570655305
I have replicated these steps and get the following result when `GLOBAL_ASYNC_QUERIES` is enabled:
- `api/v1/chart/data/{cache_key}` returns 422 Unprocessable Entity
- `/superset/explore_json/data/{cache_key}` returns 400 Bad Request
- `api/v1/chart/{chart_id}` returns 404 Not Found
I see none of these errors when making the same calls on the deployment when `GLOBAL_ASYNC_QUERIES` feature flag is not enabled.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Fatal error when fetching data from cache using a Guest Token with RLS [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #24171: Fatal error when fetching data from cache using a Guest Token with RLS
URL: https://github.com/apache/superset/issues/24171
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] OskarSorensen commented on issue #24171: Fatal error when fetching data from cache using a Guest Token with RLS
Posted by "OskarSorensen (via GitHub)" <gi...@apache.org>.
OskarSorensen commented on issue #24171:
URL: https://github.com/apache/superset/issues/24171#issuecomment-1559314630
Could this possibly be related to the fix this stale PR contains? https://github.com/apache/superset/pull/18924/files
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] OskarSorensen commented on issue #24171: Fatal error when fetching data from cache using a Guest Token with RLS
Posted by "OskarSorensen (via GitHub)" <gi...@apache.org>.
OskarSorensen commented on issue #24171:
URL: https://github.com/apache/superset/issues/24171#issuecomment-1559309042
and I have just confirmed that this is an issue that is experienced by others than just me https://apache-superset.slack.com/archives/C01EP56QGTS/p1676555390391469
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org