ERROR: tuple concurrently updated when modifying privileges

Поиск
Список
Период
Сортировка
От nickb
Тема ERROR: tuple concurrently updated when modifying privileges
Дата
Msg-id ca9245dd-368d-479f-8c7e-f289a7c436af@www.fastmail.com
обсуждение исходный текст
Ответы Re: ERROR: tuple concurrently updated when modifying privileges  (Chris Travers <chris.travers@adjust.com>)
Список pgsql-hackers
Hello, hackers

we witnessed this slightly misleading error in production and it took us a while to figure out what was taking place.
Below are reproduction steps:


-- setup
create table trun(cate int4);

-- session 1
begin;
truncate table trun;

-- session 2
grant insert on table trun to postgres;

-- session 1
end;

-- session 2:
ERROR: XX000: tuple concurrently updated
LOCATION: simple_heap_update, heapam.c:4474

Apparently the tuple in question is the pg_class entry of the table being truncated. I didn't look too deep into the
cause,but I'm certain the error message could be improved at least.
 

Regards,
Nick.



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

Предыдущее
От: Andreas Joseph Krogh
Дата:
Сообщение: ERROR: failed to add item to the index page
Следующее
От: Rob
Дата:
Сообщение: Re: CHAR vs NVARCHAR vs TEXT performance