Re: Going for "all green" buildfarm results - Mailing list pgsql-hackers

From Stefan Kaltenbrunner
Subject Re: Going for "all green" buildfarm results
Date
Msg-id 44CC4656.2030405@kaltenbrunner.cc
Whole thread Raw
In response to Re: Going for "all green" buildfarm results  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Going for "all green" buildfarm results  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
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?

FYI: lionfish just managed to hit that problem again:

http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=lionfish&dt=2006-07-29%2023:30:06



Stefan


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: The vacuum-ignore-vacuum patch
Next
From: Alvaro Herrera
Date:
Subject: Re: Going for "all green" buildfarm results