iercan commented on issue #12766:
URL: https://github.com/apache/superset/issues/12766#issuecomment-768283973
Here is another exception I catch. I don't know what is different with async
and sync queries but looks like the way celery worker send queries cause these
exceptions
```
worker_1 | [2021-01-27 13:21:35,231: ERROR/ForkPoolWorker-7] Task
load_explore_json_into_cache[2f6fdc73-84e8-4eac-9c3e-dbad93852f49] raised
unexpected: SupersetVizException('[{\'message\': "Unknown exception
(org.apache.calcite.tools.ValidationException):
org.apache.calcite.runtime.CalciteContextException: From line 7, column 10 to
line 7, column 20: Column \'algorithm\' not found in any table",
\'error_type\': <SupersetErrorType.GENERIC_DB_ENGINE_ERROR:
\'GENERIC_DB_ENGINE_ERROR\'>, \'level\': <ErrorLevel.ERROR: \'error\'>,
\'extra\': {\'engine_name\': \'Apache Druid\', \'issue_codes\': [{\'code\':
1002, \'message\': \'Issue 1002 - The database returned an unexpected
error.\'}]}}]')
worker_1 | Traceback (most recent call last):
worker_1 | File
"/usr/local/lib/python3.7/site-packages/celery/app/trace.py", line 412, in
trace_task
worker_1 | R = retval = fun(*args, **kwargs)
worker_1 | File "/app/superset/app.py", line 116, in __call__
worker_1 | return task_base.__call__(self, *args, **kwargs)
worker_1 | File
"/usr/local/lib/python3.7/site-packages/celery/app/trace.py", line 704, in
__protected_call__
worker_1 | return self.run(*args, **kwargs)
worker_1 | File "/app/superset/tasks/async_queries.py", line 108, in
load_explore_json_into_cache
worker_1 | raise exc
worker_1 | File "/app/superset/tasks/async_queries.py", line 86, in
load_explore_json_into_cache
worker_1 | raise SupersetVizException(errors=payload["errors"])
worker_1 | superset.exceptions.SupersetVizException: [{'message':
"Unknown exception (org.apache.calcite.tools.ValidationException):
org.apache.calcite.runtime.CalciteContextException: From line 7, column 10 to
line 7, column 20: Column 'algorithm' not found in any table", 'error_type':
<SupersetErrorType.GENERIC_DB_ENGINE_ERROR: 'GENERIC_DB_ENGINE_ERROR'>,
'level': <ErrorLevel.ERROR: 'error'>, 'extra': {'engine_name': 'Apache Druid',
'issue_codes': [{'code': 1002, 'message': 'Issue 1002 - The database returned
an unexpected error.'}]}}]
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
