Re: Query returns no results until REINDEX - Mailing list pgsql-general

From Julien Rouhaud
Subject Re: Query returns no results until REINDEX
Date
Msg-id CAOBaU_brh5vctfa+9nAo-u2URL7HKE-deFoZnVrb8=9ydD1jGQ@mail.gmail.com
Whole thread Raw
In response to Re: Query returns no results until REINDEX  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-general
On Tue, Feb 11, 2020 at 8:33 PM Peter Geoghegan <pg@bowt.ie> wrote:
>
> On Sun, Feb 9, 2020 at 12:50 PM Colin Adler <colin@coder.com> wrote:
> > Looks like it found something. I checked out the contrib/pageinspect docs but
> > wasn't too sure what to run. Are incompatible libc versions causing btree
> > corruption something you consider a bug? If it's something you'd like to look
> > into further I can gladly send over the database files.
>
> No, this is not considered a bug.
>
> It's unfortunate that there is no built in collation versioning
> mechanism, or something like that -- that might have alerted you to
> the problem before any real damage occurred.

FTR, this is something being actively worked on [1], and I still hope
that in pg13 a glibc or ICU upgrade will be detected and raise proper
warning.

[1] https://commitfest.postgresql.org/27/2367/



pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Query returns no results until REINDEX
Next
From: "Andrus"
Date:
Subject: How to restore roles without changing postgres password