Re: Lock pileup stuck processes - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Lock pileup stuck processes
Date
Msg-id 5284.1460588789@sss.pgh.pa.us
Whole thread Raw
In response to Lock pileup stuck processes  (Josh berkus <josh@agliodbs.com>)
List pgsql-bugs
Josh berkus <josh@agliodbs.com> writes:
> Summary: in some cases, "lock pileups" fail to resolve completely, and
> one or more orphan backends are left in permanent lock-waiting state.
> ...
> My attempts to reproduce this issue under synthetic circumstances have
> not been successful.  strace of the stuck backends shows no activity.

Please see if you can get a stack trace from a stuck backend.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Josh berkus
Date:
Subject: Lock pileup stuck processes
Next
From: Nick Cleaton
Date:
Subject: Re: Repeated requests for feedback in logical standby