Folks,
I am having a hard time getting to the bottom of these issues and I need some help. I am running a v7 custom docker installation.
and I can’t run any queries connected to my bigdata source. I keep getting query in queue
Then i go to check the Celery status on the admin page i see
I am seeing this error in the server logs:
[2020-05-20 14:15:30,365] ERROR in app: Exception on /api/admin/queries/tasks [GET]
Traceback (most recent call last):
File “/usr/local/lib/python2.7/dist-packages/flask/app.py”, line 1988, in wsgi_app
response = self.full_dispatch_request()
File “/usr/local/lib/python2.7/dist-packages/flask/app.py”, line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File “/usr/local/lib/python2.7/dist-packages/flask_restful/init.py”, line 271, in error_router
return original_handler(e)
File “/usr/local/lib/python2.7/dist-packages/flask/app.py”, line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
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 “/app/redash/permissions.py”, line 48, in decorated
return fn(*args, **kwargs)
File “/usr/local/lib/python2.7/dist-packages/flask_login/utils.py”, line 228, in decorated_view
return func(*args, **kwargs)
File “/app/redash/handlers/admin.py”, line 51, in queries_tasks
‘tasks’: celery_tasks(),
File “/app/redash/monitor.py”, line 132, in celery_tasks
tasks = parse_tasks(celery.control.inspect().active(), ‘active’)
File “/app/redash/monitor.py”, line 104, in parse_tasks
for task in itertools.chain(*task_lists.values()):
AttributeError: ‘NoneType’ object has no attribute ‘values’
[2020-05-20 14:15:30,365][PID:9][ERROR][redash] Exception on /api/admin/queries/tasks [GET]
Traceback (most recent call last):
File “/usr/local/lib/python2.7/dist-packages/flask/app.py”, line 1988, in wsgi_app
response = self.full_dispatch_request()
File “/usr/local/lib/python2.7/dist-packages/flask/app.py”, line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File “/usr/local/lib/python2.7/dist-packages/flask_restful/init.py”, line 271, in error_router
return original_handler(e)
File “/usr/local/lib/python2.7/dist-packages/flask/app.py”, line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
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 “/app/redash/permissions.py”, line 48, in decorated
return fn(*args, **kwargs)
File “/usr/local/lib/python2.7/dist-packages/flask_login/utils.py”, line 228, in decorated_view
return func(*args, **kwargs)
File “/app/redash/handlers/admin.py”, line 51, in queries_tasks
‘tasks’: celery_tasks(),
File “/app/redash/monitor.py”, line 132, in celery_tasks
tasks = parse_tasks(celery.control.inspect().active(), ‘active’)
File “/app/redash/monitor.py”, line 104, in parse_tasks
for task in itertools.chain(*task_lists.values()):
AttributeError: ‘NoneType’ object has no attribute ‘values’
[2020-05-20 14:15:30,369][PID:9][INFO][metrics] method=GET path=/api/admin/queries/tasks endpoint=redash_queries_tasks status=500 content_type=? content_length=-1 duration=1034.21 query_count=3 query_duration=5.61
I have tried restarting my server and redis containers and no luck as per suggestion from the forum of similar issues. There are no other error on any of the container logs
Here is my container setup:
