streaming replication - crash on standby

From: "Seong Son (US)" <Seong(dot)Son(at)datapath(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: streaming replication - crash on standby
Date: 2017-08-09 22:03:43
Message-ID: BY2PR17MB03282D3F74E7724DCA6807F2848B0@BY2PR17MB0328.namprd17.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The last line from pg_xlogdump of the last WAL file on the crashed standby server shows the following.

pg_xlogdump: FATAL: error in WAL record at DF/4CB95FD0: unexpected pageaddr DB/62B96000 in log segment 00000000000000DF0000004C, offset 12148736

I believe this means the standby server received WAL file out of order? But why did it crash? Is crashing normal behavior in case like this?

Thanks,
Seong

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2017-08-09 22:08:11 Re: Interesting streaming replication issue
Previous Message marcelo 2017-08-09 21:28:25 Re: ErrorCode=-2147467259 storing a .net string