IDP V3: LockTimeoutException with remote PG DB

[Cantor, Scott]

On 9/30/15, 11:21 AM, "users on behalf of Etienne Dysli-Metref" <users-bounces at shibboleth.net on behalf of etienne.dysli-metref at switch.ch> wrote:


>
>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.

I was just speaking generally. I have no idea why the connection is hung, but from the IdP PoV it's taking too long.

> Any idea why that could happen? Is that some Hibernate weirdness?

I don't know anything about Hibernate.

> It's surprising because the
>blocked queries look quite simple (just a select from storagerecords).

Then maybe there's an index missing or something, but I don't see how this can be a database concurrency issue, it can't take that long to get in and out. I guess you'd have to profile the queries it's running somehow and see where it's spending its time. Even if the queries took 5 seconds (which is insane), that shouldn't be enough to break it under a moderate load. Heavy load, perhaps.

-- Scott