From: harukat@sraoss.co.jp
To: pgsql-bugs@postgresql.org
Subject: BUG #14243: pg_basebackup failes by a STATUS_DELETE_PENDING file
Date: Tue, 12 Jul 2016 08:32:20 +0000
Message-ID: <20160712083220.1426.58667@wrigleys.postgresql.org> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-bugs>
The following bug has been logged on the website:
Bug reference: 14243
Logged by: TAKATSUKA Haruka
Email address: harukat@sraoss.co.jp
PostgreSQL version: 9.6beta2
Operating system: Windows
Description:
pg_basebackup sometimes failed on Windows by "Permission denied".
This occured in PostgreSQL 9.1.x and I reproduced it in 9.6beta2.
C:\>pg_basebackup.exe -h localhost -U postgres
-D C:\dat\96datpg_basebackup: could not get backup header:
ERROR: could not stat file or directory "./base/16393/16444":
Permission denied
C:\Program Files\PostgreSQL\9.6\data\base\16393>dir /q 16444
C:\Program Files\PostgreSQL\9.6\data\base\16393 directory
2016/07/12 15:56 0 ... 16444
Dir command says the file 16444's owner is '...'.
It means file 16444 is in STATUS_DELETE_PENDING.
The other processes cannot open it, so it can
cause pg_basebackup to fail.
I think pg_basebackup should ignore files which is in
STATUS_DELETE_PENDING. But I cannot yet find an easy
method to realize it.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
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: harukat@sraoss.co.jp
Subject: Re: BUG #14243: pg_basebackup failes by a STATUS_DELETE_PENDING file
In-Reply-To: <20160712083220.1426.58667@wrigleys.postgresql.org>
* 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