Skip site navigation (1) Skip section navigation (2)

BUG #14243: pg_basebackup failes by a STATUS_DELETE_PENDING file

From: harukat(at)sraoss(dot)co(dot)jp
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14243: pg_basebackup failes by a STATUS_DELETE_PENDING file
Date: 2016-07-12 08:32:20
Message-ID: 20160712083220.1426.58667@wrigleys.postgresql.org (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14243
Logged by:          TAKATSUKA Haruka
Email address:      harukat(at)sraoss(dot)co(dot)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.



Responses

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2016-07-12 13:21:28
Subject: Re: Incorrect Spanish error message.
Previous:From: David G. JohnstonDate: 2016-07-12 02:15:38
Subject: Re: BUG #14242: Role with a setconfig "role" setting to a nonexistent role causes pg_upgrade to fail

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group