Dashboard API error

mali · August 31, 2021, 12:32pm

Issue Summary

Hello community members,

When I try to call

http://redash.xyz.com/api/dashboards

I am getting below error

{
"message": "Internal Server Error"
}

Technical details:

looking into logs, I am getting below

[2021-08-31 12:26:37,580][PID:122587][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_functions[rule.endpoint](**req.view_args)
  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'

Redash Version: 7
Browser/OS: Chrom
How did you install Redash: Legacy install

jesse · August 31, 2021, 1:47pm

Is this a new installation of Redash? Has it ever worked?

This looks like an environment issue to me but there’s not enough data to say for sure.

mali · August 31, 2021, 2:07pm

not a new installation, it is there from couple of years. GUI is working fine but we never tried API. My intuition is that something is wrong with some dashboard which is stopping fetching all other dashboards.

jesse · August 31, 2021, 4:50pm

Interesting thought! Do you see a 500 error when you page through your database list?

mali · September 1, 2021, 7:13am

yes. till page=27 it is giving 500 but on page=28 is it giving “message”: “Page is out of range.”

mali · September 1, 2021, 8:07am

made call to individual dashboards using “/api/dashboards/<dashboard_slug>” and all of them returning 200

mali · September 1, 2021, 10:46am

found the cause. this issue is related to below

github.com/getredash/redash

AttributeError exception causing API 500 errors being experienced when searching Dashboards

opened 07:19PM - 14 Apr 20 UTC

Ralnoc

### Issue Summary In some situations, when doing a search for dashboards is resulting in an `AttributeError` exception on `obj.user.to_dict()`. I have been unable to yet pinpoint any direct cause, only the process that leads up to the issue. In addition, the issue only manifests when searching, and only with some characters, not all. Primarily if there is a large number of results. If I just navigate through the pages on the Dashboards list, there is no issues experienced. The order that I have been able to trace through the code, which leads to this problem is this: User types in search in the Dashboards page of Re:Dash `DashboardListResource` is called to search DB for dashboards the meets the query using `models.Dashboard.search` - Successful `DashboardListResource` orders the results of that query - Successful `DashboardListResource` calls `serialize_dashboard` as part of the pagination process for the the results of the order_results - Successful `handlers.base.paginate` paginates the results and passes it over to `serialize_dashboards` - Successful `serialize_dashboard` executes to serialize the paginated results to return - Fails ( `items = [serializer(result) for result in results.items]` fails with the exception `AttributeError: 'NoneType' object has no attribute 'to_dict')` This issue appears to have started after we upgraded from Re:Dash 6.0.0 to 8.0.0. We used the normal DB upgrade scripts as part of the upgrade process. We have tested the Queries and Users API endpoints and none of them throw this exception. It only happens on Dashboards and only when doing a search. We suspect it is possible an issue with SQLAlchemy related to: https://github.com/sqlalchemy/sqlalchemy/issues/3650 This is the traceback being experienced: ``` [2020-04-14 12:10:05,461] ERROR in app: Exception on /api/dashboards [GET] 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_functions[rule.endpoint](**req.view_args) 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 76, in get serializer=serialize_dashboard, File "/app/redash/handlers/base.py", line 108, in paginate items = [serializer(result) for result in results.items] File "/app/redash/serializers/__init__.py", line 214, in serialize_dashboard 'user': obj.user.to_dict(), AttributeError: 'NoneType' object has no attribute 'to_dict' ``` ### Steps to Reproduce 1. Have a number of Dashboards with content in them/ My testing was done with 12 to 15. 2. Set the Page Size (Results count) to 5 on the Dashboards page 3. Enter a one letter search that matches most of your results. 4. It will either immediately throw the exception with the API returning a 500, or if you click on the next page it will. This is a breaking behavior the impairs the ability to Navigate Dashboards. ### Technical details: * Redash Version: 8.0.0+b32245 * Browser/OS: Chrome (Running on Linux, impacts all users, regardless of OS or Browser) * How did you install Redash: Docker

jesse · September 1, 2021, 1:06pm

Thank you for linking that issue! I had totally forgotten about it. Since this isn’t a regression from V8 it won’t be fixed before the V10 release but we’ll see about arranging a fix after that.