Re: backends stuck in "startup"

Justin Pryzby <pryzby(at)telsasoft(dot)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