Skip site navigation (1) Skip section navigation (2)

Re: loss of transactions in streaming replication

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: loss of transactions in streaming replication
Date: 2011-11-30 20:37:24
Message-ID: CA+TgmobcopKvRbkdKh_qXEwMbQYa0Sg3xEu5cd1XcaOLzN_mqA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Mon, Oct 24, 2011 at 8:40 AM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
> On Fri, Oct 21, 2011 at 12:01 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>> On Thu, Oct 20, 2011 at 9:51 PM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
>>> On Thu, Oct 20, 2011 at 1:05 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>>>> OK, so this is an artifact of the changes to make libpq communication
>>>> bidirectional.  But I'm still confused about where the error is coming
>>>> from.  In your OP, you 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."  So
>>>> that implied to me that this is only going to trigger if you have a
>>>> shutdown together with an awkwardly-timed error.  But your scenario
>>>> for reproducing this problem doesn't seem to involve an error.
>>>
>>> Yes, my scenario doesn't cause any real error. My original description was
>>> misleading. The following would be closer to the truth:
>>>
>>>    "In 9.2dev and 9.1, when walreceiver detects the termination of replication
>>>    connection while sending data to WAL stream, it always emits ERROR
>>>    even if there are data available in the receive buffer."
>>
>> Ah, OK.  I think I now agree that this is a bug and that we should fix
>> and back-patch.
>
> The patch that I posted before is well-formed enough to be adopted?

Does this still need to be worked on?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

pgsql-hackers by date

Next:From: Robert HaasDate: 2011-11-30 20:38:26
Subject: Re: WIP: cross column stats revisited ...
Previous:From: Robert HaasDate: 2011-11-30 20:33:14
Subject: Re: Refactoring on DROP/ALTER SET SCHEMA/ALTER RENAME TO statement

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group