Redash 7.0 Dashboard API has internal server error

#1

Issue Summary

Dashboards API doesn’t work after I upgrade redash to 7.0. Alerts, queries, users api are all working.
image
A summary of the issue and the browser/OS environment in which it occurs.

Technical details:

  • Redash Version: 7.0
  • Browser/OS: Chrome/ubuntu 18.04
  • How did you install Redash: GCE Image
0 Likes

#2

anybody experiencing the same thing?

0 Likes

#3

Can you please:

  1. Provide details on how you upgraded to 7.0.
  2. Share logs from the server service in your Docker setup from the time you try to open the dashboards page.

Thanks.

0 Likes

#4

I have legacy image setup, not on docker. I used the upgrade script to upgrade.

server log:

[2019-04-04 09:30:52,153] ERROR in app: Exception on /api/dashboards [GET]
Traceback (most recent call last):
File “/usr/local/lib/python2.7/dist-packages/flask/app.py”, line 1639, in full_dispatch_request
rv = self.dispatch_request()
File “/usr/local/lib/python2.7/dist-packages/flask/app.py”, line 1625, in dispatch_request
return self.view_functionsrule.endpoint
File “/usr/local/lib/python2.7/dist-packages/flask_restful/init.py”, line 477, in wrapper
resp = resource(*args, **kwargs)
File “/usr/local/lib/python2.7/dist-packages/flask_login/utils.py”, line 228, in decorated_view
return func(*args, **kwargs)
File “/usr/local/lib/python2.7/dist-packages/flask/views.py”, line 84, in view
return self.dispatch_request(*args, **kwargs)
File “/opt/redash/redash.7.0.0.b17535/redash/handlers/base.py”, line 31, in dispatch_request
return super(BaseResource, self).dispatch_request(*args, **kwargs)
File “/usr/local/lib/python2.7/dist-packages/flask_restful/init.py”, line 587, in dispatch_request
resp = meth(*args, **kwargs)
File “/opt/redash/redash.7.0.0.b17535/redash/permissions.py”, line 48, in decorated
return fn(*args, **kwargs)
File “/opt/redash/redash.7.0.0.b17535/redash/handlers/dashboards.py”, line 75, in get
serializer=serialize_dashboard,
File “/opt/redash/redash.7.0.0.b17535/redash/handlers/base.py”, line 108, in paginate
items = [serializer(result) for result in results.items]
File “/opt/redash/redash.7.0.0.b17535/redash/serializers.py”, line 213, in serialize_dashboard
‘user’: obj.user.to_dict(),
AttributeError: ‘NoneType’ object has no attribute ‘to_dict’
[2019-04-04 09:30:52,153][PID:14424][ERROR][redash] Exception on /api/dashboards [GET]
Traceback (most recent call last):
File “/usr/local/lib/python2.7/dist-packages/flask/app.py”, line 1639, in full_dispatch_request
rv = self.dispatch_request()
File “/usr/local/lib/python2.7/dist-packages/flask/app.py”, line 1625, in dispatch_request
return self.view_functionsrule.endpoint
File “/usr/local/lib/python2.7/dist-packages/flask_restful/init.py”, line 477, in wrapper
resp = resource(*args, **kwargs)
File “/usr/local/lib/python2.7/dist-packages/flask_login/utils.py”, line 228, in decorated_view
return func(*args, **kwargs)
File “/usr/local/lib/python2.7/dist-packages/flask/views.py”, line 84, in view
return self.dispatch_request(*args, **kwargs)
File “/opt/redash/redash.7.0.0.b17535/redash/handlers/base.py”, line 31, in dispatch_request
return super(BaseResource, self).dispatch_request(*args, **kwargs)
File “/usr/local/lib/python2.7/dist-packages/flask_restful/init.py”, line 587, in dispatch_request
resp = meth(*args, **kwargs)
File “/opt/redash/redash.7.0.0.b17535/redash/permissions.py”, line 48, in decorated
return fn(*args, **kwargs)
File “/opt/redash/redash.7.0.0.b17535/redash/handlers/dashboards.py”, line 75, in get
serializer=serialize_dashboard,
File “/opt/redash/redash.7.0.0.b17535/redash/handlers/base.py”, line 108, in paginate
items = [serializer(result) for result in results.items]
File “/opt/redash/redash.7.0.0.b17535/redash/serializers.py”, line 213, in serialize_dashboard
‘user’: obj.user.to_dict(),
AttributeError: ‘NoneType’ object has no attribute ‘to_dict’
[2019-04-04 09:30:52,155][PID:14424][INFO][metrics] method=GET path=/api/dashboards endpoint=dashboards status=500 content_type=application/json content_length=36 duration=64.77 query_count=7 query_duration=40.94

0 Likes

#5

does anybody have an idea on this error?

0 Likes

#6

@arikfr hey, could you please help me looking the error log? much appreciated!:pray:

0 Likes

#7

See here:

https://redash.io/help/open-source/admin-guide/maintenance

0 Likes