Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id AB26F9FA173 for ; Tue, 7 Nov 2006 14:34:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 02108-06-2 for ; Tue, 7 Nov 2006 14:34:35 -0400 (AST) X-Greylist: delayed 00:20:26.751125 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id BFFE39FB249 for ; Tue, 7 Nov 2006 14:34:32 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mxca2.corp.netopia.com (mx-us-west.netopia.com [65.206.239.221]) by svr4.postgresql.org (Postfix) with ESMTP id 6E8C95AF96B for ; Tue, 7 Nov 2006 18:14:04 +0000 (GMT) X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C70298.A494895F" Subject: Archive WAL Logs Failed Date: Tue, 7 Nov 2006 10:15:01 -0800 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Archive WAL Logs Failed Thread-Index: AccCmH3Kbcr5lJFyRRWur7sRr8lbMA== From: "Subbiah, Stalin" To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/52 X-Sequence-Number: 23579 This is a multi-part message in MIME format. ------_=_NextPart_001_01C70298.A494895F Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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 ------_=_NextPart_001_01C70298.A494895F Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Archive WAL Logs Failed

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



------_=_NextPart_001_01C70298.A494895F--