Re: Recovery will take 10 hours - Mailing list pgsql-performance

From Tom Lane
Subject Re: Recovery will take 10 hours
Date
Msg-id 1124.1145575247@sss.pgh.pa.us
Whole thread Raw
In response to Re: Recovery will take 10 hours  (Brendan Duddridge <brendan@clickspace.com>)
Responses Re: Recovery will take 10 hours  (Brendan Duddridge <brendan@clickspace.com>)
List pgsql-performance
Brendan Duddridge <brendan@clickspace.com> writes:
> However, as I just finished posting to the list, the process died
> with a PANIC error:

> [2006-04-20 16:41:28 MDT] LOG: restored log file
> "000000010000018F00000034" from archive
> [2006-04-20 16:41:35 MDT] LOG: restored log file
> "000000010000018F00000035" from archive
> [2006-04-20 16:41:38 MDT] LOG: restored log file
> "000000010000018F00000036" from archive
> sh: line 1: /wal_archive/000000010000018F00000037.gz: No such file or
> directory
> [2006-04-20 16:41:46 MDT] LOG: could not open file "pg_xlog/
> 000000010000018F00000037" (log file 399, segment 55): No such file or
> directory
> [2006-04-20 16:41:46 MDT] LOG: redo done at 18F/36FFF254
> sh: line 1: /wal_archive/000000010000018F00000036.gz: No such file or
> directory
> [2006-04-20 16:41:46 MDT] PANIC: could not open file "pg_xlog/
> 000000010000018F00000036" (log file 399, segment 54): No such file or
> directory

This looks to me like a bug in your archive restore command.  It had
just finished providing 000000010000018F00000036 at 16:41:38, why was
it not able to do so again at 16:41:46?

            regards, tom lane

pgsql-performance by date:

Previous
From: Brendan Duddridge
Date:
Subject: Re: Recovery will take 10 hours
Next
From: Jeff Frost
Date:
Subject: Re: Recovery will take 10 hours