Re: ERROR: cache lookup failed for function 125940 - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: cache lookup failed for function 125940
Date
Msg-id 28005.1534703408@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: cache lookup failed for function 125940  (DrakoRod <drakoflames@hotmail.com>)
Responses Re: ERROR: cache lookup failed for function 125940
List pgsql-general
DrakoRod <drakoflames@hotmail.com> writes:
> I've a big problem with a database, is a PostgreSQL 9.6 version on Ubuntu.
> When a tried read some tables (approximately 7 of 1073) show this error: 

> *ERROR: cache lookup failed for function 125940*

> So, I was reading this like data corruption specially the postgresql's
> system catalog . I tried generate a dump but in any case, when I try make a
> database dump or table's dump show this error: 

> *pg_dump: [archiver (db)] query failed: ERROR: cache lookup failed for
> function 406

Hmm, perhaps reindexing pg_proc would get you out of trouble?

Also, if that isn't 9.6.10, I'd suggest updating --- we have fixed
some data corruption issues since 9.6.0.

            regards, tom lane


pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: Postgresql
Next
From: Chris Travers
Date:
Subject: Re: Postgresql