From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ramiro Barreca <rbarreca@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: ERROR: cache lookup failed for type 16292881
Date: Tue, 03 Dec 2019 10:23:56 -0500
Message-ID: <32505.1575386636@sss.pgh.pa.us> (raw)
In-Reply-To: <CAO4Rs2ktcz3UecyHXP1CsJzqL4k0DfUZa_rvUg5v2D6XuJA_Mg@mail.gmail.com>
References: <CAO4Rs2ktcz3UecyHXP1CsJzqL4k0DfUZa_rvUg5v2D6XuJA_Mg@mail.gmail.com>
Ramiro Barreca <rbarreca@gmail.com> writes:
> Since a few days ago we are having problems while performing backup using
> pg_dump to a PG 8.4 database over a Centos 5.5
You realize of course that 8.4.anything is long out of support, and
therefore full of known bugs. But I wonder whether this is even a
reasonably late minor release of 8.4.
> *pg_dump: Error message from server: ERROR: cache lookup failed for type
> 16292881*
> *pg_dump: The command was: SELECT proretset, prosrc, probin,
> pg_catalog.pg_get_function_arguments(oid) AS funcargs,
> pg_catalog.pg_get_function_identity_arguments(oid) AS funciargs,
> pg_catalog.pg_get_function_result(oid) AS funcresult, proiswindow,
> provolatile, proisstrict, prosecdef, proconfig, procost, prorows, (SELECT
> lanname FROM pg_catalog.pg_language WHERE oid = prolang) AS lanname FROM
> pg_catalog.pg_proc WHERE oid = '16292882'::pg_catalog.oid*
You might learn something productive from
select * from pg_proc where oid = '16292882';
The direct problem of course is that oid 16292881 can't be found
in pg_type. If you're really lucky, that's just index corruption
that could be fixed by reindexing pg_type.
regards, tom lane
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: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, rbarreca@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: ERROR: cache lookup failed for type 16292881
In-Reply-To: <32505.1575386636@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox