Re: JDBC broken connection against Postgres 8.4 - Mailing list pgsql-jdbc

From Michael Bell
Subject Re: JDBC broken connection against Postgres 8.4
Date
Msg-id 812609.80275.qm@web43139.mail.sp1.yahoo.com
Whole thread Raw
In response to Re: JDBC broken connection against Postgres 8.4  (jerome moliere <jerome.moliere@gmail.com>)
List pgsql-jdbc
Probably, but I'm hesistant to for several reasons

1. End users will cry. :) This is part of commercial product. Of course they cry more if current condition is there, so that's kind of lame argument.,
2. I don't know TCP tuning much, but it seems to me your suggestion is a very good one if the code I posted was typical of usage. It isn't - it was just an easy way to expose the issue. Typical usage is with a Connection pool, initially set to 5 connections. And I'm getting issues with my single box test, which is hardly a load. Since in this scenario the JDBC Connections are pooled and stick around "forever" (or at least a long time w/o network issues/timeouts), I wouldn't think TIME-WAIT is relevant, right? That's only relevant to opening and tearing down tcp connections in rapid succession (eg like in my loop). Or am I showing the limits of my tcpip knowledge?

For now I'm' going to try to figure out the wire trace issues.

Keep in mind this is not just me :) . On this list back in Feb, some one had the exact same issue. And about a year ago a possibly similar issue (it was blocking on input indefinitely in the same code area, which is worse really)

Does anyone really know of some one who has tested this driver/server combo highly on Windows ?










From: jerome moliere <jerome.moliere@gmail.com>
To: Michael Bell <mikebell90@yahoo.com>
Cc: dmp <danap@ttc-cmc.net>; pgsql-jdbc@postgresql.org
Sent: Tuesday, August 18, 2009 4:56:57 AM
Subject: Re: [JDBC] JDBC broken connection against Postgres 8.4



2009/8/17 Michael Bell <mikebell90@yahoo.com>
I am not surprised. I strongly suspect this is an issue with Windows/PostgresSQL. OTOH, I did most of my testing against Postgres 8.4 server.


Hi all,
coul you fine tune your TCP/IP stack, trying to set a lower value for the TIME-WAIT paremeter

HTH
Jerome

--
Jerome Moliere - Mentor/J
http://romjethoughts.blogspot.com/
auteur Eyrolles

pgsql-jdbc by date:

Previous
From: jerome moliere
Date:
Subject: Re: JDBC broken connection against Postgres 8.4
Next
From: Michael Bell
Date:
Subject: Re: JDBC broken connection against Postgres 8.4