Re: backends stuck in "startup" - Mailing list pgsql-general

From Tom Lane
Subject Re: backends stuck in "startup"
Date
Msg-id 6177.1511306476@sss.pgh.pa.us
Whole thread Raw
In response to backends stuck in "startup"  (Justin Pryzby <pryzby@telsasoft.com>)
Responses Re: backends stuck in "startup"
List pgsql-general
Justin Pryzby <pryzby@telsasoft.com> writes:
> As $subject: backends are stuck in startup for minutes at a time.  I didn't
> strace this time, but I believe last time I saw one was waiting in a futex.

Hm...

> I saved ~40 cores from backends from the most recent incident, which are all
> essentially identical:

This one seems to be waiting for a shared LWLock (specifically, one of
the locks for the shared-buffer lookup hashtable), which could only block
if someone else is holding that lock exclusively, which implies that
there's at least one backtrace that's different from this.  Unless you
can find what was holding that lock, there's not much we can learn from
this report ...
        regards, tom lane


pgsql-general by date:

Previous
From: Justin Pryzby
Date:
Subject: backends stuck in "startup"
Next
From: Andres Freund
Date:
Subject: Re: backends stuck in "startup"