You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2019/08/02 03:24:59 UTC
[GitHub] [incubator-superset] syafiqdante edited a comment on issue #3966:
SQL Lab queries fails intermittently when running in Async mode.
syafiqdante edited a comment on issue #3966: SQL Lab queries fails intermittently when running in Async mode.
URL: https://github.com/apache/incubator-superset/issues/3966#issuecomment-517527509
Sorry for disturbing a closed issue,
I have the same problem as well...
It occurs when I use the 'CTAS' function in superset sql lab.
Does anybody has the solution..?
my celery worker throws this error:
```
[2019-08-02 09:47:00,417: ERROR/ForkPoolWorker-1] Query with id `202` could not be retrieved
[2019-08-02 09:47:00,419: ERROR/ForkPoolWorker-1] Sleeping for a sec before retrying...
[2019-08-02 09:47:01,424: ERROR/ForkPoolWorker-1] Query with id `202` could not be retrieved
[2019-08-02 09:47:01,424: ERROR/ForkPoolWorker-1] Sleeping for a sec before retrying...
[2019-08-02 09:47:02,429: ERROR/ForkPoolWorker-1] Query with id `202` could not be retrieved
[2019-08-02 09:47:02,429: ERROR/ForkPoolWorker-1] Sleeping for a sec before retrying...
[2019-08-02 09:47:03,433: ERROR/ForkPoolWorker-1] Query with id `202` could not be retrieved
[2019-08-02 09:47:03,434: ERROR/ForkPoolWorker-1] Sleeping for a sec before retrying...
[2019-08-02 09:47:04,440: ERROR/ForkPoolWorker-1] Query with id `202` could not be retrieved
[2019-08-02 09:47:04,440: ERROR/ForkPoolWorker-1] Sleeping for a sec before retrying...
[2019-08-02 09:47:05,442: ERROR/ForkPoolWorker-1] Failed at getting query
Traceback (most recent call last):
File "/root/incubator-superset/superset/sql_lab.py", line 136, in get_sql_results
session=session, start_time=start_time)
File "/root/incubator-superset/superset/sql_lab.py", line 224, in execute_sql_statements
query = get_query(query_id, session)
File "/root/incubator-superset/superset/sql_lab.py", line 96, in get_query
raise SqlLabException('Failed at getting query')
superset.sql_lab.SqlLabException: Failed at getting query
[2019-08-02 09:47:05,455: ERROR/ForkPoolWorker-1] Query with id `202` could not be retrieved
[2019-08-02 09:47:05,456: ERROR/ForkPoolWorker-1] Sleeping for a sec before retrying...
[2019-08-02 09:47:06,461: ERROR/ForkPoolWorker-1] Query with id `202` could not be retrieved
[2019-08-02 09:47:06,462: ERROR/ForkPoolWorker-1] Sleeping for a sec before retrying...
[2019-08-02 09:47:07,467: ERROR/ForkPoolWorker-1] Query with id `202` could not be retrieved
[2019-08-02 09:47:07,467: ERROR/ForkPoolWorker-1] Sleeping for a sec before retrying...
[2019-08-02 09:47:08,472: ERROR/ForkPoolWorker-1] Query with id `202` could not be retrieved
[2019-08-02 09:47:08,473: ERROR/ForkPoolWorker-1] Sleeping for a sec before retrying...
[2019-08-02 09:47:09,477: ERROR/ForkPoolWorker-1] Query with id `202` could not be retrieved
[2019-08-02 09:47:09,478: ERROR/ForkPoolWorker-1] Sleeping for a sec before retrying...
[2019-08-02 09:47:10,482: ERROR/ForkPoolWorker-1] Failed at getting query
Traceback (most recent call last):
File "/root/incubator-superset/superset/sql_lab.py", line 136, in get_sql_results
session=session, start_time=start_time)
File "/root/incubator-superset/superset/sql_lab.py", line 224, in execute_sql_statements
query = get_query(query_id, session)
File "/root/incubator-superset/superset/sql_lab.py", line 96, in get_query
raise SqlLabException('Failed at getting query')
superset.sql_lab.SqlLabException: Failed at getting query
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/root/incubator-superset/superset/sql_lab.py", line 114, in session_scope
yield session
File "/root/incubator-superset/superset/sql_lab.py", line 140, in get_sql_results
query = get_query(query_id, session)
File "/root/incubator-superset/superset/sql_lab.py", line 96, in get_query
raise SqlLabException('Failed at getting query')
superset.sql_lab.SqlLabException: Failed at getting query
[2019-08-02 09:47:10,504: ERROR/ForkPoolWorker-1] Task superset.sql_lab.get_sql_results[cb5c14c2-0c78-4ee2-8e00-b8c68f559f0e] raised unexpected: SqlLabException('Failed at getting query',)
Traceback (most recent call last):
File "/root/incubator-superset/superset/sql_lab.py", line 136, in get_sql_results
session=session, start_time=start_time)
File "/root/incubator-superset/superset/sql_lab.py", line 224, in execute_sql_statements
query = get_query(query_id, session)
File "/root/incubator-superset/superset/sql_lab.py", line 96, in get_query
raise SqlLabException('Failed at getting query')
superset.sql_lab.SqlLabException: Failed at getting query
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.6/dist-packages/celery/app/trace.py", line 385, in trace_task
R = retval = fun(*args, **kwargs)
File "/usr/local/lib/python3.6/dist-packages/celery/app/trace.py", line 648, in __protected_call__
return self.run(*args, **kwargs)
File "/root/incubator-superset/superset/sql_lab.py", line 140, in get_sql_results
query = get_query(query_id, session)
File "/root/incubator-superset/superset/sql_lab.py", line 96, in get_query
raise SqlLabException('Failed at getting query')
superset.sql_lab.SqlLabException: Failed at getting query
```
I quite new with superset, anyhelp is appreciated...
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org