Horton
Menu

Re: BUG #14243: pg_basebackup failes by a STATUS_DELETE_PENDING file

Alvaro Herrera <alvherre@2ndquadrant.com>

View thread
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Michael Paquier <michael.paquier@gmail.com>
Cc: Magnus Hagander <magnus@hagander.net>, Tom Lane <tgl@sss.pgh.pa.us>, Amit Kapila <amit.kapila16@gmail.com>, TAKATSUKA Haruka <harukat@sraoss.co.jp>, PostgreSQL Bugs <pgsql-bugs@postgresql.org>
Date: 2016-09-29T14:34:10Z
Lists: pgsql-bugs 
Michael Paquier wrote:

> I gave this bug another try and let Windows run for some time but I
> cannot reproduce the original failure even with manual checkpointing
> and aggressive checkpoint_timeout, while truncating relations heavily
> with pgbench to enforce the deletion of relfilenodes. To all, do you
> think that having a large relfilenode file matters to trigger this
> issue?

Hmm, perhaps with a larger file the OS spends more time shredding the
file or something like that?  Perhaps there are filesystem options
involved, for instance.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services