myarnav commented on issue #4612: In the “SQL Lab”, the “Results” section shows 
“Pending” constantly
URL: 
https://github.com/apache/incubator-superset/issues/4612#issuecomment-380741990
 
 
   @mistercrunch : Thanks, Telnet port is open
   @john-bodley : Thanks for helping. My redis service is running. I have now 
included CeleryConfig object with BROKER_URL and CELERY_RESULT_BACKEND with 
reference to redis://localhost:6379/1 and still the async does not work. 
   
   > import os
   > 
   > from werkzeug.contrib.cache import RedisCache
   > #superset specific config
   > #---------------------------------------------------------
   > ROW_LIMIT = 5000
   > SUPERSET_WORKERS = 4
   > SUPERSET_WEBSERVER_PORT = 8000
   > SECRET_KEY = '\2\mthisismyscretkey\1\2\a\b\y\h'
   > SQLALCHEMY_DATABASE_URI = 'sqlite:////home/ubuntu/.superset/superset.db'
   > CSRF_ENABLED = True
   > MAPBOX_API_KEY = ''
   > CACHE_DEFAULT_TIMEOUT = 86400
   > CACHE_CONFIG = {
   > 'CACHE_TYPE': 'redis',
   > 'CACHE_DEFAULT_TIMEOUT': 86400,
   > 'CACHE_KEY_PREFIX': 'superset_',
   > 'CACHE_REDIS_HOST': 'localhost',
   > 'CACHE_REDIS_PORT': 6379,
   > 'CACHE_REDIS_DB': 1,
   > 'CACHE_REDIS_URL': 'redis://localhost:6379/1'}
   > 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
   > RESULTS_BACKEND = RedisCache(
   >     host='localhost',
   >     port=6379,
   >     key_prefix='superset_results'
   > )
   > 

----------------------------------------------------------------
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:
us...@infra.apache.org


With regards,
Apache Git Services

Reply via email to