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

Re: Problem with ALTER TABLE - occasional "tuple concurrently updated"

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Problem with ALTER TABLE - occasional "tuple concurrently updated"
Date: 2011-03-11 14:30:29
Message-ID: AANLkTikiQWUBAa6hJNaosx=eUqorb+36Jr9Cw7XMdWB9@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Thu, Mar 10, 2011 at 10:37 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> Robert Haas wrote:
>> On Thu, Mar 10, 2011 at 4:08 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
>> > Was this fixed?
>>
>> Not yet.  I can probably fix it, if nobody else wants to do it.
>
> Well, it has languished for five months, so the "nobody else wants" part
> is probably accurate.  ;-)

OK.  Do we want to back-patch this, and if so how far?  On the one
hand, the symptom that OP is experiencing clearly sucks for him, but
on the other hand upgrading the strength of a lock in releases that
have been out in the field for a long time seems like an open
invitation to have the villagers show up with pitchforks.  Then again,
ShareUpdateExclusiveLock doesn't interfere with routine queries, so
maybe it's no big deal.  Given that we have only one report, I'm
inclined to just fix it in the master branch, but I could easily be
talked into the other approach if someone wants to make an argument
for it.

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

In response to

Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2011-03-11 14:31:39
Subject: Re: Problem with ALTER TABLE - occasional "tuple concurrently updated"
Previous:From: Ingmar BrounsDate: 2011-03-11 13:18:29
Subject: BUG #5926: information schema dtd_identifier for element_types, columns, parameters views inconsistent

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