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

From Fujii Masao
Subject loss of transactions in streaming replication
Date
Msg-id CAHGQGwEEm1TpNZvuMh08ZB2kVCvyAeFkdUwdXPJYYC8jaf_N1A@mail.gmail.com
Whole thread Raw
Responses Re: loss of transactions in streaming replication
List pgsql-hackers
Hi,

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 :(

To prevent transaction loss, I'm thinking to change walreceiver so that it
always ignores an error (specifically, emits COMMERROR instead of ERROR)
during sending data. Then walreceiver receives data if available. If an error
occurrs during receiving data, walreceiver can emit ERROR this time.
Comments? Better ideas?

Regards,

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


pgsql-hackers by date:

Previous
From: Amit Khandekar
Date:
Subject: pl/perl example in the doc no longer works in 9.1
Next
From: Kohei KaiGai
Date:
Subject: Re: [v9.2] DROP statement reworks