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!