Re: [GENERAL] startup process stuck in recovery

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: [GENERAL] startup process stuck in recovery
Дата
Msg-id EF7FB2EB-3218-440B-89E7-30F0388AA303@thebuild.com
обсуждение исходный текст
Ответ на Re: [GENERAL] startup process stuck in recovery  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [GENERAL] startup process stuck in recovery  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
> On Oct 9, 2017, at 13:01, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Hmm.  Is it possible that the process is replaying the abort of a
> transaction with a lot of subtransactions?

That's possible, although we're now talking about an hours-long delay at this point.

> Is that number changing at all?

Increasing:

# select mode, count(*) from pg_locks where pid=5882 group by mode;       mode         | count
---------------------+-------ExclusiveLock       |     1AccessExclusiveLock |  8810
(2 rows)

--
-- Christophe Pettus  xof@thebuild.com



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] startup process stuck in recovery
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] startup process stuck in recovery