You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "mytudan (via GitHub)" <gi...@apache.org> on 2023/06/20 00:48:32 UTC
[GitHub] [shardingsphere] mytudan opened a new issue, #26445: High Number of Established TCP Connections with ShardingSphere-Proxy 5.3.1
mytudan opened a new issue, #26445:
URL: https://github.com/apache/shardingsphere/issues/26445
I am encountering an issue with ShardingSphere-Proxy version 5.3.1. When my application establishes a database connection with the proxy, I have noticed that a large number of TCP connections between the proxy and the application remain in the 'ESTABLISHED' state. Moreover, the number of these connections continues to increase daily without any reduction.
However, when I check from the application side, the number of connections seems normal, only a few, which is quite odd. Shouldn't the TCP connections with the proxy also be terminated when the application disconnects?
I would appreciate any assistance you can provide regarding this matter.
Thank you.
--
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@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] commented on issue #26445: High Number of Established TCP Connections with ShardingSphere-Proxy 5.3.1
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #26445:
URL: https://github.com/apache/shardingsphere/issues/26445#issuecomment-1709028444
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
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@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] mytudan2022 commented on issue #26445: High Number of Established TCP Connections with ShardingSphere-Proxy 5.3.1
Posted by "mytudan2022 (via GitHub)" <gi...@apache.org>.
mytudan2022 commented on issue #26445:
URL: https://github.com/apache/shardingsphere/issues/26445#issuecomment-1667056421
I have discovered that Apache Kafka had an issue similar to the one I'm encountering, where the open file descriptor count approaches the limit due to terminated client instances. Kafka has resolved this problem in subsequent versions. The related link to the issue in Kafka can be found here: [KAFKA-2096](https://issues.apache.org/jira/browse/KAFKA-2096).
My question is: Does ShardingSphere have a similar configuration for keepalive like Kafka? This configuration appears to be an effective solution to the problem, and I'm interested in knowing if a similar option exists within ShardingSphere.
Thank you for your assistance.
--
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@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] commented on issue #26445: High Number of Established TCP Connections with ShardingSphere-Proxy 5.3.1
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #26445:
URL: https://github.com/apache/shardingsphere/issues/26445#issuecomment-1644528178
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
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@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org