[postgis-users] [postgis-devel] Has anyone seen this before?

Paragon Corporation lr at pcorp.us
Fri Feb 5 14:29:50 PST 2010


Okay just tried this and the problem is reproducible.

The goodtable
select count(*),  GeometryType(the_geom) from goodtable
group by GeometryType(the_geom)

count    Geometry Type
174007   MULTIPOLYGON 


Repeat process:
create table badtable as select * from goodtable order by addr_num_tlid
limit 100000;

Same bizarre result.  

Even more bizzarre  - I can do this

select GeometryType(the_geom) from ca1.ca_toscrub_hits_st_union1
WHERE GeometryType(the_geom) = 'UNKNOWN'
limit 1;

But If I try to do this

SELECT addr_num_tlid, GeometryType(the_geom) from
ca1.ca_toscrub_hits_st_union1
WHERE GeometryType(the_geom) = 'UNKNOWN'
limit 1

or this
SELECT addr_num_tlid from ca1.ca_toscrub_hits_st_union1
WHERE GeometryType(the_geom) = 'UNKNOWN'
limit 1

I get this error:

ERROR:  invalid memory alloc request size 18446744073709551613

Very puzzled Regina

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paragon
Corporation
Sent: Friday, February 05, 2010 5:09 PM
To: 'PostGIS Development Discussion'
Cc: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] [postgis-devel] Has anyone seen this before?

Further note:

Doing an ST_IsEmpty on one of these monsters shows its not empty.

ST_GeometryType(..) returns ST_Geometry

and when I try to do an ST_Mem_Size on one, I hmm get this

 ERROR:  lwgeom_size called with unknown-typed serialized geometry


When try ST_IsValid get this

ERROR:  Unknown geometry type: 0

 
I'm going to try to repeat the process of copy from good table to see if the
problem disappears.  I suppose it could be disk corruption of some sort.

Thanks,
Regina
-----Original Message-----
From: postgis-devel-bounces at postgis.refractions.net
[mailto:postgis-devel-bounces at postgis.refractions.net] On Behalf Of Paragon
Corporation
Sent: Friday, February 05, 2010 4:55 PM
To: 'PostGIS Development Discussion'
Subject: [postgis-devel] Has anyone seen this before?

What would result in an UNKNOWN geometry type.  One of our clients is
getting this error when they try to vacuum analyze their table.

> NOTICE:  compute_serialized_box3d called on unknown type 0NOTICE:  
> compute_serialized_box3d called on unknown type 0 ...

On closer inspection -- I see that there are UNKNOWNs and those UNKNOWNS are
not NULL but the ST_AsText looks blank viewed via psql


select count(*),  GeometryType(the_geom) from badtable group by
GeometryType(the_geom);  count | geometrytype
-------+--------------
 98483 | MULTIPOLYGON
  1517 | UNKNOWN


This is running on


----------------------------------------------------------------------------
----
 POSTGIS="1.3.6" GEOS="3.2.0-CAPI-1.6.0" PROJ="Rel. 4.6.0, 21 Dec 2007"
USE_STATS

PostgreSQL 8.4.1 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2
20
071124 (Red Hat 4.1.2-42), 64-bit


They say the table was created by doing a

create table badtable as select * from goodtable order by addr_num_tlid
limit 100000;


the goodtable doesn't exhibit this bizarre behavior.  Not sure if this is a
PostgreSQL bug or PostGIS bug.

Any thoughts?


Thanks,
Regina


_______________________________________________
postgis-devel mailing list
postgis-devel at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-devel


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users





More information about the postgis-users mailing list