Re: [HACKERS] unique index violation after pg_upgrade to PG10

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Re: [HACKERS] unique index violation after pg_upgrade to PG10
Дата
Msg-id 20171024222752.GW21735@telsasoft.com
обсуждение исходный текст
Ответ на Re: [HACKERS] unique index violation after pg_upgrade to PG10  (Kenneth Marshall <ktm@rice.edu>)
Список pgsql-hackers
On Tue, Oct 24, 2017 at 01:48:55PM -0500, Kenneth Marshall wrote:
> I just dealt with a similar problem with pg_repack and a PostgreSQL 9.5 DB,
> the exact same error. It seemed to caused by a tuple visibility issue that
> allowed the "working" unique index to be built, even though a duplicate row
> existed. Then the next pg_repack would fail with the error you got.

FTR, I was able to run the repack script several times without issue, hitting
that table each time.

Justin


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [HACKERS] Remove secondary checkpoint
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: [HACKERS] unique index violation after pg_upgrade to PG10