Vertica修改最大并发连接数

aijuans8

浏览: 187180 次

最近访客更多访客>>

testcs_dn

st_chin

vtaff

woshiliukun

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

最近在对Vertica做压力测试的时候，发现当并发请求数达到50+的时候就会出现下面的异常

com.vertica.util.PSQLException: FATAL: New session rejected due to limit, already 55 sessions active
	at com.vertica.core.v3.ConnectionFactoryImpl.readStartupMessages(Unknown Source)
	at com.vertica.core.v3.ConnectionFactoryImpl.openConnectionImpl(Unknown Source)
	at com.vertica.core.ConnectionFactory.openConnection(Unknown Source)
	at com.vertica.jdbc2.AbstractJdbc2Connection.<init>(Unknown Source)
	at com.vertica.jdbc3.AbstractJdbc3Connection.<init>(Unknown Source)
	at com.vertica.jdbc3g.Jdbc3gConnection.<init>(Unknown Source)
	at com.vertica.Driver.makeConnection(Unknown Source)
	at com.vertica.Driver.connect(Unknown Source)
	at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
	at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
	at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1181)
	at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
	at DBUtil.getConnection(DBUtil.java:64)
	at DBQueryPerformanceTest.query(DBQueryPerformanceTest.java:46)
	at DBQueryPerformanceTest.access$000(DBQueryPerformanceTest.java:14)
	at DBQueryPerformanceTest$1.execute(DBQueryPerformanceTest.java:40)
	at DBPerformanceTest.runIt(DBPerformanceTest.java:97)
	at DBPerformanceTest$1.run(DBPerformanceTest.java:51)
	at java.lang.Thread.run(Thread.java:619)
com.vertica.util.PSQLException: The connection attempt failed.
	at com.vertica.core.v3.ConnectionFactoryImpl.openConnectionImpl(Unknown Source)
	at com.vertica.core.ConnectionFactory.openConnection(Unknown Source)
	at com.vertica.jdbc2.AbstractJdbc2Connection.<init>(Unknown Source)
	at com.vertica.jdbc3.AbstractJdbc3Connection.<init>(Unknown Source)
	at com.vertica.jdbc3g.Jdbc3gConnection.<init>(Unknown Source)
	at com.vertica.Driver.makeConnection(Unknown Source)
	at com.vertica.Driver.connect(Unknown Source)
	at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
	at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
	at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1181)
	at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
	at DBUtil.getConnection(DBUtil.java:64)
	at DBQueryPerformanceTest.query(DBQueryPerformanceTest.java:46)
	at DBQueryPerformanceTest.access$000(DBQueryPerformanceTest.java:14)
	at DBQueryPerformanceTest$1.execute(DBQueryPerformanceTest.java:40)
	at DBPerformanceTest.runIt(DBPerformanceTest.java:97)
	at DBPerformanceTest$1.run(DBPerformanceTest.java:51)
	at java.lang.Thread.run(Thread.java:619)
Caused by: java.net.SocketException: Connection reset
	at java.net.SocketInputStream.read(SocketInputStream.java:168)
	at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
	at java.io.BufferedInputStream.read(BufferedInputStream.java:237)
	at com.vertica.core.PGStream.ReceiveChar(Unknown Source)
	at com.vertica.core.v3.ConnectionFactoryImpl.doAuthentication(Unknown Source)
	... 19 more

出现这个问题是由于Vertica中指定了MaxClientSessions参数，此时可以通过下面的SQL来修改此值

分享到：