ERROR: tuple concurrently updated when modifying privileges

From: nickb <nickb(at)imap(dot)cc>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: ERROR: tuple concurrently updated when modifying privileges
Date: 2019-04-30 09:26:32
Message-ID: ca9245dd-368d-479f-8c7e-f289a7c436af@www.fastmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rob 2019-04-30 09:43:20 Re: CHAR vs NVARCHAR vs TEXT performance
Previous Message Andreas Joseph Krogh 2019-04-30 09:03:15 ERROR: failed to add item to the index page