[GitHub] masterlittle opened a new issue #3963: Sql lab queries not working

[GitBox <gi...@apache.org>]

masterlittle opened a new issue #3963: Sql lab queries not working
URL: https://github.com/apache/incubator-superset/issues/3963
 
 
   Make sure these boxes are checked before submitting your issue - thank you!
   
   - [ ] I have checked the superset logs for python stacktraces and included it here as text if any
   - [ ] I have reproduced the issue with at least the latest released version of superset
   - [ ] I have checked the issue tracker for the same issue and I haven't found one similar
   
   I'm trying to run query in async mode using celery and redis. But I'm getting this error::
   ERROR/Worker-1] Query with id `16` could not be retrieved
   
   This is my celery config-
   
   class CeleryConfig(object):
     BROKER_URL = 'redis://localhost:6379/1'
     CELERY_IMPORTS = ('superset.sql_lab', )
     CELERY_RESULT_BACKEND = 'redis://localhost:6379/1'
     CELERY_ANNOTATIONS = {'tasks.add': {'rate_limit': '10/s'}}
     CELERYD_LOG_LEVEL = 'DEBUG'
     CELERYD_PREFETCH_MULTIPLIER = 1
     CELERY_ACKS_LATE = True
   CELERY_CONFIG = CeleryConfig
   
   SQL_CELERY_DB_FILE_PATH = os.path.join(DATA_DIR, 'celerydb.sqlite')
   SQL_CELERY_RESULTS_DB_FILE_PATH = os.path.join(DATA_DIR, 'celery_results.sqlite')
   
   redis --
   
   from werkzeug.contrib.cache import RedisCache
   RESULTS_BACKEND = RedisCache(
       host='localhost', port=6379, key_prefix='superset_results')
   
   ### Superset version
   0.20.6
   
   ### Expected results
   The sql lab query should run in celery in async mode
   
   ### Actual results
   Celery giving an error:
   ERROR/Worker-1] Query with id `16` could not be retrieved
   
   ### Steps to reproduce
   
   
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on 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