| From: | Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com> |
|---|---|
| To: | "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru> |
| Cc: | Robins Tharakan <tharakan(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Tomas Vondra <tomas(dot)vondra(at)postgresql(dot)org>, Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>, Peter Geoghegan <pg(at)bowt(dot)ie>, James Coleman <jtc331(at)gmail(dot)com> |
| Subject: | Re: 13dev failed assert: comparetup_index_btree(): ItemPointer values should never be equal |
| Date: | 2024-03-21 15:21:20 |
| Message-ID: | CAEze2WiJX_GgTD2Rke=Xs17AV-nFH42YrnroAcXgknaS8m3ovA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, 21 Mar 2024 at 07:17, Andrey M. Borodin <x4mmm(at)yandex-team(dot)ru> wrote:
>
> > On 29 Jun 2022, at 17:43, Robins Tharakan <tharakan(at)gmail(dot)com> wrote:
>
> Sorry to bump ancient thread, I have some observations that might or might not be relevant.
> Recently we noticed a corruption on one of clusters. The corruption at hand is not in system catalog, but in user indexes.
> The cluster was correctly configured: checksums, fsync, FPI etc.
> The cluster never was restored from a backup. It’s a single-node cluster, so it was not ever promoted, pg_rewind-ed etc. VM had never been rebooted.
>
> But, the cluster had been experiencing 10 OOMs a day. There were no torn pages, no checsum erros at log at all. Yet, B-tree indexes became corrupted.
Would you happen to have a PostgreSQL version number (or commit hash)
to help debugging? Has it always had that PG version, or has the
version been upgraded?
Considering the age of this thread, and thus potential for v14 pre-.4:
Did this cluster use REINDEX (concurrently) for the relevant indexes?
Kind regards,
Matthias van de Meent
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Treat | 2024-03-21 15:37:39 | Re: Possibility to disable `ALTER SYSTEM` |
| Previous Message | Jelte Fennema-Nio | 2024-03-21 15:21:15 | Re: UUID v7 |