java – 由以下原因引起:org.postgresql.util.PSQLException:
发布时间:2020-12-15 04:41:20 所属栏目:Java 来源:网络整理
导读:我使用c3p0-0.9.5.2.jar和mchange-commons- java-0.2.11.jar来管理池连接, 我使用postgreSql 9.3. 我在Prod环境中每天至少收到一次这些消息: Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database! at com.m
我使用c3p0-0.9.5.2.jar和mchange-commons-
java-0.2.11.jar来管理池连接,
我使用postgreSql 9.3. 我在Prod环境中每天至少收到一次这些消息: Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database! at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692) at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140) at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446) ... 212 more Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source. at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1469) at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644) at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685) ... 215 more Caused by: org.postgresql.util.PSQLException: FATAL: remaining connection slots are reserved for non-replication superuser connections at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:712) 我在我的应用程序中有这个配置: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"> <beans> <bean id="dataSource" class = "com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"> <property name="driverClass" value="org.postgresql.Driver"/> <property name="jdbcUrl" value="jdbc:postgresql://localhost:5432/Test"/> <property name="user" value="postgres"/> <property name="password" value="postgres"/> <!-- pool sizing --> <!-- pool sizing --> <property name="initialPoolSize" value="32" /> <property name="minPoolSize" value="30" /> <property name="maxPoolSize" value="300" /> <property name="acquireIncrement" value="10" /> <property name="maxStatements" value="0" /> <!-- retries --> <property name="acquireRetryAttempts" value="30" /> <property name="acquireRetryDelay" value="1000" /> <!-- 1s --> <property name="breakAfterAcquireFailure" value="false" /> <!-- refreshing connections --> <property name="maxIdleTime" value="180" /> <!-- 3min --> <property name="maxConnectionAge" value="10" /> <!-- 1h --> <!-- timeouts and testing --> <property name="checkoutTimeout" value="0" /> <!-- 60s --> <property name="idleConnectionTestPeriod" value="60" /> <!-- 60 --> <property name="testConnectionOnCheckout" value="true" /> <property name="preferredTestQuery" value="SELECT 1" /> <property name="testConnectionOnCheckin" value="true" /> </bean> </beans> 在postgresql.conf中我有这个配置: max_connections = 300 shared_buffers = 32GB 我的服务器有这样的性能:24 cpu,256 GB内存 使用该应用程序的用户数量约为1300 是否有人可以帮助我解决这个问题 先感谢您 解决方法
为超级用户保留了superuser_reserved_connections连接槽(默认为3个),这样即使在采用所有连接槽的情况下它们也可以连接.
所以你实际上只有297个可用的插槽. 要么减少连接池的最大连接数,要么增加PostgreSQL中的max_connections. 顺便说一下,300太高了.您应该使用连接池的低得多的设置(除非数据库计算机中有数百个核心). (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |