Re: Concurrency issue in pg_rewind - Mailing list pgsql-hackers

From Oleksandr Shulgin
Subject Re: Concurrency issue in pg_rewind
Date
Msg-id CACACo5RkdXNBNWH_-GLjtN3UwF6rT1wDz0Xw+Hy6zp-JEBMUwA@mail.gmail.com
Whole thread Raw
In response to Concurrency issue in pg_rewind  (Alexander Kukushkin <cyberdemn@gmail.com>)
Responses Re: Concurrency issue in pg_rewind  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
On Wed, Sep 16, 2020 at 2:55 PM Alexander Kukushkin <cyberdemn@gmail.com> wrote:

The second time pg_rewind also failed, but the error looked differently:
servers diverged at WAL location A76/39E55338 on timeline 132
rewinding from last common checkpoint at A76/1EF254B8 on timeline 132

could not remove file
"/home/postgres/pgdata/pgroot/data/pg_wal/.wal-g/prefetch/running/0000008400000A7600000024":

Ouch.  I think pg_rewind shouldn't try to remove any random files in pg_wal that it doesn't know about.
What if the administrator made a backup of some WAL segments there?

--
Alex

pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: pgindent vs dtrace on macos
Next
From: Ajin Cherian
Date:
Subject: Re: [HACKERS] logical decoding of two-phase transactions