Re: BUG #6497: Error sent to client, but data written anyway - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6497: Error sent to client, but data written anyway
Date
Msg-id 7955.1330550118@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #6497: Error sent to client, but data written anyway  (Christophe Pettus <xof@thebuild.com>)
Responses Re: BUG #6497: Error sent to client, but data written anyway
List pgsql-bugs
Christophe Pettus <xof@thebuild.com> writes:
> On Feb 29, 2012, at 9:26 AM, Ryan Lowe wrote:
>> Thanks for all the responses, but I think I'm being unclear here.

> The point Tom was making is that this is indistinguishable from the scenario:

> 1. Client sends commit.
> 2. Server successfully commits data.
> 3. Server starts to write response.
> 4. Network fails.
> 5. Client receives abnormal disconnection response from its network connection to the server.

Well, that's the argument as to why the client code has to be capable of
checking whether the commit happened if it's going to attempt a
reconnect and retry.  But there's a quite separate question as to
whether the behavior Ryan is claiming for a pre-commit crash is actually
possible.  I don't believe it, and I failed to reproduce his test
scenario.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: BUG #6497: Error sent to client, but data written anyway
Next
From: Christophe Pettus
Date:
Subject: Re: BUG #6497: Error sent to client, but data written anyway