Re: BUG #16932: Database Crash with : ERROR: cache lookup failed for type 0

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: github(at)vlqubed(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org, PG Bug reporting form <noreply(at)postgresql(dot)org>
Subject: Re: BUG #16932: Database Crash with : ERROR: cache lookup failed for type 0
Date: 2021-03-18 14:12:05
Message-ID: 3717548.1616076725@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> Randomly, we see this error in the logs:
> 2021-03-18 07:52:32 UTC-6052fa73.12638-ERROR: cache lookup failed for type
> 0

> Our process is as follows ( pseudo code simplified ):
> begin trans;
> call a procedure that drops and re-creates a table.
> commit;

> begin trans
> loop 1000 rows
> insert into table above....
> end loop;
> commit;

Hm. Can you provide a self-contained test case?

It'd also be worth your time to update to latest 10.x, in case this is
an already-fixed bug. A quick trawl of the commit logs didn't turn up
an obvious match, but I might have missed a relevant fix.

https://wiki.postgresql.org/wiki/Guide_to_reporting_problems

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2021-03-18 14:15:05 BUG #16933: [build-system] libpq doesn't check for every names of zlib
Previous Message Ярослав Пашинский 2021-03-18 12:16:21 Re: BUG #16927: Postgres can`t access WAL files