[postgis-users] pgsql2shp and glibc memory issues

[strk at refractions.net]

PostGIS 1.0.3 contains a fix for this probably.
You might want to wait a few days to upgrade to 1.0.4 directly.
--strk;

On Fri, Sep 02, 2005 at 03:12:19PM -0700, Ken-ichi wrote:
> Hi all.  I'm trying to run pgsql2shp with a particularly ornery query 
> and I keep getting errors like
> 
> Preparing table for user query... *** glibc detected *** free(): invalid 
> next size (normal): 0x0805fe80 ***
> Aborted
> 
> 
> or
> 
> Preparing table for user query... *** glibc detected *** double free or 
> corruption (!prev): 0x0805fe80 ***
> Aborted
> 
> 
> Here's a version of the query (with line breaks added) that yields the 
> former error:
> 
> SELECT DISTINCT ON(p.plotkey)
>    pp.pointid, p.plotkey, p.map, c.county, pp.the_geom AS the_geom, 
> s.genus AS genus, s.species AS species
> FROM  
>    pg_plot p 
>    JOIN pg_tree_tally x ON p.pid=x.pid 
>    JOIN plot_points pp ON p.plotkey=pp.plotkey 
>    LEFT OUTER JOIN pg_species_codes s ON x.tree_species=s.code 
>    LEFT OUTER JOIN sp_source_lu lu ON s.source=lu.source 
>    LEFT OUTER JOIN plot_counties_lu c ON c.plotkey=pp.plotkey  
> WHERE 
>    p.map='107C'
>    AND (
>        (   map NOT IN ('104B', '108', '129', '180', '191', '192A', 
> '64D', '65D')   
>            AND ( x.tree_species='A' OR x.tree_species='Qa' )   
>            OR (   
>                (x.tree_species='A' AND p.map IN ('104B', '108', '129', 
> '180', '191', '192A', '64D', '65D'))   
>                OR (x.tree_species='Lit A' AND p.map IN ('104B', '108'))   
>                OR (x.tree_species='Qa' AND p.map IN ('64D', '65D'))  
>            ) 
>        )
>    )
> 
> Yeah, not exactly pretty or well put together or anything, but it runs 
> fine in psql and in a Mapserver layer.  I'm running postgis 1.0 and 
> PostgreSQL 8.0.1.  Can anyone tell me what these error messages mean?
> 
> -- 
> Ken-ichi Ueda
> Kelly Research and Outreach Lab (http://kellylab.berkeley.edu)
> University of California, Berkeley
> Environmental Science, Policy, and Management
> Berkeley, CA 94720
> tel: 510.642.8322
> fax: 510.642.1477
> e-mail: kueda at nature.berkeley.edu
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users