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/13 07:34:17 UTC

[GitHub] [shardingsphere] penghuazhou opened a new issue #13016: Exception during pool initialization

penghuazhou opened a new issue #13016:
URL: https://github.com/apache/shardingsphere/issues/13016


   when use ShardingSphere UI to add a dataSource for example ds_03, if there is insert sql execute send to ShardingSphere-Proxy(no sql execute this time, will not have error)，if throw this error? 
   
   ![image](https://user-images.githubusercontent.com/13001038/137087714-17bf3ec9-cbbb-47fe-850b-797d1c6ad004.png)
   
   
   Which version of ShardingSphere did you use?
   apache-shardingsphere-4.1.1-src-release, ShardingSphere-Proxy
   
   sharding_db=> insert into t_order (user_id,info,c1,crt_time) values (22,'xxxxxxxxzxxxxx',1,now());
   HikariDataSource HikariDataSource (HikariPool-8) has been closed.
   
   [ERROR] 15:30:19.502 [Curator-TreeCache-5] com.zaxxer.hikari.pool.HikariPool - HikariPool-24 - Exception during pool initialization.
   org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
       at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:514)
       at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:141)
       at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:192)
       at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
       at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
       at org.postgresql.Driver.makeConnection(Driver.java:454)
       at org.postgresql.Driver.connect(Driver.java:256)
       at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
       at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:354)
       at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202)
       at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473)
       at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:554)
       at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
       at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:81)
       at org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.datasource.JDBCRawBackendDataSourceFactory.build(JDBCRawBackendDataSourceFactory.java:74)
       at org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.datasource.JDBCBackendDataSource.createDataSources(JDBCBackendDataSource.java:70)
       at 
   


-- 
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] penghuazhou commented on issue #13016: Exception during pool initialization

Posted by GitBox <gi...@apache.org>.
penghuazhou commented on issue #13016:
URL: https://github.com/apache/shardingsphere/issues/13016#issuecomment-942196070


   > * GUC-MAX-CONNECTIONS
   
   only one client connected, if the client execute sql when use ShardingSphere UI to add a dataSource. the errors also happen. How to solve the problem?


-- 
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 #13016: Exception during pool initialization

Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #13016:
URL: https://github.com/apache/shardingsphere/issues/13016#issuecomment-942144709


   Refer to https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_max_connections


-- 
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 #13016: Exception during pool initialization

Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #13016:
URL: https://github.com/apache/shardingsphere/issues/13016#issuecomment-942144709






-- 
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] penghuazhou commented on issue #13016: Exception during pool initialization

Posted by GitBox <gi...@apache.org>.
penghuazhou commented on issue #13016:
URL: https://github.com/apache/shardingsphere/issues/13016#issuecomment-942191509






-- 
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] penghuazhou edited a comment on issue #13016: Exception during pool initialization

Posted by GitBox <gi...@apache.org>.
penghuazhou edited a comment on issue #13016:
URL: https://github.com/apache/shardingsphere/issues/13016#issuecomment-942196070


   > * GUC-MAX-CONNECTIONS
   @TeslaCN 
   only one client connected, if the client execute sql when use ShardingSphere UI to add a dataSource. the errors also happen. How to solve the problem?


-- 
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 edited a comment on issue #13016: Exception during pool initialization

Posted by GitBox <gi...@apache.org>.
TeslaCN edited a comment on issue #13016:
URL: https://github.com/apache/shardingsphere/issues/13016#issuecomment-942144709


   Refer to 
   - MySQL https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_max_connections
   - PostgreSQL https://www.postgresql.org/docs/current/runtime-config-connection.html#GUC-MAX-CONNECTIONS


-- 
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 #13016: Exception during pool initialization

Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #13016:
URL: https://github.com/apache/shardingsphere/issues/13016#issuecomment-942896141


   @penghuazhou 
   This error message `sorry, too many clients already` is returned by actual database. Consider increasing the `max_connections` of the databases.


-- 
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 edited a comment on issue #13016: Exception during pool initialization

Posted by GitBox <gi...@apache.org>.
TeslaCN edited a comment on issue #13016:
URL: https://github.com/apache/shardingsphere/issues/13016#issuecomment-942144709


   Refer to 
   - MySQL https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_max_connections
   - PostgreSQL https://www.postgresql.org/docs/current/runtime-config-connection.html#GUC-MAX-CONNECTIONS


-- 
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] penghuazhou edited a comment on issue #13016: Exception during pool initialization

Posted by GitBox <gi...@apache.org>.
penghuazhou edited a comment on issue #13016:
URL: https://github.com/apache/shardingsphere/issues/13016#issuecomment-942196070


   > * GUC-MAX-CONNECTIONS
   @TeslaCN 
   only one client connected, if the client execute sql when use ShardingSphere UI to add a dataSource. the errors also happen. How to solve the problem?


-- 
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