dosubot[bot] commented on issue #31978: URL: https://github.com/apache/superset/issues/31978#issuecomment-2611996416
<!-- Greeting --> Hey there, @ivanonair! I'm here to help you with any bugs, questions, or contributions you have in mind. Let's tackle this issue together! <!-- Answer --> The issue you're encountering with DuckDB in Superset might be related to how concurrent queries are handled. DuckDB does not support running multiple queries concurrently on the same connection, which could lead to the errors you're seeing when multiple filters are applied on a dashboard. This is consistent with the error message about "No open result set" and the potential connection termination. To address this, you might consider the following approaches: 1. **Connection Pooling**: Ensure that each query is executed on a separate connection. This can help avoid conflicts that arise from concurrent query execution on a single connection. 2. **Rate Limiting**: Check if there are any settings related to rate limiting or the number of concurrent connections allowed. Adjusting these settings might help manage the load better. 3. **Query Optimization**: Review the queries generated by the filters to see if they can be optimized or combined to reduce the number of concurrent queries. 4. **Superset Configuration**: Look into Superset's configuration options to see if there are any settings that can help manage database connections more effectively when using DuckDB. These steps might help mitigate the issue by ensuring that queries are handled in a way that aligns with DuckDB's capabilities. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/719fbf48-8879-43aa-aa76-94550082ba93?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/719fbf48-8879-43aa-aa76-94550082ba93?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/719fbf48-8879-43aa-aa76-94550082ba93?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/719fbf48-8879-43aa-aa76-94550082ba93?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/719fbf48-8879-43aa-aa76-94550082ba93?feedback_type=hallucination) | [Other](https://app.dosu.dev/response-feedback/719fbf48-8879-43aa-aa76-94550082ba93?feedback_type=other)</sup> -- 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]
