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 and 
CeleryConfig object is now included with BROKER_URL and CELERY_RESULT_BACKEND 
with reference to redis://localhost:6379/1. When I am running the query in 
async, it says "Results backend isn't configured." 
   
   > 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