You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/09/20 04:01:21 UTC
[GitHub] [shardingsphere] local-li opened a new issue, #21084: 我无法关闭proxy对mysql的所有连接
local-li opened a new issue, #21084:
URL: https://github.com/apache/shardingsphere/issues/21084
当我关闭HikariDataSource所有线程池连接时，他们能正常关闭。
但是当我在mysql server端show processlist;命令查看连接时，proxy还保持着一个连接。并且这个连接在我杀掉proxy进程时消失。
（此时强制GC也无法关闭）
我以为是事务管理器所产生的连接，自己没有关闭，但是当我调用shardingTransactionManagerEngine.close();也无法将其进行连接关闭。
（此时强制GC是可以让连接消杀的）
求大佬告知如何在不进行手动GC的情况进行关闭连接？
--
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] local-li closed issue #21084: I can't close all proxy connections to mysql I can't close all proxy connections to mysql
Posted by GitBox <gi...@apache.org>.
local-li closed issue #21084: I can't close all proxy connections to mysql I can't close all proxy connections to mysql
URL: https://github.com/apache/shardingsphere/issues/21084
--
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] TeslaCN commented on issue #21084: I can't close all proxy connections to mysql I can't close all proxy connections to mysql
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #21084:
URL: https://github.com/apache/shardingsphere/issues/21084#issuecomment-1252131550
You may try setting `minPoolSize: 0`. Connections will be closed after idled for a while.
--
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] local-li commented on issue #21084: I can't close all proxy connections to mysql I can't close all proxy connections to mysql
Posted by GitBox <gi...@apache.org>.
local-li commented on issue #21084:
URL: https://github.com/apache/shardingsphere/issues/21084#issuecomment-1253105571
>
Yes, but it is not that I have not closed the data source of the sharding agent. Instead, the XADataSource and XAConnection used for XA transaction generation cannot be closed immediately.
--
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