Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kLiuF-0003re-VF for pgsql-bugs@arkaria.postgresql.org; Fri, 25 Sep 2020 08:16:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kLiuE-0007jm-JH for pgsql-bugs@arkaria.postgresql.org; Fri, 25 Sep 2020 08:16:38 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kLiuE-0007je-BB for pgsql-bugs@lists.postgresql.org; Fri, 25 Sep 2020 08:16:38 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kLiu7-0007cW-4V for pgsql-bugs@postgresql.org; Fri, 25 Sep 2020 08:16:37 +0000 Received: from [192.168.1.6] (109-252-84-199.nat.spd-mgts.ru [109.252.84.199]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) by mail.postgrespro.ru (Postfix) with ESMTPSA id BBA5821C389A; Fri, 25 Sep 2020 11:16:28 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1601021788; bh=4e57nUgRcCO+9I65Z6cBCgmfIWop86g9zmhD3FWfidc=; h=Subject:To:References:From:Date:In-Reply-To; b=YuXZbS4OmxOKQhk/SPVaVxdGSik1KvOzT+jsd6y28gbyEHNgvzFu7Ca/UsNDDYZzf fGJU7kCI9jQbgXst5pN1164kKbo3uFdw7VNmJ3WqlYdLl6m9FI3PtTMxHSzaE6sxtL LuHNgAZCQ5nh0tqin3tHYx5xzcBUf0NofX5+FjoQ= Subject: Re: PG13 pg_receivewal failing To: Fujii Masao , Pg Bugs References: <549e0057-05dc-9310-92c7-45bf93a3a192@postgrespro.ru> <11943c9a-de5f-36ff-5f97-270488507177@oss.nttdata.com> From: Grigory Smolkin Message-ID: <6972d399-09f9-b00e-7702-28cdd2a0b299@postgrespro.ru> Date: Fri, 25 Sep 2020 11:16:28 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.8.0 MIME-Version: 1.0 In-Reply-To: <11943c9a-de5f-36ff-5f97-270488507177@oss.nttdata.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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