Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: rihad <rihad(at)mail(dot)ru>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices
Date: 2017-12-22 13:32:10
Message-ID: CAH2-Wz=UeSbgjuOHM-Q=N36rnb-seQrp-x3ZMq0U7gHLH2JyEg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Dec 22, 2017 at 11:56 AM, rihad <rihad(at)mail(dot)ru> wrote:
> I forgot to mention the real problem: the mentioned unique constraint didn't
> work and allowed duplicate rows to get inserted into the table until the
> duplicates were manually removed the the index was rebuilt.

You should run amcheck functions on both environments, against all
indexes, to see where the inconsistency arose, and to isolate any
other inconsistencies that may have been missed. While amcheck is
available from contrib in Postgres 10, you can get a version that will
work on other versions through OS packages for most major Linux
distributions. See:

https://github.com/petergeoghegan/amcheck

Note also that only this external version has the "heapallindexed" check.

--
Peter Geoghegan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2017-12-22 13:42:33 Re: Stand by server (9.6.6) with corrupt file
Previous Message Edson Carlos Ericksson Richter 2017-12-22 13:29:39 Stand by server (9.6.6) with corrupt file