BUG #17510: cache lookup failed for type

Started by PG Bug reporting formalmost 4 years ago2 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following bug has been logged on the website:

Bug reference: 17510
Logged by: Hou
Email address: 17346536631@163.com
PostgreSQL version: 12.7
Operating system: ubuntu
Description:

gitlabhq_production=# \l
ERROR: invalid input syntax for type integer: "
"
LINE 6: pg_catalog.array_to_string(d.datacl, E'\n') AS "Acces...
^
gitlabhq_production=# \dt
ERROR: cache lookup failed for type 705

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: PG Bug reporting form (#1)
Re: BUG #17510: cache lookup failed for type

PG Bug reporting form <noreply@postgresql.org> writes:

gitlabhq_production=# \l
ERROR: invalid input syntax for type integer: "
"
LINE 6: pg_catalog.array_to_string(d.datacl, E'\n') AS "Acces...
^
gitlabhq_production=# \dt
ERROR: cache lookup failed for type 705

This looks a bit like you've got corruption in the system catalogs.
You've not given any details about you got into this state, so
it's hard to offer any advice.

regards, tom lane