| 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.
| 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 |