Re: loss of transactions in streaming replication - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: loss of transactions in streaming replication
Date
Msg-id CAHGQGwEV5qAU+n+QC894oTCmgOdeX3bT2tKY_JEU4bdkp-P9GQ@mail.gmail.com
Whole thread Raw
In response to Re: loss of transactions in streaming replication  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: loss of transactions in streaming replication  (Fujii Masao <masao.fujii@gmail.com>)
List pgsql-hackers
On Wed, Oct 12, 2011 at 10:29 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Wed, Oct 12, 2011 at 5:45 AM, Fujii Masao <masao.fujii@gmail.com> wrote:
>> In 9.2dev and 9.1, when walreceiver detects an error while sending data to
>> WAL stream, it always emits ERROR even if there are data available in the
>> receive buffer. This might lead to loss of transactions because such
>> remaining data are not received by walreceiver :(
>
> Won't it just reconnect?

Yes if the master is running normally. OTOH, if the master is not running (i.e.,
failover case), the standby cannot receive again the data which it failed to
receive.

I found this issue when I shut down the master. When the master shuts down,
it sends the shutdown checkpoint record, but I found that the standby failed
to receive it.

Regards,

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


pgsql-hackers by date:

Previous
From: Alex Hunsaker
Date:
Subject: Re: Patch: Perl xsubpp
Next
From: Josh Kupershmidt
Date:
Subject: Re: pg_comments (was: Allow \dd to show constraint comments)