Re: an error message that I don't understand

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Martin Mueller <martinmueller(at)northwestern(dot)edu>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: an error message that I don't understand
Date: 2025-05-02 20:45:38
Message-ID: CAKFQuwbYX7w38Ayskuoa3NmHUfpV5W5Uh6N7tJuwB8F_GO2zsQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, May 2, 2025 at 1:25 PM Martin Mueller <
martinmueller(at)northwestern(dot)edu> wrote:

>
> table tid from new index tuple (32586,21) overlaps with invalid duplicate
> tuple at offset 120 of block 4398 in index "aacorrections_tcpreading_idx"
>

Read that as "your index is corrupted".

> I have no idea what is going on or how to deal with it and will be
> grateful for advice
>
>
>

You will need to rebuild the index.

If you've recently performed an OS upgrade you may also wish to update
most/all indexes to fix possible collations issues.

David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2025-05-03 12:34:47 Re: Index not used in certain nested views but not in others
Previous Message Martin Mueller 2025-05-02 20:24:52 an error message that I don't understand