Archive WAL Logs Failed - Mailing list pgsql-admin

From Subbiah, Stalin
Subject Archive WAL Logs Failed
Date
Msg-id B949C470120CA7499A211214D76FBA5801C47AA6@mxca2.corp.netopia.com
Whole thread Raw
Responses Re: Archive WAL Logs Failed
Re: Archive WAL Logs Failed
List pgsql-admin

Hi All,

Yesterday, we'd archiver problems in copying archived wal files from pg_xlog to archive destination at the end of full hotbackup. Below are the errors from server logs.

What makes me to wonder is that why does archiver tries to copy "000000010000000800000074.0066C9C0.backup" again when it's already been archived. As soon I removed "000000010000000800000074.0066C9C0.backup" from archive location, then archiver was happy to copy again and moved on to archiving 000000010000000800000074 etc.

2006-11-07 00:35:23 CST  LOG:  archived transaction log file "000000010000000800000074.0066C9C0.backup"
2006-11-07 00:35:23 CST  LOG:  archive command "test ! -f /b01/pgdata/archive/db1/000000010000000800000074.0066C9C0.backup && cp pg_xlog/000000010000000800000074.0066C9C0.backup /b01/pgdata/archive/db1/000000010000000800000074.0066C9C0.backup" failed: return code 256

Any idea what may be going on here.

Thanks,
Stalin

PG814, RH4.0

pgsql-admin by date:

Previous
From: Alexander Burbello
Date:
Subject: Use Jobs
Next
From: "Mark Steben"
Date:
Subject: Question