isvalid(5) can hang forever

From: Roger Pack <rogerdpack2(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: isvalid(5) can hang forever
Date: 2018-08-07 20:43:32
Message-ID: CAL1QdWdjeuaaxt_G=YSmA9maS4PBNc_Dv68ZDt0sVsKbcnJ6Rw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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!

Browse pgsql-jdbc by date

  From Date Subject
Next Message Vladimir Sitnikov 2018-08-15 08:08:36 [pgjdbc/pgjdbc] c2885d: fix: IndexOutOfBounds on prepared multistatement w...
Previous Message ringerc 2018-08-03 14:56:34 [pgjdbc/pgjdbc]