Re: Continuous archiving fails routinely with "invalid magic number" error

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Bruce Reed" <breed(at)dvdplay(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: Continuous archiving fails routinely with "invalid magic number" error
Date: 2009-05-29 00:18:20
Message-ID: 4A1EE37C.EE98.0025.1@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Bruce Reed" <breed(at)dvdplay(dot)com> wrote:

> May 26 08:58:55 ods2-prod postgres[3827]: [1427-1] LOG: invalid
> magic number 0000 in log file 194, segment 229, offset 10780672

Try copying to a different name or directory on the target volume and
renaming or moving into place. It sounds as though maybe the copy is
allocating the file at full size and then copying in the contents, and
the recovery process is sometimes picking it up before it's done.
Either that or the file is being corrupted in transit.

-Kevin

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2009-05-29 00:21:13 Re: Pre-creating partitions incurs insert penalty
Previous Message Bruce Reed 2009-05-29 00:01:57 Continuous archiving fails routinely with "invalid magic number" error