From: Tom Lane <tgl@sss.pgh.pa.us>
To: Brendan Duddridge <brendan@clickspace.com>
Cc: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Recovery will take 10 hours
Date: Thu, 20 Apr 2006 19:20:47 -0400
Message-ID: <1124.1145575247@sss.pgh.pa.us> (raw)
In-Reply-To: <3D29F1D5-D0E8-4291-8426-CD0EBD6EC5F5@clickspace.com>
References: <85A15B2E-F59C-4FEF-82D4-61F48ABDCDE5@clickspace.com>
<29439.1145564220@sss.pgh.pa.us>
<47C1F053-EC91-4AEB-9F0B-B538716145D6@clickspace.com>
<105.1145567988@sss.pgh.pa.us>
<3D29F1D5-D0E8-4291-8426-CD0EBD6EC5F5@clickspace.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, brendan@clickspace.com
Subject: Re: Recovery will take 10 hours
In-Reply-To: <1124.1145575247@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox