pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: KADDBA <sqlora@gmail.com>
To: pgsql-admin@postgresql.org
Subject: WAL archiving hangs due to missing WAL segment
Date: Tue, 4 Dec 2007 07:05:05 -0800 (PST)
Message-ID: <14152262.post@talk.nabble.com> (raw)


Hi,
I recently had set up WAL archiving in a testing environment and all went
well. As a test I let the disk fill up until archiving no longer was
possible. 
Then a co-worker noticed this disk filling up and removed some WALL
segments, that were not yet archived. Now the archiving proces hangs.
Messages in logfile:

2007-12-04 15:20:50 MET  LOG:  archive command "cp
"pg_xlog/00000001000000010000003A"
/u002/postgresql/admin/mdbp/arch/"archive_wal_00000001000000010000003A""
failed: return code 256
2007-12-04 15:20:51 MET  DEBUG:  executing archive command "cp
"pg_xlog/00000001000000010000003A"
/u002/postgresql/admin/mdbp/arch/"archive_wal_00000001000000010000003A""
cp: cannot access pg_xlog/00000001000000010000003A: No such file or
directory
2007-12-04 15:20:51 MET  LOG:  archive command "cp
"pg_xlog/00000001000000010000003A"
/u002/postgresql/admin/mdbp/arch/"archive_wal_00000001000000010000003A""
failed: return code 256
2007-12-04 15:20:51 MET  WARNING:  transaction log file
"00000001000000010000003A" could not be archived: too many failures


How can I resolve this issue? I only have WALL segments from
000000010000000100000080 so I am missing all segments from
00000001000000010000003A upto 000000010000000100000080.


-- 
View this message in context: http://www.nabble.com/WAL-archiving-hangs-due-to-missing-WAL-segment-tf4943617.html#a14152262
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.




Message-ID: <14152262.post@talk.nabble.com>
Permalink:  ../14152262.post@talk.nabble.com/
Also on:    postgresql.org/message-id/14152262.post@talk.nabble.com

 · 

reply

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-admin@postgresql.org
  Cc: sqlora@gmail.com
  Subject: Re: WAL archiving hangs due to missing WAL segment
  In-Reply-To: <14152262.post@talk.nabble.com>

* 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