[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
Re: [GENERAL] startup process stuck in recovery |
Список | 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 по дате отправления: