Re: [GENERAL] startup process stuck in recovery - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] startup process stuck in recovery
Date
Msg-id 32383.1507576243@sss.pgh.pa.us
Whole thread Raw
In response to [GENERAL] startup process stuck in recovery  (Christophe Pettus <xof@thebuild.com>)
Responses Re: [GENERAL] startup process stuck in recovery  (Christophe Pettus <xof@thebuild.com>)
List pgsql-general
Christophe Pettus <xof@thebuild.com> writes:
> 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?

Attach to startup process with gdb, and get a stack trace?
        regards, tom lane


--
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 by date:

Previous
From: Christophe Pettus
Date:
Subject: [GENERAL] startup process stuck in recovery
Next
From: Christophe Pettus
Date:
Subject: Re: [GENERAL] startup process stuck in recovery