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 2021/10/14 06:26:30 UTC
[GitHub] [shardingsphere] roodkcab opened a new issue #13033: select information_schema didn't release connection cause connection exhausted
roodkcab opened a new issue #13033:
URL: https://github.com/apache/shardingsphere/issues/13033
## Bug Report
Please answer these questions before submitting your issue. Thanks!
### Which version of ShardingSphere did you use?
5.0.0-RC1
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy
### Expected behavior
execute such sql multiple times should be ok
```
select `column_name` as `column_name`, `column_comment` as `column_comment`, `column_default` as `column_default`, `data_type` as `data_type` from information_schema.columns limit 1;
```
### Actual behavior
after ```maxPoolSize``` times, SQL will be hang until connection timeout.
### Reason analyze (If you can)
getSourceData of AbstractSelectInformationExecutor.java didn't close connection.
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
execute such sql for ```maxPoolSize``` times
```
select `column_name` as `column_name`, `column_comment` as `column_comment`, `column_default` as `column_default`, `data_type` as `data_type` from information_schema.columns limit 1;
```
--
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] tristaZero closed issue #13033: select information_schema didn't release connection cause connection pool exhausted
Posted by GitBox <gi...@apache.org>.
tristaZero closed issue #13033:
URL: https://github.com/apache/shardingsphere/issues/13033
--
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] lanchengx commented on issue #13033: select information_schema didn't release connection cause connection exhausted
Posted by GitBox <gi...@apache.org>.
lanchengx commented on issue #13033:
URL: https://github.com/apache/shardingsphere/issues/13033#issuecomment-943063912
@roodkcab Thanks for the feedback.
@RaigorJiang Please assign to me .
--
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] RaigorJiang commented on issue #13033: select information_schema didn't release connection cause connection exhausted
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13033:
URL: https://github.com/apache/shardingsphere/issues/13033#issuecomment-943067337
Thank you @roodkcab @lanchengx .
--
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