| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | amutu(at)amutu(dot)com |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #8701: recover process hang on slave |
| Date: | 2013-12-26 19:30:01 |
| Message-ID: | 20131226193001.GO22570@eldon.alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
amutu(at)amutu(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergey Konoplev | 2013-12-26 21:47:00 | Re: BUG #8701: recover process hang on slave |
| Previous Message | Andrew Dunstan | 2013-12-26 18:17:10 | Re: BUG #8676: Bug Money JSON |