IDP V3: LockTimeoutException with remote PG DB

[Etienne Dysli-Metref]

On 08/10/15 15:27, Marvin Addison wrote:
> I took some time to attempt to reproduce the error on a test platform,
> but was unable. It's a pretty synthetic test using a VM with everything
> (IdP, OpenLDAP, and PG) running on the same box, but I hit it with
> enough concurrent load that if there were a fundamental problem with the
> locking code, it should have showed up.

Thanks for taking time to try this Marvin. One thing that Jacques has in
his Postgres database that other deployers might not have is the
following rules:

CREATE RULE valuedeletecleanup AS ON DELETE TO storagerecords DO SELECT
lo_unlink(OLD.value::oid);
CREATE RULE valueupdatecleanup AS ON UPDATE TO storagerecords DO SELECT
lo_unlink(OLD.value::oid) WHERE NEW.value <> OLD.value;

These come from our current IdP installation guide [1] and may be the
source of table locks...

  Etienne

[1] https://www.switch.ch/aai/guides/idp/installation/#sqldatabase

-------------- 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/20151013/071cc0bb/attachment.sig>