ERROR: XX000: cache lookup failed for type 75083631

Поиск
Список
Период
Сортировка
От Jan Beseda
Тема ERROR: XX000: cache lookup failed for type 75083631
Дата
Msg-id CAHaN6DaevgVJUn6Jne03gw15GZ2muP5vrsOqHsb382tbcqc3iw@mail.gmail.com
обсуждение исходный текст
Ответы Re: ERROR: XX000: cache lookup failed for type 75083631  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
Hi there,

I'm having an issue with dropping a view as shown below:

DROP VIEW access_group_view;
ERROR:  XX000: cache lookup failed for type 75083631
LOCATION:  format_type_internal, format_type.c:152

I've also checked the source code here, which :

I've tried to clear the cache as mentioned in some other thread on community using option with number 3 from here: https://www.cyberithub.com/drop-flush-clear-cache-memory-ram-in-linux/
-> Didn't help

We are running postgresql in a docker container.
PostgreSQL 9.6.12 on x86_64-pc-linux-musl, compiled by gcc (Alpine 8.3.0) 8.3.0, 64-bit

This is an old instance, but I would like to figure out what caused it going forward and ideally how to fix it. We've upgraded in the latest version to 13.1 also planning to upgrade to 14.2 in a few days.

Ideas or what info to provide?

В списке pgsql-general по дате отправления:

Предыдущее
От: Nick Cleaton
Дата:
Сообщение: Re: Is this a reasonable use for advisory locks?
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: What do you guys use for issue tracking, CI/CD and team management? any nice open source options?