Re: planner crash/assert hit in 8.4B1 - Mailing list pgsql-hackers

From Bernd Helmle
Subject Re: planner crash/assert hit in 8.4B1
Date
Msg-id 9382926AD5EE7F11C3248B41@teje
Whole thread Raw
In response to planner crash/assert hit in 8.4B1  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Responses Re: planner crash/assert hit in 8.4B1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
--On Sonntag, April 19, 2009 15:29:01 +0200 Stefan Kaltenbrunner 
<stefan@kaltenbrunner.cc> wrote:

> Program received signal SIGSEGV, Segmentation fault.
> 0x082d27ef in estimate_num_groups (root=0x8566398, groupExprs=0x85b9ed8,
> input_rows=1159344) at selfuncs.c:3071
> 3071            Assert(rel->reloptkind == RELOPT_BASEREL);

Please note that it doesn't raise the Assert, it crashes because rel is 
NULL, hence the assertion expression crashes with a SIGSEGV. There seems to 
be something wrong with the RelOptInfo in estimate_num_groups().

--  Thanks
                   Bernd


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Reference on partial data
Next
From: Tom Lane
Date:
Subject: Re: [PATCH] unalias of ACL_SELECT_FOR_UPDATE