isvalid(5) can hang forever

Roger Pack <[email protected]>
Newsgroups gmane.comp.db.postgresql.jdbc
Message-ID <CAL1QdWdjeuaaxt_G=YSmA9maS4PBNc_Dv68ZDt0sVsKbcnJ6Rw@mail.gmail.com>
As far as I can tell

if you establish a "normal" PGJDBC connection then run this:


connection.isValid(5) on a server that "hangs" (it's hard to describe,
but for instance an amazon RDS Postgres instance that was working
before but has since been "stopped" -- I believe it is fronted by some
kind of load balancer).

It won't be interrupted in 5 seconds it will just hang forever,
despite the timeout directive...
Just reporting it here...
Cheers!
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.