GitHub user dosubot[bot] added a comment to the discussion: Unable to activate async querying in superset 5.0.0
<!-- Answer --> The error SqlLabException: Failed at getting query almost always means the Celery worker can't access the shared metadata database. This isn't caused by async flags or Celery process issues, but by a config problem—usually the SQLALCHEMY_DATABASE_URI is different or inaccessible between your web server and Celery worker, or migrations are missing. Both processes must use the same superset_config.py and environment variables, and the metadata DB must not be SQLite (use PostgreSQL or MySQL) [source](https://github.com/apache/superset/blob/f802474b07bc7a2765e57fcd6612d2b4454f5c62/docs/docs/configuration/async-queries-celery.mdx). Check that: - Both web and worker use the same SQLALCHEMY_DATABASE_URI and can connect to the DB. - All DB migrations are applied. - The DB is reachable from both processes (try connecting from both environments). - Asynchronous Query Execution is enabled in the database settings (Sources > Databases > Edit record) [source](https://github.com/apache/superset/issues/33218). If you can share the full traceback (including the root cause exception), I can help interpret it further. <!-- 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/417b45e3-62e7-475b-afad-3107d83c70a4?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/417b45e3-62e7-475b-afad-3107d83c70a4?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/417b45e3-62e7-475b-afad-3107d83c70a4?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/417b45e3-62e7-475b-afad-3107d83c70a4?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/417b45e3-62e7-475b-afad-3107d83c70a4?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/417b45e3-62e7-475b-afad-3107d83c70a4?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/417b45e3-62e7-475b-afad-3107d83c70a4?feedback_type=other)</sup> [](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/33920) GitHub link: https://github.com/apache/superset/discussions/33920#discussioncomment-13581513 ---- 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]
