Home > mailing lists

Re: an error message that I don't understand - Mailing list pgsql-general

From	David G. Johnston
Subject	Re: an error message that I don't understand
Date	May 2 23:45:38
Msg-id	CAKFQuwbYX7w38Ayskuoa3NmHUfpV5W5Uh6N7tJuwB8F_GO2zsQ@mail.gmail.com Whole thread Raw
In response to	an error message that I don't understand (Martin Mueller <martinmueller@northwestern.edu>)
List	pgsql-general

On Fri, May 2, 2025 at 1:25 PM Martin Mueller <martinmueller@northwestern.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.

From: Martin Mueller
Date: 02 May, 23:24:52
Subject: an error message that I don't understand

From: "Peter J. Holzer"
Date: 03 May, 15:34:47
Subject: Re: Index not used in certain nested views but not in others