dosubot[bot] commented on issue #34130: URL: https://github.com/apache/superset/issues/34130#issuecomment-3061035708
<!-- Answer --> This is a confirmed bug in SQL Lab: when you select a new database, the frontend sometimes sends a string like "mysql-MySQL-5" as the database ID instead of the required integer. This breaks all API calls for that database and any others until you reset the state. The only reliable workaround is to reload or log out/in, but for new databases, this bug will keep recurring until the fix is released ([details](https://github.com/apache/superset/pull/33955)). If clearing localStorage lets the "examples" database work but not new ones, it's almost certainly this bug. There is no in-app workaround until the patch is merged and released. If you need a temporary fix, you could try applying the patch from PR #33955 manually. Also, make sure your Docker image includes the required drivers for MySQL and Clickhouse. For MySQL, add `mysqlclient` or `mysql-connector-python` to `requirements-local.txt` and rebuild your Docker image. For Clickhouse, ensure the relevant driver is installed as well ([reference](https://github.com/apache/superset/issues/31459)). If the connection test in the UI fails, check for missing drivers or system dependencies. If your connections pass the test but SQL Lab still fails, it's the dbId bug and only the default database will work until the fix lands. If you need more help, let me know if the "Test Connection" in the UI succeeds for your MySQL and Clickhouse databases. <!-- 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/8db138e8-2e18-41db-b379-be90205d505b?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/8db138e8-2e18-41db-b379-be90205d505b?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/8db138e8-2e18-41db-b379-be90205d505b?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/8db138e8-2e18-41db-b379-be90205d505b?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/8db138e8-2e18-41db-b379-be90205d505b?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/8db138e8-2e18-41db-b379-be90205d505b?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/8db138e8-2e18-41db-b379-be90205d505b?feedback_type=other)</sup> [](https://go.dosu.dev/discord-bot) [! [Share on X](https://img.shields.io/badge/X-share-black)](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/34130) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
