Skip site navigation (1) Skip section navigation (2)

Re: 9.1.3 backends getting stuck in 'startup'

From: Jeff Frost <jeff(at)pgexperts(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: 9.1.3 backends getting stuck in 'startup'
Date: 2012-04-27 18:54:34
Message-ID: 4F9AEB6A.9060706@pgexperts.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On 04/27/12 10:14, Tom Lane wrote:
> Jeff Frost <jeff(at)pgexperts(dot)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.

In response to

Responses

pgsql-bugs by date

Next:From: Jeff FrostDate: 2012-04-27 19:14:06
Subject: Re: 9.1.3 backends getting stuck in 'startup'
Previous:From: Robert HaasDate: 2012-04-27 18:29:03
Subject: Re: BUG #6619: Misleading output from slave when host is not running

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group