Tom Lane wrote:
> Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
>
>>FWIW: lionfish had a weird make check error 3 weeks ago which I
>>(unsuccessfully) tried to reproduce multiple times after that:
>
>
>>http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=lionfish&dt=2006-05-12%2005:30:14
>
>
> Weird.
>
> SELECT ''::text AS eleven, unique1, unique2, stringu1
> FROM onek WHERE unique1 < 50
> ORDER BY unique1 DESC LIMIT 20 OFFSET 39;
> ! ERROR: could not open relation with OID 27035
>
> AFAICS, the only way to get that error in HEAD is if ScanPgRelation
> can't find a pg_class row with the mentioned OID. Presumably 27035
> belongs to "onek" or one of its indexes. The very next command also
> refers to "onek", and doesn't fail, so what we seem to have here is
> a transient lookup failure. We've found a btree bug like that once
> before ... wonder if there's still one left?
If there is still one left it must be quite hard to trigger (using the
regression tests). Like i said before - I tried quite hard to reproduce
the issue back then - without any success.
Stefan