Re: 9.1.3 backends getting stuck in 'startup' - Mailing list pgsql-bugs

From Jeff Frost
Subject Re: 9.1.3 backends getting stuck in 'startup'
Date
Msg-id 4F9AEB6A.9060706@pgexperts.com
Whole thread Raw
In response to Re: 9.1.3 backends getting stuck in 'startup'  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: 9.1.3 backends getting stuck in 'startup'  (Jeff Frost <jeff@pgexperts.com>)
List pgsql-bugs
On 04/27/12 10:14, Tom Lane wrote:
> Jeff Frost <jeff@pgexperts.com> writes:
>> A few times today, we've seen postgresql 9.1.3 backends on Ubuntu 11.10 x86_64
>> get stuck in 'startup' mode.
> Well, the one you backtraced seems to be waiting for somebody else to
> release one of the buffer mapping locks ... which is not a lock I'd
> expect to get held long, ever.  Could you check all the Postgres
> processes and see which of them have backtraces different from that?
> We need to figure out what's sitting on that lock and why.
>

Thanks Tom.  We've failed over to the replica which seems to have the issue
happen less often, so I'll try and get the backtraces as soon as it's reproduced.

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: BUG #6619: Misleading output from slave when host is not running
Next
From: Jeff Frost
Date:
Subject: Re: 9.1.3 backends getting stuck in 'startup'