Re: BUG #5622: Query failed: server closed the connection unexpectedly - Mailing list pgsql-bugs

From Thue Janus Kristensen
Subject Re: BUG #5622: Query failed: server closed the connection unexpectedly
Date
Msg-id AANLkTin4miDoeFRqrqOr=LO17j5MLEpLNciAQ3WSGhcB@mail.gmail.com
Whole thread Raw
In response to Re: BUG #5622: Query failed: server closed the connection unexpectedly  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Thu, Aug 19, 2010 at 5:19 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Thue Janus Kristensen <thuejk@gmail.com> writes:
> > I finally succeeded in creating a test case, after much experimentation.
> > Running the attached sql crashes my postgresql server 100% of the time.
>
> Cute problem.


Generating the test case was very "interesting" black box debugging. Now why
does it need at least 7 (and not 1-6) updates to that unrelated row in that
unrelated table to crash...? At least it was deterministic.


>  The attached fix cures it for me; would you see if it
> solves your original case too?
>

Yes, it fixes my original problem too, thanks :).

Regards, Thue

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: COPY FROM/TO losing a single byte of a multibyte UTF-8 sequence
Next
From: Tatsuo Ishii
Date:
Subject: Re: COPY FROM/TO losing a single byte of a multibyte UTF-8 sequence