[ZODB-Dev] RelStorage PostgreSQLLocker deadlock/wait problem

[Sean Upton]

Any insights from RelStorage users appreciated on this;

I have a case where multiple Zope2 instances (each with four threads)
get stuck (most/all threads) waiting on execution of LOCK TABLE
statements (presumably stuck commits) in
relstorage.adapters.locker.PostgreSQLLocker.hold_commit_lock [1].

Any ideas on what I should be looking for in PostgreSQL and possible
causes in my application?


Sean


[1] Call stack via SIGUSR1 to an instance: http://pastie.org/9400704