Re: slru.c race condition

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: slru.c race condition
Date: 2005-11-01 19:41:44
Message-ID: 603bmg9mvb.fsf@dba2.int.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

jnasby(at)pervasive(dot)com ("Jim C. Nasby") writes:

> On Tue, Nov 01, 2005 at 11:23:55AM -0300, Alvaro Herrera wrote:
>> Tom Lane wrote:
>> > "Jim C. Nasby" <jnasby(at)pervasive(dot)com> writes:
>> > > AFAIK they're not using subtransactions at all, but I'll check.
>> >
>> > Well, yeah, they are ... else you'd never have seen this failure.
>>
>> Maybe it's in plpgsql EXCEPTION clauses.
>
> Err, I forgot they're using Slony, which is probably using savepoints
> and/or exceptions.

Slony-I does use exceptions in pretty conventional ways; it does *not*
make any use of subtransactions, because it needs to run on PG 7.3 and
7.4 that do not support subtransactions.
--
(format nil "~S(at)~S" "cbbrowne" "acm.org")
http://www3.sympatico.ca/cbbrowne/linuxxian.html
"I can't believe my room doesn't have Ethernet! Why wasn't it wired
when the house was built?"
"The house was built in 1576."
-- Alex Kamilewicz on the Oxford breed of `conference American.'

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Chris Browne 2005-11-01 19:50:57 Re: slru.c race condition
Previous Message Tom Lane 2005-11-01 19:22:38 Re: slru.c race condition (was Re: TRAP: FailedAssertion("!((itemid)->lp_flags & 0x01)", )

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2005-11-01 19:43:35 Re: Final cleanup of SQL:1999 references
Previous Message Tom Lane 2005-11-01 19:22:38 Re: slru.c race condition (was Re: TRAP: FailedAssertion("!((itemid)->lp_flags & 0x01)", )