Re: PG13 pg_receivewal failing

From: Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>
To: Grigory Smolkin <g(dot)smolkin(at)postgrespro(dot)ru>, Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: PG13 pg_receivewal failing
Date: 2020-09-25 00:46:58
Message-ID: 11943c9a-de5f-36ff-5f97-270488507177@oss.nttdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 2020/09/25 5:51, Grigory Smolkin wrote:
> Hello!
>
> I`ve encountered the following error when trying to stream WAL via pg_receivewal:
>
> pg_receivewal -p 11770 --synchronous -D /wal/node -v
> pg_receivewal: starting log streaming at 0/1000000 (timeline 1)
> pg_receivewal: error: unexpected termination of replication stream: ERROR:  requested WAL segment 000000010000000000000001 has already been removed
> pg_receivewal: disconnected; waiting 5 seconds to try again
>
>
> Is there something awry with start position calculation, or am I doing something wrong?

I guess that 000000010000000000000001.partial file remained in /wal/node
and pg_receivewal used 0/1000000 as the starting WAL position.

Regards,

--
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David Rowley 2020-09-25 01:49:15 Re: BUG #15383: Join Filter cost estimation problem in 10.5
Previous Message Bruce Momjian 2020-09-24 21:07:03 Re: BUG #16628: Hostame and string connection functions