On 01/11/2011 05:41 PM, Listening Platform wrote:

The following bug has been logged online:

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


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

It'd be nice to have those "20 more". Java's habit of truncating exception stack traces is one of the more annoying things it does.

In this case, though, it seems pretty likely that you

When the error occured we were not able to connect to internet and DB

Hang on ... you mean that you were unable to access Internet services from the machine either?

Were you able to connect to the running PostgreSQL database via "psql" or via PgAdmin III?

Were there any error messages in the postgresql log files?

What about ICMP ping? traceroute ("tracert" on Windows) to Internet hosts? To your local gateway / nexthop router? etc.

> We checked TCP connections using netstat.
But there were not many TCP connections i.e it has not reached the max
limit.

What is "not many" in this context?

Which limit? you know that the operating system imposes its own limit on the number of TCP/IP connections that may exist, right? That limit includes connections that are half-open or closing as well as regular open/established connections.

Java 1.6

Java SE 6? Java EE 6?

There is no such thing as "java 1.6".

--
Craig Ringer

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to