public inbox for [email protected]  
help / color / mirror / Atom feed
From: David G. Johnston <[email protected]>
To: Martin Mueller <[email protected]>
Cc: Postgres General <[email protected]>
Subject: Re: an error message that I don't understand
Date: Fri, 2 May 2025 13:45:38 -0700
Message-ID: <CAKFQuwbYX7w38Ayskuoa3NmHUfpV5W5Uh6N7tJuwB8F_GO2zsQ@mail.gmail.com> (raw)
In-Reply-To: <BN6PR05MB36674534FFDF5E41A6CAFCA4C48D2@BN6PR05MB3667.namprd05.prod.outlook.com>
References: <BN6PR05MB36674534FFDF5E41A6CAFCA4C48D2@BN6PR05MB3667.namprd05.prod.outlook.com>

On Fri, May 2, 2025 at 1:25 PM Martin Mueller <
[email protected]> 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.


view thread (2+ messages)

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: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: an error message that I don't understand
  In-Reply-To: <CAKFQuwbYX7w38Ayskuoa3NmHUfpV5W5Uh6N7tJuwB8F_GO2zsQ@mail.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 agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox