Re: Use of ActiveSnapshot

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Use of ActiveSnapshot
Date: 2007-05-14 20:59:32
Message-ID: 4648CDB4.2080507@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 5/14/2007 4:26 PM, Tom Lane wrote:
> Jan Wieck <JanWieck(at)Yahoo(dot)com> writes:
>> Which means that the 8.3 fix for the reproducible backend crash, I
>> posted earlier, is to have SPI_cursor_open() save and restore
>> ActiveSnapshot while calling RevalidateCachedPlan(). I'll cross check
>> that this fixes this symptom and commit later today.
>
> No, the correct fix is to do that inside RevalidateCachedPlan ... and I
> already did it.

Works for me. It fixed the Slony test that actually tripped over the
bug. Thanks.

Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2007-05-14 21:13:09 Re: Concurrently updating an updatable view
Previous Message Tom Lane 2007-05-14 20:26:59 Re: Use of ActiveSnapshot