We are experiencing query failures and data source connection issues while we didn’t make any change on our side.
A summary of the issue and the browser/OS environment in which it occurs.
Technical details:
From our log, it seems that redash is having trouble recognizing data sources connections, and the error almost looks like a bug from the code. However, it has been working fine since yesterday. I have attached the log below. The consequence of it is we can not run any query at the moment since there is no connected data source at all.
Any help is greatly appreciated !!
Traceback (most recent call last): File “/usr/local/lib/python2.7/site-packages/flask/app.py”, line 1612, in full_dispatch_request rv = self.dispatch_request() File “/usr/local/lib/python2.7/site-packages/flask/app.py”, line 1598, in dispatch_request return self.view_functionsrule.endpoint File “/usr/local/lib/python2.7/site-packages/flask_restful/init.py”, line 477, in wrapper resp = resource(*args, **kwargs) File “/usr/local/lib/python2.7/site-packages/flask_login/utils.py”, line 228, in decorated_view return func(*args, **kwargs) File “/usr/local/lib/python2.7/site-packages/flask/views.py”, line 84, in view return self.dispatch_request(*args, **kwargs) File “/app/redash/handlers/base.py”, line 31, in dispatch_request return super(BaseResource, self).dispatch_request(*args, **kwargs) File “/usr/local/lib/python2.7/site-packages/flask_restful/init.py”, line 587, in dispatch_request resp = meth(*args, **kwargs) File “/app/redash/permissions.py”, line 67, in decorated return fn(*args, **kwargs) File “/app/redash/handlers/dashboards.py”, line 150, in get response = serialize_dashboard(dashboard, with_widgets=True, user=self.current_user) File “/app/redash/serializers/init.py”, line 198, in serialize_dashboard elif user and has_access(w.visualization.query_rel, user, view_only): File “/app/redash/permissions.py”, line 21, in has_access return has_access_to_groups(obj, user, need_view_only) File “/app/redash/permissions.py”, line 40, in has_access_to_groups matching_groups = set(groups.keys()).intersection(user.group_ids) AttributeError: ‘Query’ object has no attribute ‘keys’ [2021-03-25 14:38:15,065][PID:165][INFO][metrics] method=GET path=/api/dashboards/closed-cards endpoint=dashboard status=500 content_type=application/json content_length=36 duration=12.96 query_count=9 query_duration=9.52 52.2.58.218 - - [25/Mar/2021:14:38:15 +0000] “GET /api/dashboards/closed-cards HTTP/1.1” 500 36 “https://redash.production.petalcard.com/dashboard/closed-cards” “Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36” Did not receive identification string from 10.1.137.182 port 44406 [2021-03-25 14:38:15 +0000] [153] [DEBUG] GET /api/dashboards/closed-cards [2021-03-25 14:38:15,152] ERROR in app: Exception on /api/dashboards/closed-cards [GET]
- Redash Version: 8.0.0.b32245
- Browser/OS: Google Chrome
- How did you install Redash: Self hosted redash with docker image, deployed through nomad