Re: 9.1.3 backends getting stuck in 'startup'

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.