Hi.
Version: 8.0.0+b32245 (a16f551e)
At one point, we received an “internal server error” when trying to execute some of the existing queries.
If you change the query itself. For example add a comment. Then it starts to be executed.
error log:
server_1 | [2020-10-02 18:28:16,156][PID:17][INFO][root] Inserting job for ffa8f9d9467aee25917892adbf84e7c2 with metadata={'Username': u'username', 'Query ID': u'7108'}
server_1 | [2020-10-02 18:28:16,157][PID:17][INFO][root] [ffa8f9d9467aee25917892adbf84e7c2] Found existing job: 138a59db-8256-4d16-8ca5-cfab9982887f
server_1 | [2020-10-02 18:28:16,159] ERROR in app: Exception on /api/queries/7108/results [POST]
server_1 | Traceback (most recent call last):
server_1 | File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1612, in full_dispatch_request
server_1 | rv = self.dispatch_request()
server_1 | File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1598, in dispatch_request
server_1 | return self.view_functions[rule.endpoint](**req.view_args)
server_1 | File "/usr/local/lib/python2.7/site-packages/flask_restful/__init__.py", line 477, in wrapper
server_1 | resp = resource(*args, **kwargs)
server_1 | File "/usr/local/lib/python2.7/site-packages/flask_login/utils.py", line 228, in decorated_view
server_1 | return func(*args, **kwargs)
server_1 | File "/usr/local/lib/python2.7/site-packages/flask/views.py", line 84, in view
server_1 | return self.dispatch_request(*args, **kwargs)
server_1 | File "/app/redash/handlers/base.py", line 31, in dispatch_request
server_1 | return super(BaseResource, self).dispatch_request(*args, **kwargs)
server_1 | File "/usr/local/lib/python2.7/site-packages/flask_restful/__init__.py", line 587, in dispatch_request
server_1 | resp = meth(*args, **kwargs)
server_1 | File "/app/redash/permissions.py", line 67, in decorated
server_1 | return fn(*args, **kwargs)
server_1 | File "/app/redash/handlers/query_results.py", line 197, in post
server_1 | return run_query(query.parameterized, parameter_values, query.data_source, query_id, max_age)
server_1 | File "/app/redash/handlers/query_results.py", line 68, in run_query
server_1 | "Query ID": query_id
server_1 | File "/app/redash/tasks/queries.py", line 117, in enqueue_query
server_1 | if job.ready():
server_1 | File "/app/redash/tasks/queries.py", line 93, in ready
server_1 | return self._async_result.ready()
server_1 | File "/usr/local/lib/python2.7/site-packages/celery/result.py", line 313, in ready
server_1 | return self.state in self.backend.READY_STATES
server_1 | File "/usr/local/lib/python2.7/site-packages/celery/result.py", line 473, in state
server_1 | return self._get_task_meta()['status']
server_1 | File "/usr/local/lib/python2.7/site-packages/celery/result.py", line 412, in _get_task_meta
server_1 | return self._maybe_set_cache(self.backend.get_task_meta(self.id))
server_1 | File "/usr/local/lib/python2.7/site-packages/celery/backends/base.py", line 386, in get_task_meta
server_1 | meta = self._get_task_meta_for(task_id)
server_1 | File "/usr/local/lib/python2.7/site-packages/celery/backends/base.py", line 730, in _get_task_meta_for
server_1 | return self.decode_result(meta)
server_1 | File "/usr/local/lib/python2.7/site-packages/celery/backends/base.py", line 305, in decode_result
server_1 | return self.meta_from_decoded(self.decode(payload))
server_1 | File "/usr/local/lib/python2.7/site-packages/celery/backends/base.py", line 301, in meta_from_decoded
server_1 | meta['result'] = self.exception_to_python(meta['result'])
server_1 | File "/usr/local/lib/python2.7/site-packages/celery/backends/base.py", line 281, in exception_to_python
server_1 | exc = cls(*exc_msg if isinstance(exc_msg, tuple) else exc_msg)
server_1 | TypeError: __init__() takes at least 4 arguments (2 given)
server_1 | [2020-10-02 18:28:16,161][PID:17][INFO][metrics] method=POST path=/api/queries/7108/results endpoint=query_result status=500 content_type=application/json content_length=36 duration=21.55 query_count=8 query_duration=9.55
```
