Error XX000 After pg11 upgrade - Mailing list pgsql-general

From Simon Windsor
Subject Error XX000 After pg11 upgrade
Date
Msg-id CADHu9spiU5O9vH2Avjsd4gfJ8DxvO0wOvj=eD=z104KPWyzVrg@mail.gmail.com
Whole thread Raw
Responses Re: Error XX000 After pg11 upgrade
List pgsql-general
Hi

I have just upgraded a Db from pg 10.5 to pg11.4 and almost immediately we are seeing errors like

ERROR,XX000,"cache lookup failed for type 22079"

When inserting into a a partitioned table. About 30% of inserts are reporting this error.

How do I determine what type 22079 refers to? I have checked pg_attributes and pg_classes without success? What would be causing this error?

The basic table layout is

objects
    objects_2010
    objects_2011
-----
    objects_2018
    objects_2019

And an insert trigger uses the current date to dertmine where the object is stored.

Any ideas or suggestions would be appreciated.

Simon
--
Simon

Simon Windsor
Eml: simon.windsor@cornfield.org.uk
Tel: 01454 617689
Mob: 07960 321599

pgsql-general by date:

Previous
From: Olagoke Akinyemi
Date:
Subject: TRANSACTION NOTIFICATION IN POSTGRESQL
Next
From: PegoraroF10
Date:
Subject: slow queries on system tables