Re: Failing start-up archive recovery at Standby mode in PG9.2.4 - Mailing list pgsql-hackers

From Kyotaro HORIGUCHI
Subject Re: Failing start-up archive recovery at Standby mode in PG9.2.4
Date
Msg-id CAM103DvJHSBYdFwhy6f4jmHvg9AGhxCunzeYGikcfekPAGqp3g@mail.gmail.com
Whole thread Raw
In response to Re: Failing start-up archive recovery at Standby mode in PG9.2.4  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: Failing start-up archive recovery at Standby mode in PG9.2.4
Re: Failing start-up archive recovery at Standby mode in PG9.2.4
List pgsql-hackers
Hello,

> > cp: cannot stat `../arc/000000030000000000000013': そのようなファイルやディレクトリはありません
> > [Standby] 2013-04-22 01:27:25 EDTLOG:  00000: restored log file "000000020000000000000013" from archive

> I can't read the error message here, but this looks suspicious.

The error message is "No such file or directory" in Japanese :-).
Perhaps restore_command is 'cp ../arc/%f %p'.

> The recovery command seems to be returning success although it prints such
an error message?

It seems that, on 9.2.4, RestoreArchivedFile returns expected xlog
filename even if the restore command ends up in failure. And the
caller XLogFileOpen successfully ets and returns fd for the filename
if the file exists since before the restoration attempt. It does not
matter when the existing file and the file expected to be restored are
identical in content.

If the segment includes the timeline increment point, something might
happen, I suppose..

regards,

-- 
Kyotaro Horiguchi



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Fast promotion, loose ends
Next
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Failing start-up archive recovery at Standby mode in PG9.2.4