[GENERAL] startup process stuck in recovery

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема [GENERAL] startup process stuck in recovery
Дата
Msg-id B1A01387-19A7-4F0F-A351-5D5EECCAEDDD@thebuild.com
обсуждение исходный текст
Ответы Re: [GENERAL] startup process stuck in recovery  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [GENERAL] startup process stuck in recovery  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-general
Hi,

We're dealing with a 9.5.5 database with the symptom that, after a certain amount of time after restart, the startup
processreaches a certain WAL segment, and stops.  The startup process runs at 100% CPU, with no output from strace.
Thereare no queries running on the secondary, so it's not a delay for queries.  The WAL receiver continues to operate
normally,and we can see sent_location / write_location / flush_location continue to move ahead in parallel, with
replay_locationstuck in that WAL segment. 

Suggestions on further diagnosis?

--
-- 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 по дате отправления:

Предыдущее
От: "Igal @ Lucee.org"
Дата:
Сообщение: Re: [GENERAL] Permissions for Web App
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] startup process stuck in recovery