Re: Remaining Streaming Replication Open Items - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: Remaining Streaming Replication Open Items
Date
Msg-id l2l3f0b79eb1004140132p31cf6416ka76de09d59fa0564@mail.gmail.com
Whole thread Raw
In response to Re: Remaining Streaming Replication Open Items  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: Remaining Streaming Replication Open Items  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
On Wed, Apr 14, 2010 at 12:49 AM, Heikki Linnakangas
<heikki.linnakangas@enterprisedb.com> wrote:
> We have the emode_for_corrupt_record() function that's used in all the
> errors that indicate a corrupt WAL record, that's a perfect place to
> hook this into. See attached patch.

One problem of the patch is that even if the content of error message
is different from the past, it would be skipped when the location of
invalid record is the same of the past. For example, if there is a
partially-filled unbroken WAL file in the standby, the following
message would be written:
   record with zero length at %X/%X

Then if you drop corrupted WAL file into pg_xlog, the following message
might have to be output, but would be skipped:
   invalid magic number %04X in log file %u, segment %u, offset %u


But I think that we might be able to live with the issue since it's
a very corner case.

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center


pgsql-hackers by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: a faster compression algorithm for pg_dump
Next
From: Dimitri Fontaine
Date:
Subject: Re: testing HS/SR - 1 vs 2 performance