Redash outdated queries admin page

Issue Summary

Sometime when I try looking into outdated queries, I get below in the logs with an error on front end too

[2022-06-12 18:01:10,501][PID:3337][ERROR][redash.app] Exception on /api/admin/queries/outdated [GET]
server_1 | Traceback (most recent call last):
server_1 | File “/usr/local/lib/python3.7/site-packages/flask/app.py”, line 2446, in wsgi_app
server_1 | response = self.full_dispatch_request()
server_1 | File “/usr/local/lib/python3.7/site-packages/flask/app.py”, line 1951, in full_dispatch_request
server_1 | rv = self.handle_user_exception(e)
server_1 | File “/usr/local/lib/python3.7/site-packages/flask_restful/init.py”, line 269, in error_router
server_1 | return original_handler(e)
server_1 | File “/usr/local/lib/python3.7/site-packages/flask/app.py”, line 1820, in handle_user_exception
server_1 | reraise(exc_type, exc_value, tb)
server_1 | File “/usr/local/lib/python3.7/site-packages/flask/_compat.py”, line 39, in reraise
server_1 | raise value
server_1 | File “/usr/local/lib/python3.7/site-packages/flask/app.py”, line 1949, in full_dispatch_request
server_1 | rv = self.dispatch_request()
server_1 | File “/usr/local/lib/python3.7/site-packages/flask/app.py”, line 1935, in dispatch_request
server_1 | return self.view_functionsrule.endpoint
server_1 | File “/app/redash/permissions.py”, line 71, in decorated
server_1 | return fn(*args, **kwargs)
server_1 | File “/usr/local/lib/python3.7/site-packages/flask_login/utils.py”, line 261, in decorated_view
server_1 | return func(*args, **kwargs)
server_1 | File “/app/redash/handlers/admin.py”, line 39, in outdated_queries
server_1 | “updated_at”: manager_status[“last_refresh_at”],
server_1 | KeyError: ‘last_refresh_at’
server_1 | [2022-06-12 18:01:10,504][PID:3337][INFO][metrics] method=GET path=/api/admin/queries/outdated endpoint=redash_outdated_queries status=500 content_type=text/html content_length=290 duration=21.68 query_count=3 query_duration=14.17

Technical details:

  • Redash Version: v10
  • Browser/OS:
  • How did you install Redash:

It’s very likely this is a direct result of your Redis configuration, being discussed here.