Re: Bug (and fix): leaks of TCP connections when connected - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Bug (and fix): leaks of TCP connections when connected
Date
Msg-id Pine.BSO.4.56.0406211427440.7190@leary.csoft.net
Whole thread Raw
In response to Bug (and fix): leaks of TCP connections when connected to a <7.4 server  (Laurent Sylvain <sylvain.laurent@elca.ch>)
Responses Re: Bug (and fix): leaks of TCP connections when connected  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc

On Mon, 21 Jun 2004, Laurent Sylvain wrote:

> I experienced some TCP connection leaks when using PGSQL JDBC driver 7.4
> (build 214) to connect to a 7.3.4 server.
> The symptoms are that when performing a netstat on the client machine, many
> connections were in the CLOSE_WAIT state.

I'm not much of an expert on TCP, so could you give me a little more
background on this?  I've duplicated the behavior you describe and I
believe your fix is correct, but I'd like to understand this better.
First why is this a problem, the CLOSE_WAIT entries disappear rather
quickly.  Second the number of CLOSE_WAIT items is nothing compared to the
number of TIME_WAIT entries, why aren't they a problem?

Kris Jurka

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: JDBC driver inserting into a table with Bytea type gets
Next
From: "Sailer, Denis (YBUSA-CDR)"
Date:
Subject: Re: JDBC driver inserting into a table with Bytea type get