From: | Omar Kilani <omar(dot)kilani(at)gmail(dot)com> |
---|---|
To: | Magnus Hagander <magnus(at)hagander(dot)net> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, David Rowley <dgrowleyml(at)gmail(dot)com>, PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Strangeness with UNIQUE indexes and UTF-8 |
Date: | 2021-06-06 16:24:52 |
Message-ID: | CA+8F9hiRp9Oy+5SeOmwJbPRNC37AWvXT2P7tgQHqLaGmaWg7XQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hey Magnus,
Hmmm, okay -- that's unfortunate. :)
I apparently wrote a script in 2017 to find duplicates from this issue
on the other table and fix them up. Maybe a similar locale thing
happened back then?
Anyway, for what it's worth:
Checksum scan completed
Data checksum version: 1
Files scanned: 7068
Blocks scanned: 524565247
Bad checksums: 0
Regards,
Omar
On Sun, Jun 6, 2021 at 9:15 AM Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>
> On Sun, Jun 6, 2021 at 5:19 PM Omar Kilani <omar(dot)kilani(at)gmail(dot)com> wrote:
> >
> > Hey Tom,
> >
> > The database was pg_dump'ed out of 10.4 and pg_restore'd into 11.2 on
> > a RHEL 7.x machine.
> >
> > The only other upgrade has been to RHEL 8.x. So the locale data change
> > might have changed something -- thanks for that information.
>
> There is no might -- if you upgraded from RHEL 7 to RHEL 8 without
> doing a reindex or a dump/reload there, you are pretty much guaranteed
> to have corrupt text indexes from that. Regardless of PostgreSQL
> versions, this was about the RHEL upgrade not the Postgres one.
>
>
>
> > We've seen this issue on a different table before upgrading to RHEL
> > 8.x, though. And only on that table, because it's user-generated and
> > gets a bunch of Unicode data input into a UNIQUE index.
>
> This indicates you may have more than one problem.
>
> But that doesn't mean it's not both, sadly.
>
>
> --
> Magnus Hagander
> Me: https://www.hagander.net/
> Work: https://www.redpill-linpro.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Pryzby | 2021-06-06 16:35:31 | pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic |
Previous Message | Magnus Hagander | 2021-06-06 16:14:54 | Re: Strangeness with UNIQUE indexes and UTF-8 |