Re: vacuumdb error: tuple concurrently updated

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: vacuumdb error: tuple concurrently updated
Дата
Msg-id 1717.1040922543@sss.pgh.pa.us
обсуждение исходный текст
Ответ на vacuumdb error: tuple concurrently updated  (Harald Krake <harald@krake.de>)
Ответы Re: vacuumdb error: tuple concurrently updated  (Harald Krake <harald@krake.de>)
Список pgsql-bugs
Harald Krake <harald@krake.de> writes:
> while running a "vacuumdb -z" I got the following error message:
> ERROR:  simple_heap_update: tuple concurrently updated
> vacuumdb: vacuum  jartifice failed

Is it likely that someone else was doing the same thing in another
session?  This failure is known to occur if two backends concurrently
ANALYZE the same table --- the second one to try to update the
pg_statistics row fails because of the concurrent write.  It's quite
harmless, except for preventing the rest of the VACUUM command from
completing.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Bug #856: coredump
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Bug #858: bitfromint4 not present in 7.3.1