dosubot[bot] commented on issue #2801: URL: https://github.com/apache/incubator-hugegraph/issues/2801#issuecomment-2969775230
<!-- Greeting --> Hi @FearlessPeople! I'm [Dosu](https://go.dosu.dev/dosubot) and I’m helping the incubator-hugegraph team. <!-- Answer --> 目前没有发现 HugeGraph 相关的 issue 或文档专门讨论 PostgreSQL 连接未自动关闭的问题。根据代码分析,HugeGraph 使用 HikariCP 作为连接池,所有后端(包括 PostgreSQL)都通过统一的连接池工具管理连接,没有针对 PostgreSQL 的特殊连接关闭逻辑。大量连接未释放通常与连接池配置有关,比如最大连接数、空闲超时时间等参数设置不合理,或者连接未被及时归还到池中。 建议你检查和调整 HikariCP 的相关参数(如 `maximumPoolSize`, `idleTimeout`, `maxLifetime` 等),这些参数一般可以在 HugeGraph 的配置文件中设置。如果配置项没有暴露,可以考虑在启动参数或环境变量中指定。合理设置这些参数通常可以减少不必要的连接占用。如果还有疑问,可以补充下你的具体连接池相关配置,便于进一步排查。 代码参考:[BackendStore 连接管理接口](https://github.com/apache/incubator-hugegraph/blob/337dc86567834acd717a2240a79fef2815d4bb6f/hugegraph-server/hugegraph-core/src/main/java/org/apache/hugegraph/backend/store/BackendStore.java) <!-- 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/b113ae53-1cc6-4beb-9023-da08259df789?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/b113ae53-1cc6-4beb-9023-da08259df789?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/b113ae53-1cc6-4beb-9023-da08259df789?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/b113ae53-1cc6-4beb-9023-da08259df789?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/b113ae53-1cc6-4beb-9023-da08259df789?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/b113ae53-1cc6-4beb-9023-da08259df789?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/b113ae53-1cc6-4beb-9023-da08259df789?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/incubator-hugegraph/issues/2801) -- 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]
