From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Wells Oliver <wells.oliver@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Odd pg dump error: cache lookup failure
Date: Mon, 24 Aug 2020 15:08:53 -0400
Message-ID: <20200824190853.GA14456@alvherre.pgsql> (raw)
In-Reply-To: <CAOC+FBVZizGOEfA1wjWrJzBUDJCDxV5EkiOz1ZZ_u=rY=8HjPw@mail.gmail.com>
On 2020-Aug-24, Wells Oliver wrote:
> My pg_dump scripts have been bombing lately, and this is the error I see a
> bit into the backup process:
>
> pg_dump: error: query failed: ERROR: cache lookup failed for attribute 1
> of relation 1152770777
What pg version is this, and can you run the query directly using psql
and have it throw the same error? What do
select * from pg_class where oid = '1152770777'
and
select * from pg_attribute where attrelid = '1152770777'
show? If the latter fails to show an entry for attnum=1, does it
magically appear if you do
SET enable_indexscan=off;
SET enable_bitmapscan=off;
prior to running the query?
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
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: alvherre@2ndquadrant.com, wells.oliver@gmail.com
Subject: Re: Odd pg dump error: cache lookup failure
In-Reply-To: <20200824190853.GA14456@alvherre.pgsql>
* 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