[postgis-tickets] [PostGIS] #3272: PostgreSQL 9.2 64-bit windows fails on loader/dumper

[PostGIS]

#3272: PostgreSQL 9.2 64-bit windows fails on loader/dumper
------------------------+---------------------------
  Reporter:  robe       |      Owner:  robe
      Type:  defect     |     Status:  new
  Priority:  medium     |  Milestone:  PostGIS 2.2.0
 Component:  buildbots  |    Version:  trunk
Resolution:             |   Keywords:
------------------------+---------------------------
Description changed by robe:

Old description:

> I had recently added PostgreSQL 9.2 64-bit and noticed on winnie it
> consistently crashes at:
>

>
> {{{
>  loader/Point .. failed ( wkt test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  loader/PointM .. failed ( wkt test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  loader/PointZ .. failed ( wkt test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  loader/MultiPoint .. failed ( wkt test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  loader/MultiPointM .. failed ( wkt test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  loader/MultiPointZ .. failed ( wkt test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  loader/Arc .. failed ( wkt test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  loader/ArcM .. failed ( wkt test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  loader/ArcZ .. failed ( wkt test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  loader/Polygon .. failed ( wkt test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  loader/PolygonM .. failed ( wkt test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  loader/PolygonZ .. failed ( wkt test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  loader/TSTPolygon .. failed ( wkt test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  loader/TSIPolygon .. failed ( wkt test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  loader/TSTIPolygon .. failed ( wkt test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  loader/PointWithSchema ... failed ( wkb test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  loader/NoTransPoint .. failed ( wkt test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  loader/NotReallyMultiPoint .. failed ( wkt test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  loader/MultiToSinglePoint .. failed ( wkt test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  loader/ReprojectPts ... failed ( wkt test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  loader/ReprojectPtsGeog ... failed ( wkt test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  loader/Latin1 .. failed ( wkb test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  loader/Latin1-implicit .. failed ( wkb test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  loader/mfile .. failed ( wkb test: running shp2pgsql:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  dumper/literalsrid ... failed (dumping:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/dumper-
> literalsrid.err)
> -----------------------------------------------------------------------------
> -----------------------------------------------------------------------------
>  dumper/realtable ... failed (dumping:
> /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/dumper-
> realtable.err)
> -----------------------------------------------------------------------------
> }}}
>

>
> I haven't ruled out a configuration error on my part.
>
> The 32-bit 9.2 seems fine though.

New description:

 I had recently added PostgreSQL 9.2 64-bit and noticed on winnie it
 consistently crashes at:



 {{{
  loader/Point .. failed ( wkt test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  loader/PointM .. failed ( wkt test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  loader/PointZ .. failed ( wkt test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  loader/MultiPoint .. failed ( wkt test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  loader/MultiPointM .. failed ( wkt test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  loader/MultiPointZ .. failed ( wkt test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  loader/Arc .. failed ( wkt test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  loader/ArcM .. failed ( wkt test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  loader/ArcZ .. failed ( wkt test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  loader/Polygon .. failed ( wkt test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  loader/PolygonM .. failed ( wkt test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  loader/PolygonZ .. failed ( wkt test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  loader/TSTPolygon .. failed ( wkt test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  loader/TSIPolygon .. failed ( wkt test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  loader/TSTIPolygon .. failed ( wkt test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  loader/PointWithSchema ... failed ( wkb test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  loader/NoTransPoint .. failed ( wkt test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  loader/NotReallyMultiPoint .. failed ( wkt test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  loader/MultiToSinglePoint .. failed ( wkt test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  loader/ReprojectPts ... failed ( wkt test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  loader/ReprojectPtsGeog ... failed ( wkt test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  loader/Latin1 .. failed ( wkb test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  loader/Latin1-implicit .. failed ( wkb test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  loader/mfile .. failed ( wkb test: running shp2pgsql:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/loader.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  dumper/literalsrid ... failed (dumping:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/dumper-
 literalsrid.err)
 -----------------------------------------------------------------------------
 -----------------------------------------------------------------------------
  dumper/realtable ... failed (dumping:
 /projects/postgis/tmp/2.2.0dev_pg9.2_geos3.5.0_gdal2.0w64/dumper-
 realtable.err)
 -----------------------------------------------------------------------------
 }}}



 I haven't ruled out a configuration error on my part.

 The 32-bit 9.2 seems fine though and debbies 9.2 64-bit runs seem fine as
 well except for one crasher the other day which I dismissed as because
 GDAL regress was running at same time.

--

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3272#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.