Re: Re[2]: BUG #5977: Crash on delete - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Re[2]: BUG #5977: Crash on delete
Date
Msg-id 7270.1302902842@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5977: Crash on delete  ("Anton Kuznetsov" <antosha86@mail.ru>)
List pgsql-bugs
=?utf-8?Q?=D0=90=D0=BD=D1=82=D0=BE=D0=BD_=D0=9A=D1=83=D0=B7=D0=BD=D0=B5=D1=86=D0=BE=D0=B2?= <antosha86@mail.ru> writes:
> TRAP: FailesAssertion("!(outerstartsel <= outerendsel)",  File:
> "costsize.c", String: 1540)

On reflection it seems the only way you could get past the preceding
"Assert(outer_skip_rows <= outer_rows)" and then crash there would be
if outer_path_rows was NaN, which would result in both outerstartsel and
outerendsel becoming NaN, and then the comparison would fail to yield
true.

(A negative value of outer_path_rows would do it too, but that case has
been excluded at the top of the function.)

So the actual bug is presumably that some other piece of the planner is
returning NaN instead of a valid rowcount estimate.  Unfortunately,
there are a whole lot of places to look, and not nearly enough
information here to narrow it down ...

            regards, tom lane


pgsql-bugs by date:

Previous
From: John R Pierce
Date:
Subject: Re: BUG #5982: recursive type crashes postgres
Next
From: "Kevin Grittner"
Date:
Subject: Re: BUG #5982: recursive type crashes postgres