Thread: isValid(5) doesn't come back
Sorry if I already reported this, I didn't see it in my feed. Anyway, if the box you are connecting to (that has the Postgres server on it) becomes "unresponsive" (i.e. stops sending or receiving any network packets) then a call to isValid(5) can *hang forever* temporary work around is to set a socketTimeout but it's not my preferred option, since I'd have anticipated "isValid" to have timed out after 5s. FWIW. More info available upon demand. Cheers! -Roger-
Can you post this issue on https://github.com/pgjdbc/pgjdbc with details
On Wed, 19 Sep 2018 at 13:16, Roger Pack <rogerdpack2@gmail.com> wrote:
Sorry if I already reported this, I didn't see it in my feed.
Anyway, if the box you are connecting to (that has the Postgres server
on it) becomes "unresponsive" (i.e. stops sending or receiving any
network packets) then a call to isValid(5) can *hang forever*
temporary work around is to set a socketTimeout but it's not my
preferred option, since I'd have anticipated "isValid" to have timed
out after 5s.
FWIW.
More info available upon demand.
Cheers!
-Roger-