How to troubleshoot: ERROR: cache lookup failed for type?

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

Responses

Browse pgsql-general by date

  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