Re: Connections hang indefinitely while taking a LWLockTranche buffer_content lock.

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Chris Hanks <christopher.m.hanks@gmail.com>
Cc: pgsql-bugs@postgresql.org
Date: 2017-10-22T18:39:56Z
Lists: pgsql-bugs

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. Add pages deleted from pending list to FSM

Chris Hanks <christopher.m.hanks@gmail.com> writes:
> I'm encountering a locking issue in Postgres. I unfortunately haven't
> been able to make a reproduction for it, but it's occurred a few times
> on different machines, and I have access to two machines that are
> currently locked up, so I'm hoping that someone can help anyway.

If you could get stack traces from the stuck backends, that would be
pretty helpful.

			regards, tom lane