Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #8701: recover process hang on slave - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #8701: recover process hang on slave
Date
Msg-id 20131226193001.GO22570@eldon.alvh.no-ip.org
Whole thread Raw
In response to BUG #8701: recover process hang on slave  (amutu@amutu.com)
List pgsql-bugs
Tree view 
amutu@amutu.com wrote:

> we have a master and two streaming salve pg.we find One of the slave
> replay_location is far behand the other.
>
>
> both sent_location is BF1/921F6000;the write_location and flush_location is
> similar;but one of the server replay_location is BF1/9210DD10，the oter is
> 6DE/D958E8.
>
> on the abnormal server，top show that a postgres process replay the
> 00000001000006DE00000000 WAL，and the process take up 100% usage of the cpu
> core.

Perhaps you can try to pg_xlogdump the offending pg_xlog file?

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

pgsql-bugs by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: BUG #8676: Bug Money JSON
Next
From: Sergey Konoplev
Date:
Subject: Re: BUG #8701: recover process hang on slave