IDP V3: LockTimeoutException with remote PG DB

[Etienne Dysli-Metref]

On 30/09/15 15:53, Cantor, Scott wrote:
> Your database connection is hanging, or at least taking too long.
> Changing the timeouts (if the driver honors them) or fixing the
> database connectivity is the only way to fix the problem. You can't
> leave requests hanging indefinitely anymore, they'll tie up the
> system.

I asked Jacques to post his database logs here.
It's not the database connection that is hanging, but the query being
blocked waiting for a lock inside Postgres. Any idea why that could
happen? Is that some Hibernate weirdness? It's surprising because the
blocked queries look quite simple (just a select from storagerecords).

  Etienne

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: OpenPGP digital signature
URL: <http://shibboleth.net/pipermail/users/attachments/20150930/0f055b21/attachment.sig>