| 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: | Whole Thread | Raw Message | 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
| 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 |