pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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






view thread (6+ messages)  latest in thread

Message-ID: <9da8208c61333d155a7328b107f75b85a0bf832e.camel@gmail.com>
Permalink:  ../9da8208c61333d155a7328b107f75b85a0bf832e.camel@gmail.com/
Also on:    postgresql.org/message-id/9da8208c61333d155a7328b107f75b85a0bf832e.camel@gmail.com

 · 

reply

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