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

From Oliver Jowett
Subject Re: Bug (and fix): leaks of TCP connections when connected
Date
Msg-id 40D7937A.3040703@opencloud.com
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  ("Marcus Andree S. Magalhaes" <marcus.magalhaes@vlinfo.com.br>)
List pgsql-jdbc
Laurent Sylvain wrote:
> Hello,
>
> 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.
>
> The problem is that the driver tries to connect using v3 protocol and when
> it sees that the server doesn't understand it, it opens a new connection
> (PGStream) to the server without closing the previous one:

In theory the discarded connections should eventually be garbage
collected and closed, right? So at least the leak is bounded.

(I'll check that this is fixed in my patches; I restructured that area
quite a bit)

-O

pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug (and fix): leaks of TCP connections when connected
Next
From: "Marcus Andree S. Magalhaes"
Date:
Subject: Re: Bug (and fix): leaks of TCP connections when connected