BUG #15000: Cache lookup failure

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: postgres(at)kellerer(dot)name
Subject: BUG #15000: Cache lookup failure
Date: 2018-01-08 11:31:50
Message-ID: 20180108113150.21778.4472@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15000
Logged by: Thomas Kellerer
Email address: postgres(at)kellerer(dot)name
PostgreSQL version: 10.1
Operating system: CentOS release 6.6
Description:

We have a script that copies data from one database to another using pg_dump
(plain text format) and the pipes the output to psql

The script consistently fails with:

pg_dump: [archiver (db)] query failed: ERROR: cache lookup failed for
relation 16693
pg_dump: [archiver (db)] query was: SELECT tableoid, oid, conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc, conislocal, convalidated
FROM pg_catalog.pg_constraint WHERE conr elid =
'16693'::pg_catalog.oid AND contype = 'c' ORDER BY conname

Postgres version is:
PostgreSQL 10.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313
(Red Hat 4.4.7-18), 64-bit

Apparently I can't attach the script here, so it can be downloaded from:

https://sql-workbench.net/pg/localized_texts_cache_lookup_error.sh

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2018-01-08 15:12:17 Re: BUG #15000: Cache lookup failure
Previous Message Karl Czajkowski 2018-01-05 23:05:58 missing repodata for https://download.postgresql.org/pub/repos/yum/9.6/fedora/fedora-26-x86_64