Error XX000 After pg11 upgrade

Поиск
Список
Период
Сортировка
От Simon Windsor
Тема Error XX000 After pg11 upgrade
Дата
Msg-id CADHu9spiU5O9vH2Avjsd4gfJ8DxvO0wOvj=eD=z104KPWyzVrg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Error XX000 After pg11 upgrade  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Olagoke Akinyemi
Дата:
Сообщение: TRANSACTION NOTIFICATION IN POSTGRESQL
Следующее
От: PegoraroF10
Дата:
Сообщение: slow queries on system tables