From: Ernesto Hernández-Novich <emhnemhn@gmail.com>
To: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: PG 9.6.20 -- query misbehaves in replica
Date: Fri, 13 Nov 2020 16:10:04 -0800
Message-ID: <9da8208c61333d155a7328b107f75b85a0bf832e.camel@gmail.com> (raw)
In-Reply-To: <CABUevEzyDgu=1EPe7Sf8gzK2i0ZexLSziBRMQjeO0vXP2b7vaA@mail.gmail.com>
References: <9bd869ddbddc71721de1d9d6a2710a1cfec5e98b.camel@gmail.com>
<CABUevEzyDgu=1EPe7Sf8gzK2i0ZexLSziBRMQjeO0vXP2b7vaA@mail.gmail.com>
On Sat, 2020-11-14 at 00:59 +0100, Magnus Hagander wrote:
> On Sat, Nov 14, 2020 at 12:17 AM Ernesto Hernández-Novich <
> emhnemhn@gmail.com> wrote:
[...]
> > After updating from 9.6.19 to 9.6.20, we noticed the query was not
> > working on D.
[...]
> > Looks like a the 9.6.20 over Debian 10 is the culprit, but I have
> > nothing else to work on.
>
> These issues are almost certainly because of the glibc locale changes
> between Debian 9 and Debian 10, and not because of the PostgreSQL
> upgrade.
>
> If you have master and standby on different glibc versions (so debian
> 9 vs 10), all text based indexes can behave differently. All the
> nodes must run the same version for this to work. So in this
> scenario, you need to reinstall B and D with debian 9, or you need to
> upgrade your other nodes to debian 10 (and if you do that, then you
> have to reindex the master node once it has been upgraded).
I agree on the locale matching and will try your suggestion.
I must say the Debian 10 machines were working just fine with PG 9.6.19
for over two months or so. We noticed the issue *just* this week after
upgrading from 9.6.19 onto 9.6.20.
Regards,
--
Ernesto Hernández-Novich - @iamemhn - Unix: Live free or die!
Geek by nature, Linux by choice, Debian of course.
If you can't aptitude it, it isn't useful or doesn't exist.
GPG Key Fingerprint = 0064 ADF5 EB5C DE16 99C1 6C56 F2A3 86B5 A757 E5A1
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: emhnemhn@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: PG 9.6.20 -- query misbehaves in replica
In-Reply-To: <9da8208c61333d155a7328b107f75b85a0bf832e.camel@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox