Re: Socket read fails - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Socket read fails
Date
Msg-id 43D7F7C0.20501@opencloud.com
Whole thread Raw
In response to Re: Socket read fails  (David Hustace <david@opennms.org>)
Responses Re: Socket read fails
List pgsql-jdbc
David Hustace wrote:

> Conclusion java is doing a read on this socket, and postmaster is  doing
> a recv.

Well, that's pretty weird.

Can you reproduce this with a recent driver and loglevel=2 (append it as
a URL parameter to your JDBC URL) and send me the resulting debug output
offlist? It sounds like it might be hard to trigger though :(

> We are considering the use of DataSource instead of the deprecated
> DriverManager, since DriverManager is synchronized.  Any thoughts on
> the system level debugging above or the use of the DataSource Interface?

I doubt that using DataSource will make any difference. From the stack
traces you showed, this does not look like a Java-level deadlock at all.

(I noticed that your two stack traces seem to be talking to different
server versions, though.. what's up with that?)

-O

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: strange problem
Next
From: Oliver Jowett
Date:
Subject: Re: Inserting the wrong date