GitHub user dosubot[bot] added a comment to the discussion: while writing query in sql lab of apache superset i getting error You can't write against a read only replica.
<!-- Answer --> Superset does not rewrite SELECT queries as writes—your query is being sent to StarRocks exactly as written. The error message is coming from StarRocks, not Superset, and usually means the database thinks a write is being attempted on a read-only replica, even though your query is a simple SELECT [reference](https://github.com/apache/superset/blob/f802474b07bc7a2765e57fcd6612d2b4454f5c62/superset/db_engine_specs/starrocks.py). A few things to check: - Try running the same SELECT directly in a StarRocks SQL client (outside Superset). If you get the same error, it’s a database-side issue. - Make sure your Superset connection is pointed at a StarRocks endpoint that allows reads. Sometimes, proxies or misconfigured replicas can block even SELECTs if permissions or routing are off. - Check if there are any triggers, views, or database-level logic on that table that could cause a SELECT to trigger a write. - See if the issue happens with other tables, or just this one. If you can share any StarRocks logs or more details about your connection setup, I can help interpret them. <!-- 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/b88a32ed-b974-47bb-9f73-4db650b5b5f7?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/b88a32ed-b974-47bb-9f73-4db650b5b5f7?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/b88a32ed-b974-47bb-9f73-4db650b5b5f7?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/b88a32ed-b974-47bb-9f73-4db650b5b5f7?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/b88a32ed-b974-47bb-9f73-4db650b5b5f7?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/b88a32ed-b974-47bb-9f73-4db650b5b5f7?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/b88a32ed-b974-47bb-9f73-4db650b5b5f7?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/33915) GitHub link: https://github.com/apache/superset/discussions/33915#discussioncomment-13580929 ---- 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]
