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 ok, I followed following steps and was able to setup redis. I had to install the following packages to fix the issue 1. Install gevent 2. install mysql package 3. save the file in "/venv/local/lib/python2.7/site-packages/" - This is my pythonpath My configuration file looks like this ``` import os from werkzeug.contrib.cache import RedisCache ROW_LIMIT = 5000 SUPERSET_WORKERS = 4 # You will be serving site on port 8000 from gunicorn which sits in front of flask, and then send to nginx SUPERSET_WEBSERVER_PORT = 8000 SECRET_KEY = '\2\mthisismyscretkey\1\2\a\b\y\h' SQLALCHEMY_DATABASE_URI = 'sqlite:////home/ubuntu/.superset/superset.db' # Flask-WTF flag for CSRF CSRF_ENABLED = True # Set this API key to enable Mapbox visualizations 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: [email protected] With regards, Apache Git Services
