From: | Marcin Barczyński <mbarczynski(at)starfishstorage(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | How to troubleshoot: ERROR: cache lookup failed for type? |
Date: | 2024-10-04 12:09:19 |
Message-ID: | CAOhG4wehVGviLjMVFyn9oYE+faj_1tpcSXD6BKEBVzBTPQh40Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello!
When reindexing a table, PostgreSQL returns the following errors for
two of its indexes:
Index foo_idx1 on foo failed with error: failed to find parent tuple
for heap-only tuple at (1162372,1) in table "foo"
Index foo_idx2 on foo failed with error: failed to find parent tuple
for heap-only tuple at (1162372,1) in table "foo"
When trying to show the tuple, there is another error message:
SET enable_indexscan = OFF;
SET enable_tidscan = OFF;
SELECT ctid, xmin, xmax, * FROM sf.dir_current_part_8 WHERE ctid =
'(1162372,1)';
ERROR: cache lookup failed for type 1769235301
Searching for oid=1769235301 in pg_class, pg_type, pg_namespace and
pg_proc returned no results.
It appears to be data corruption.
It's PostgreSQL 13 and unfortunately, data_checksums are turned off.
I would appreciate any suggestions for troubleshooting this issue.
--
Marcin Barczyński
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2024-10-04 15:40:15 | Re: How to troubleshoot: ERROR: cache lookup failed for type? |
Previous Message | Francesco Benetton | 2024-10-04 11:41:16 | Re: CLOSE_WAIT pileup and Application Timeout |