Archive WAL Logs Failed

From: "Subbiah, Stalin" <SSubbiah(at)netopia(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Archive WAL Logs Failed
Date: 2006-11-07 18:15:01
Message-ID: B949C470120CA7499A211214D76FBA5801C47AA6@mxca2.corp.netopia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mark Steben 2006-11-07 20:17:32 Question
Previous Message Alexander Burbello 2006-11-07 17:34:36 Use Jobs