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/08/03 02:55:38 UTC
[GitHub] [shardingsphere] JiekerTime opened a new issue #11611: [important] Atomikos causes too many connections to PGSQL
JiekerTime opened a new issue #11611:
URL: https://github.com/apache/shardingsphere/issues/11611
The problem occurred with integration testing, which could not be resolved due to limited capabilities.
### Which version of ShardingSphere did you use?
5.0.0-RC1-SNAPSHOT
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
### behavior
### Reason analyze (If you can)
Dialect differences between PGSQL and MySQL result in Atomikos connections not being recycled.
Or there may also likely the result of concurrency issues.
But it works normally in MySQL scenarios.
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
Just create the data source concurrently by the following way：
You may wish to refer to the [integration testing framework](https://github.com/apache/shardingsphere/blob/master/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-fixture/src/test/java/org/apache/shardingsphere/test/integration/junit/container/adapter/impl/ShardingSphereJDBCContainer.java)
--
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] menghaoranss closed issue #11611: Atomikos may cause too many connections
Posted by GitBox <gi...@apache.org>.
menghaoranss closed issue #11611:
URL: https://github.com/apache/shardingsphere/issues/11611
--
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] hoorf edited a comment on issue #11611: [important] Atomikos causes too many connections to PGSQL
Posted by GitBox <gi...@apache.org>.
hoorf edited a comment on issue #11611:
URL: https://github.com/apache/shardingsphere/issues/11611#issuecomment-891495409
improve the pgsql config `max_connections` may work at short time
--
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] JiekerTime commented on issue #11611: [important] Atomikos causes too many connections to PGSQL
Posted by GitBox <gi...@apache.org>.
JiekerTime commented on issue #11611:
URL: https://github.com/apache/shardingsphere/issues/11611#issuecomment-891734527
> improve the pgsql config `max_connections` may work at short time
This really can run through, but I don't think this approach can solve the problem at the root because the number of connections is growing exponentially.
--
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] hoorf commented on issue #11611: [important] Atomikos causes too many connections to PGSQL
Posted by GitBox <gi...@apache.org>.
hoorf commented on issue #11611:
URL: https://github.com/apache/shardingsphere/issues/11611#issuecomment-891495409
improve the pgsql config `max_connections` may work in short time
--
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