BUG #5829: No buffer Space Available(maximum connection reached?) from postgres edb driver

From: "Listening Platform" <listening(dot)platform(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5829: No buffer Space Available(maximum connection reached?) from postgres edb driver
Date: 2011-01-11 09:41:10
Message-ID: 201101110941.p0B9fAu7093760@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5829
Logged by: Listening Platform
Email address: listening(dot)platform(at)gmail(dot)com
PostgreSQL version: 8.4 AS
Operating system: Windows 2003 server SP2
Description: No buffer Space Available(maximum connection reached?)
from postgres edb driver
Details:

Hi,

We are facing an exception while connecting to database through our
application. The stack trace is as follows

com.edb.util.PSQLException: The connection attempt failed.
at
com.edb.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryIm
pl.java:189)
at
com.edb.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at
com.edb.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:16
1)
at
com.edb.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30
)
at com.edb.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
at com.edb.Driver.makeConnection(Driver.java:391)
at com.edb.Driver.connect(Driver.java:266)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
... 12 more
Caused by: java.net.SocketException: No buffer space available (maximum
connections reached?): connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at com.edb.core.PGStream.<init>(PGStream.java:70)
at
com.edb.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryIm
pl.java:115)
... 20 more

When the error occured we were not able to connect to internet and DB and
had to reboot the system.But the error occured again after 3 days at same
code i.e while connecting to DB.We checked TCP connections using netstat.
But there were not many TCP connections i.e it has not reached the max
limit.

Our application has multiple long running Java processes that pools the DB
connections (not more than 60) and keeps it alive for firing the next query
(as it has to poll the DB every 2 seconds).Some of the queries in our
application are joining large tables(10 million records) to get the related
data.

We are using following System and applications
Windows 2003 server SP2
Java 1.6
Postgres Plus Advanced server 8.4 Database
edb-jdbc14.jar driver for connection DB from Java

We have used the default configuration of Postgres DB except increasing the
connection to 120 from 100.

Has anybody encountred the same error with postgres edb driver?
Can anybody help us finding the solution?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Richard Baratta 2011-01-11 10:39:09 BUG #5830: Cannot connect to the server
Previous Message frank 2011-01-11 02:07:18 Re: BUG #5816: index not used in function