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

From andres@anarazel.de (Andres Freund)
Subject Re: backends stuck in "startup"
Date
Msg-id 20171121235239.5ssxkvmfwvhxavsm@alap3.anarazel.de
Whole thread Raw
In response to Re: backends stuck in "startup"  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: backends stuck in "startup"  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: backends stuck in "startup"  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-general
On 2017-11-21 18:50:05 -0500, Tom Lane wrote:
> Andres Freund <andres@anarazel.de> writes:
> > On 2017-11-21 18:21:16 -0500, Tom Lane wrote:
> >> 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.
> 
> > A futex? Hm, that was stock postgres?
> 
> Sure, since we switched to unnamed-POSIX semaphores in v10.  On Linux
> those are futexes.

> (If Justin saw that while still on 9.6, then it'd be worth looking
> closer.)

Right. I took this to be referring to something before the current
migration, but I might have overinterpreted things. There've been
various forks/ports of pg around that had hand-coded replacements with
futex usage, and there were definitely buggy versions going around a few
years back.

Greetings,

Andres Freund


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: backends stuck in "startup"
Next
From: Tom Lane
Date:
Subject: Re: backends stuck in "startup"