You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "seqwait (via GitHub)" <gi...@apache.org> on 2025/05/06 10:29:50 UTC
[I] ClickHouse keeps connecting [superset]
seqwait opened a new issue, #33376:
URL: https://github.com/apache/superset/issues/33376
### Bug description
ClickHouse keeps connecting, and the api/v1/database/ endpoint remains in a pending state.
### Screenshots/recordings
_No response_
### Superset version
master / latest-dev
### Python version
3.9
### Node version
16
### Browser
Chrome
### Additional context
_No response_
### Checklist
- [ ] I have searched Superset docs and Slack and didn't find a solution to my problem.
- [ ] I have searched the GitHub issue tracker and didn't find a similar bug report.
- [ ] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.
--
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: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] ClickHouse keeps connecting [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #33376:
URL: https://github.com/apache/superset/issues/33376#issuecomment-4748696751
This is _still_ tagged validation:required with no confirmed reproduction, and it looks like a ClickHouse driver/connectivity environment issue. I'm closing for now, but please reopen with steps to reproduce on a current Superset version if it persists.
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] ClickHouse keeps connecting [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
dosubot[bot] commented on issue #33376:
URL: https://github.com/apache/superset/issues/33376#issuecomment-2854069058
<!-- Greeting -->
Hello @seqwait! I'm [Dosu](https://dosu.dev), a friendly bot here to help you solve bugs, answer questions, and guide you as a contributor while you wait for a human maintainer. Let's tackle that ClickHouse connection issue together!
<!-- Answer -->
The issue you're experiencing, where the ClickHouse connection remains in a pending state, could be related to several factors. Here are some potential causes and solutions:
1. **Async Query Initialization**: The pending state might be due to the initialization of async query jobs, which set the status to `STATUS_PENDING` initially. This is a normal part of the process before the job starts running or encounters an error <sup>[[1]](https://github.com/apache/superset/blob/master/superset/async_events/async_query_manager.py)</sup>.
2. **Timeout Settings**: Check the timeout settings for database connections in Superset. You can configure these settings in the Superset configuration file. For example, `SQLLAB_TIMEOUT`, `SUPERSET_TIMEOUT`, and `SUPERSET_SQLALCHEMY_TIMEOUT` are some of the parameters you can adjust to change the timeout duration <sup>[[2]](https://github.com/apache/superset/issues/33218)</sup>.
3. **Network Issues**: Ensure there are no network issues that might be causing the request to hang. Superset handles network errors by providing specific error messages, such as 'Network error' for failed fetch attempts <sup>[[3]](https://github.com/apache/superset/blob/master/superset-frontend/packages/superset-ui-core/src/query/getClientErrorObject.ts)</sup>.
4. **ClickHouse Configuration**: Verify that the ClickHouse connection string and parameters are correctly configured. Ensure that the `clickhouse-connect` library is installed and the connection string is formatted correctly <sup>[[4]](https://github.com/apache/superset/blob/master/docs/docs/configuration/databases.mdx)</sup>.
5. **Retry Mechanisms**: Superset has retry mechanisms for handling failed connection attempts. Ensure that these are functioning correctly and that the system is not stuck in a retry loop <sup>[[5]](https://github.com/apache/superset/blob/master/superset-frontend/packages/superset-ui-core/src/connection/constants.ts)</sup>.
If none of these solutions resolve the issue, consider checking the Superset logs for any error messages or stack traces that might provide more insight into the problem.
<!-- 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/b382c938-6f95-4cb0-8827-e314816ea9bb?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/b382c938-6f95-4cb0-8827-e314816ea9bb?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/b382c938-6f95-4cb0-8827-e314816ea9bb?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/b382c938-6f95-4cb0-8827-e314816ea9bb?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/b382c938-6f95-4cb0-8827-e314816ea9bb?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/b382c938-6f95-4cb0-8827-e314816ea9bb?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/b382c938-6f95-4cb0-8827-e314816ea9bb?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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] ClickHouse keeps connecting [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #33376: ClickHouse keeps connecting
URL: https://github.com/apache/superset/issues/33376
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org