From: Grigory Smolkin <g.smolkin@postgrespro.ru>
To: Fujii Masao <masao.fujii@oss.nttdata.com>
To: Pg Bugs <pgsql-bugs@postgresql.org>
Subject: Re: PG13 pg_receivewal failing
Date: Fri, 25 Sep 2020 11:16:28 +0300
Message-ID: <6972d399-09f9-b00e-7702-28cdd2a0b299@postgrespro.ru> (raw)
In-Reply-To: <11943c9a-de5f-36ff-5f97-270488507177@oss.nttdata.com>
References: <549e0057-05dc-9310-92c7-45bf93a3a192@postgrespro.ru>
<11943c9a-de5f-36ff-5f97-270488507177@oss.nttdata.com>
On 9/25/20 3:46 AM, Fujii Masao wrote:
>
>
> 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.
True, thank you very much!
>
> Regards,
>
--
Grigory Smolkin
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: g.smolkin@postgrespro.ru, masao.fujii@oss.nttdata.com
Subject: Re: PG13 pg_receivewal failing
In-Reply-To: <6972d399-09f9-b00e-7702-28cdd2a0b299@postgrespro.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox