GitHub user dosubot[bot] added a comment to the discussion: Async query Redis
Connection issue
<!-- Answer -->
In Superset 5.0+, async queries need a separate Redis configuration:
GLOBAL_ASYNC_QUERIES_CACHE_BACKEND in your superset_config.py. If this isn't
set, Superset defaults to localhost:6379, which causes the connection refused
error—even if your Celery broker_url is correct.
Add this to your superset_config.py (update the values to match your Redis
server):
```python
GLOBAL_ASYNC_QUERIES_CACHE_BACKEND = {
"CACHE_TYPE": "RedisCache",
"CACHE_REDIS_HOST": "10.225.0.31",
"CACHE_REDIS_PORT": 6379,
"CACHE_REDIS_PASSWORD": "fcc_redis",
"CACHE_REDIS_DB": 1,
"CACHE_DEFAULT_TIMEOUT": 300,
}
```
After updating, restart/redeploy all Superset components (web, worker, etc.) so
the new config is loaded everywhere. Double-check that your Redis server is
running and accessible from all Superset services, and that the password and DB
number are correct. If you still see issues, check your logs to confirm which
Redis host Superset is actually trying to use at runtime.
More details and examples are in this discussion: [Superset 5.0+ async queries
Redis config](https://github.com/apache/superset/discussions/34650).
<!-- Dosu Comment Footer -->
*To reply, just mention [@dosu](https://go.dosu.dev/dosubot).*
---
<sup>How did I do?
[Good](https://app.dosu.dev/response-feedback/f98a51d9-2c00-4292-8d53-dfe330c035de?feedback_type=great_response)
|
[Irrelevant](https://app.dosu.dev/response-feedback/f98a51d9-2c00-4292-8d53-dfe330c035de?feedback_type=irrelevant_answer)
|
[Incorrect](https://app.dosu.dev/response-feedback/f98a51d9-2c00-4292-8d53-dfe330c035de?feedback_type=incorrect_sources)
|
[Verbose](https://app.dosu.dev/response-feedback/f98a51d9-2c00-4292-8d53-dfe330c035de?feedback_type=too_verbose)
|
[Hallucination](https://app.dosu.dev/response-feedback/f98a51d9-2c00-4292-8d53-dfe330c035de?feedback_type=hallucination)
| [Report
🐛](https://app.dosu.dev/response-feedback/f98a51d9-2c00-4292-8d53-dfe330c035de?feedback_type=bug_report)
|
[Other](https://app.dosu.dev/response-feedback/f98a51d9-2c00-4292-8d53-dfe330c035de?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github)&
nbsp;[](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/discussions/35990)
GitHub link:
https://github.com/apache/superset/discussions/35990#discussioncomment-14872490
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
