IDP V3: LockTimeoutException with remote PG DB

[TISSOT Jacques]

Has anybody could clustered sucessfully IDP v3 with remote Posgresql DB?

Jacques

> -----Original Message-----
> From: users [mailto:users-bounces at shibboleth.net] On Behalf Of Cantor,
> Scott
> Sent: mercredi 30 septembre 2015 17:36
> To: Shib Users
> Subject: Re: IDP V3: LockTimeoutException with remote PG DB
> 
> 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
> 
> --
> To unsubscribe from this list send an email to users-
> unsubscribe at shibboleth.net