| From: | Simon Windsor <simon(dot)windsor(at)cornfield(dot)me(dot)uk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Error XX000 After pg11 upgrade |
| Date: | 2019-08-15 14:30:29 |
| Message-ID: | CADHu9spiU5O9vH2Avjsd4gfJ8DxvO0wOvj=eD=z104KPWyzVrg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)windsor(at)cornfield(dot)org(dot)uk
Tel: 01454 617689
Mob: 07960 321599
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PegoraroF10 | 2019-08-15 14:30:36 | slow queries on system tables |
| Previous Message | Olagoke Akinyemi | 2019-08-15 10:56:02 | TRANSACTION NOTIFICATION IN POSTGRESQL |