On 16/08/2019 04:35, Simon Windsor wrote:
> Hi
>
> The Full system used to in an Oracle DB and was ported to Postgres 9.5
> about 2+ years ago, and partitioned using inheritance tables.
>
> Since then pg_upgrade has been used to upgrade to pg10 (with apt
> upgrade to take to 10.5 occasionally).
>
> Last week, pg_upgrade was againn used to upgrade to pg11.4.
>
> Since then, large bulk inserts of configuration changes are failing
> with this Error, but adhoc and small changes are working ok.
>
> The actual error is reported by a Java process
>
> Caused by: org.postgresql.util.PSQLException: ERROR: cache lookup
> failed for type 22079
> Where: SQL statement "insert into configObjectsFull_2019 values
> (new.*)"
> PL/pgSQL function configobjectsfull_insert_trigger() line 28 at SQL
> statement
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2310)
> at
>
> The DB Tableand Trigger are attached.
>
> As you can see, the id and timestamp are set on insert, and are used
> to determine the partition used.
>
> This issue started after the upgrade to pg11, pg10 and pg9 had no
> problems.
>
> Any ideas would be appreciated.
[...]
Probably will make no difference, but have you considered testing using
pg 11.5? It would at least rule out a lot of Red Herrings!
Cheers,
Gavin