Re: [GENERAL] 8.1.4 - problem with PITR - .backup.done / backup.ready version of the same file at the same time.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Rafael Martinez, Guerrero" <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [GENERAL] 8.1.4 - problem with PITR - .backup.done / backup.ready version of the same file at the same time.
Date: 2006-05-30 13:45:57
Message-ID: 23221.1148996757@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

"Rafael Martinez, Guerrero" <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no> writes:
> The problem was that 000000010000000800000010.0006D5E8.backup was
> already archived, but under pg_xlog/archive_status/ there were two
> files:
> -------------------------------------------------
> 000000010000000800000010.0006D5E8.backup.done
> 000000010000000800000010.0006D5E8.backup.ready
> -------------------------------------------------

> This situation should not happen, anyone has seen this problem before?

No, it shouldn't. What I suspect is that XLogArchiveIsDone() got
confused and created a duplicate .ready file. It basically assumes
that the only way its stat() calls can fail is ENOENT, ie, file not
there ... but I wonder if they failed for some other reason instead.
What sort of platform and filesystem is this on?

Did you happen to make note of the mod times of the two files before
deleting them?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tatsuo Ishii 2006-05-30 13:48:38 Re: Charset conversion error
Previous Message Lars Haugseth 2006-05-30 13:39:48 Compound words giving undesirable results with tsearch2

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2006-05-30 14:01:49 Re: [PATCH] Improve EXPLAIN ANALYZE overhead by sampling
Previous Message Andrew Dunstan 2006-05-30 13:41:59 Re: plperl's ppport.h out of date?