[postgis-devel] [PostGIS] #619: Postgres 9.0 with Postgis 1.5.2 crash on windows on this query

PostGIS trac at osgeo.org
Mon Oct 4 22:39:47 PDT 2010


#619: Postgres 9.0 with Postgis 1.5.2 crash on windows on this query
-----------------------+----------------------------------------------------
 Reporter:  aperi2007  |       Owner:  pramsey      
     Type:  defect     |      Status:  new          
 Priority:  high       |   Milestone:  PostGIS 1.5.3
Component:  postgis    |     Version:  1.5.X        
 Keywords:             |  
-----------------------+----------------------------------------------------

Comment(by aperi2007):

 Hi,

 The postgres guy find where the postgres crash.

 ( http://archives.postgresql.org/pgsql-bugs/2010-10/msg00042.php)

 >It's crashing in pfree, as called by examine_attribute here:
 >
 >       if (!ok || stats->compute_stats == NULL || stats->minrows <= 0)
 >       {
 >               pfree(stats->attrtype);
 >               pfree(stats->attr);         <-- crash
 >               pfree(stats);
 >               return NULL;
 >       }
 >
 >... which is palloc'd earlier in examine_attribute.
 >
 >
 >VC++ is having trouble examining the locals in examine_attribute(); I'm
 unsure if >this is an optimization issue, lack of full debug info, or
 something wrong with >the state of the stack.

 >It's definitely crashing while analyzing the relation "suolo" - not only
 do the >logs show analysis beginning, but onerel->rd_rel->relname is
 "suolo". At the time >of the crash it seems to have already added the
 column with attr->attname = >"codpoligono" to vacattrstats and is
 examining the column with attnum=5 when it >crashes. A quick look at
 pg_class and pg_attribute shows that this is (surprise!) >the "geom"
 column of type "geometry".
 >
 >PostGIS on Windows is a bit outside my depth, especially as it's not a
 neat crash >in the analyze function its self. Hopefully this'll give the
 PostGIS folks >something to go on, though. Andrea: please pass it on.
 >

 They ask if there some relation with a last-minute correction of
 postgres).

 http://archives.postgresql.org/pgsql-bugs/2010-10/msg00043.php

 Regards,
 Andrea.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/619#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-devel mailing list