Re: 9.1.3 backends getting stuck in 'startup'

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 9.1.3 backends getting stuck in 'startup'
Дата
Msg-id 23016.1335546879@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 9.1.3 backends getting stuck in 'startup'  (Jeff Frost <jeff@pgexperts.com>)
Ответы Re: 9.1.3 backends getting stuck in 'startup'  (Jeff Frost <jeff@pgexperts.com>)
Список pgsql-bugs
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.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Jeff Frost
Дата:
Сообщение: Re: 9.1.3 backends getting stuck in 'startup'
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Errors on CREATE TABLE IF NOT EXISTS