Re: [HACKERS] unique index violation after pg_upgrade to PG10 - Mailing list pgsql-hackers

From Justin Pryzby
Subject Re: [HACKERS] unique index violation after pg_upgrade to PG10
Date
Msg-id 20171024222752.GW21735@telsasoft.com
Whole thread Raw
In response to Re: [HACKERS] unique index violation after pg_upgrade to PG10  (Kenneth Marshall <ktm@rice.edu>)
List 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 by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] Remove secondary checkpoint
Next
From: Justin Pryzby
Date:
Subject: Re: [HACKERS] unique index violation after pg_upgrade to PG10