ST_buffer() causing postgres to stop the query

[cmalaurie]

Hi all I loaded an ESRI shape file into a database table worldcountries, containing then MULTIPOLYGONS of all countries borders around the world. I want to use the ST_Buffer function but is crashes on some records , causing the postmaster to stop the psql process with an exception " enregistrement de longueur nulle à 0/2CA1748" which means "record with length null". Note 1: most the MULTIPOLYGONS are working fine, some others are causing a crash as well. Note 2: strangely last week I'm almost sure the query was working, but I had to re-install all postgres+postgis+libgeos components after a server crash.

POSTGRES and POSTGIS version testgis=# select postgis_full_version();

postgis_full_version

---

POSTGIS="1.3.3" GEOS="3.0.0-CAPI-1.4.1" PROJ="Rel. 4.6.0, 21 Dec 2007" USE_STATS

(1 ligne)

testgis=# select version();

version

---

PostgreSQL 8.3.7 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.3.real (Debian 4.3.2-1.1) 4.3.2

(1 ligne)

EXECUTED QUERY select ST_buffer(the_geom,1) from worldcountries ;

TABLE testgis=# \d worldcountries;

Table « public.worldcountries »

Colonne | Type | Modificateurs

---

gid | integer | not null default nextval('worldcountries_gid_seq'::regclass) worcntry_i | bigint | id | character varying(9) | name | character varying(50) | iso_2 | character varying(9) | iso_num | character varying(3) | capital | character varying(19) | pop_1994 | bigint | continent | character varying(18) | the_geom | geometry |

Index :

« worldcountries_pkey » PRIMARY KEY, btree (gid) « worldcountries_the_geom_gist » gist (the_geom)

Contraintes de vérification :

« enforce_dims_the_geom » CHECK (ndims(the_geom) = 2) « enforce_geotype_the_geom » CHECK (geometrytype(the_geom) = 'MULTIPOLYGON'::text OR the_geom IS NULL) « enforce_srid_the_geom » CHECK (srid(the_geom) = 4326)

I visited similar tickets, ran some POLYGON cleaner PL/SQL provided with no effects.

[cmalaurie]

US country borders

[robe]

cmalaurie,

You are not runnning the latest 3.0 series. Have you tried upgrading your Geos to 3.0.3. I recall 3.0.0 having these problems, but I think most were fixed in 3.0.3.

Unfortunately I'm not near a postgresql server at the moment to test. Can you also provide the link where you downloaded the world countries file.

thanks, Regina

[cmalaurie]

Hi Regina Indeed it worked ! I downloaded the 3.1, compiled and now the query is running. So it looks like Debian packages are far behind the last libgeo release, as I used Debian aptitude package to download proj4, libgeos and postgis extension…as explained in docs. Not sure anyone can re-compile libs…

I downloaded the file from ​http://www.bluemarblegeo.com/products/worldmapdata.php?op=download, which is old data, very inaccurate. (by chance if you have any better file, please tell me). Anyway as far as I'm concerned the issue is closed. Thanks & Cheers