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

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices
Дата
Msg-id 1513948189.2384.3.camel@cybertec.at
обсуждение исходный текст
Ответ на pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices  (rihad <rihad@mail.ru>)
Ответы Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices  (rihad <rihad@mail.ru>)
Список pgsql-general
Дерево обсуждения 
rihad wrote:
> Hi there, this is a reproducible error. We recently pg_upgraded our 
> production database to 10.1 from 9.6.6. The upgrade runs fine with the 
> suggestion to analyze all data.

[...]

> Trying to find data using the specified indices fails to find matching rows:

[...]

> reindexing the table fixes the issue:

Did you also upgrade the operating system or at least libc?

Then the problem could come from a modified collation.
Compare https://www.postgresql.org/message-id/CB4D1C6BAA80CF146CB0D4F2%40eje.credativ.lan

Yours,
Laurenz Albe

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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices
Следующее
От: Edson Carlos Ericksson Richter
Дата:
Сообщение: Stand by server (9.6.6) with corrupt file