Re: "tuple concurrently updated" during index deletion

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: "tuple concurrently updated" during index deletion
Дата
Msg-id 469647A1.20009@joeconway.com
обсуждение исходный текст
Ответ на Re: "tuple concurrently updated" during index deletion  ("Simon Riggs" <simon@2ndquadrant.com>)
Список pgsql-hackers
Simon Riggs wrote:
> On Wed, 2007-07-11 at 16:49 -0700, Joe Conway wrote:
>> On cvs head, I can get "tuple concurrently updated" if two separate 
>> transactions are both trying to drop the same index:
> 
>>    ERROR:  tuple concurrently updated
> 
>> The reason I ask is that someone contacted me who is seeing this on a 
>> production system, and the abort on session #2 is rolling back a large 
>> bulkload.
> 
> This situation will always cause an error on session #2, since if you
> lock this more closely you'll get an ERROR because the object does not
> exist. 

That's a really good point. In any case I had already asked them to look 
into moving the index related DDL outside the data loading transaction.

Thanks,

Joe



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: 2PC-induced lockup
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: compiler warnings on the buildfarm