Didn't see a file attached to this. -----Original Message----- From: postgis-users [mailto:[email protected]] On Behalf Of Jaime Casanova Sent: Saturday, July 30, 2016 3:25 PM To: [email protected] Subject: Re: [postgis-users] segmentation fault in lwgeom_geos.c
On 25 July 2016 at 18:24, Jaime Casanova <[email protected]> wrote: > Hi, > > We found a problem in this query: > > """ > SELECT DISTINCT vias_calle1, vias_calle2, > x(st_transform(centroid(the_geom),4326)) as longitud, > y(st_transform(centroid(the_geom),4326)) as latitud, > x(centroid(the_geom)) as x, y(centroid(the_geom)) as y > FROM (SELECT DISTINCT > v1.via_nombre as vias_calle1, > v2.via_nombre as vias_calle2, > st_union(ST_Intersection(v1.the_geom,v2.the_geom)) > as the_geom > FROM bage_via as v1, bage_via as v2 > WHERE v1.via_nombre LIKE 'MAXIMILIANO RODRIGUEZ' > AND v2.via_nombre LIKE 'LAURO GUERRERO' > AND intersects(v1.the_geom,v2.the_geom) > AND v1.dipo_codiinec LIKE '170121%' > AND v2.dipo_codiinec LIKE '170121%' > GROUP BY v1.via_nombre, v2.via_nombre > ) as foo > """ > > Attached a file with the backtrace, please let me know what else i can > provide to help debug this? I have access to the server with the > problem. > > PostGIS full version > > POSTGIS="2.1.8 r13780" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, > 6 March 2012" GDAL="GDAL 1.11.4, released 2016/0 1/25" LIBXML="2.9.1" > LIBJSON="UNKNOWN" TOPOLOGY RASTER > > postgres version > > PostgreSQL 9.4.8 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) > 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit > HI, Anything i can do to help debug this? -- Jaime Casanova www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/postgis-users
