[postgis-tickets] [PostGIS] #4500: ReprojectPts regression on FreeBSD 12 / Proj 6.1.0

PostGIS trac at osgeo.org
Mon Sep 2 21:53:38 PDT 2019


#4500: ReprojectPts regression on FreeBSD 12 / Proj 6.1.0
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  blocker  |  Milestone:  PostGIS 3.0.0
Component:  postgis  |    Version:  2.5.x
 Keywords:           |
---------------------+---------------------------
 {{{
 00:43:45  -------------- Dependencies --------------
 00:43:45   GEOS config:          /usr/local/bin/geos-config
 00:43:45   GEOS version:         3.7.2
 00:43:45   GDAL config:          /usr/local/bin/gdal-config
 00:43:45   GDAL version:         2.4.1
 00:43:45   SFCGAL config:        /usr/local/bin/sfcgal-config
 00:43:45   SFCGAL version:       1.3.6
 00:43:45   PostgreSQL config:    /usr/local/bin/pg_config
 00:43:45   PostgreSQL version:   PostgreSQL 11.4
 00:43:45   PROJ4 version:        61
 00:43:45   Libxml2 config:       /usr/local/bin/xml2-config
 00:43:45   Libxml2 version:      2.9.9
 00:43:45   JSON-C support:       yes
 00:43:45   protobuf support:     yes
 00:43:45   protobuf-c version:   1003002
 00:43:45   PCRE support:         yes
 00:43:45   Perl:                 /usr/local/bin/perl
 00:43:45   Wagyu:                yes
 00:43:45
 00:43:45  --------------- Extensions ---------------
 00:43:45   PostGIS Raster:                     enabled
 00:43:45   PostGIS Topology:                   enabled
 00:43:45   SFCGAL support:                     enabled
 00:43:45   Address Standardizer support:       enabled
 00:43:45
 }}}



 {{{
 00:47:16  ../loader/ReprojectPts ..... failed (wkt testdiff expected
 obtained:
 /home/jenkins/tmp/pgis_reg_ce7c214c9f8cafa55857173c0af789e440e7d651/test_20_diff)
 00:47:25
 -----------------------------------------------------------------------------
 00:47:25 --- ../loader/ReprojectPts-w.select.expected   2019-09-03
 00:42:19.557981000 +0000
 00:47:25 +++
 /home/jenkins/tmp/pgis_reg_ce7c214c9f8cafa55857173c0af789e440e7d651/test_20_out
 2019-09-03 00:46:29.149665000 +0000
 00:47:25 @@ -1,66 +1,66 @@
 00:47:25 -SRID=4326;POINT(-74.17782492 41.08263361)
 00:47:25 -SRID=4326;POINT(-74.44881286 40.50133744)
 00:47:25 +SRID=4326;POINT(-74.17782443 41.08263361)
 00:47:25 +SRID=4326;POINT(-74.4488128 40.50133699)
 00:47:25  SRID=4326;POINT(-74.00376358 40.28149688)
 00:47:25  SRID=4326;POINT(-75.12863742 39.7797389)
 00:47:25 -SRID=4326;POINT(-74.57629014 40.85597595)
 00:47:25 -SRID=4326;POINT(-74.47160401 40.52369066)
 00:47:25 +SRID=4326;POINT(-74.57628962 40.85597621)
 00:47:25 +SRID=4326;POINT(-74.47160381 40.52369026)
 00:47:25  SRID=4326;POINT(-75.46891683 39.69688334)
 00:47:25  SRID=4326;POINT(-75.11458618 39.70739231)
 00:47:25  SRID=4326;POINT(-74.22643701 40.09726563)
 00:47:25 -SRID=4326;POINT(-74.26766926 40.83522615)
 00:47:25 -SRID=4326;POINT(-74.42152037 40.76232181)
 00:47:25 -SRID=4326;POINT(-74.18666598 40.89980341)
 00:47:25 -SRID=4326;POINT(-74.20201874 40.94448827)
 00:47:25 -SRID=4326;POINT(-74.31866663 40.6680465)
 00:47:25 -SRID=4326;POINT(-74.83205963 40.84912898)
 00:47:25 +SRID=4326;POINT(-74.26766872 40.8352264)
 00:47:25 +SRID=4326;POINT(-74.42151978 40.76232209)
 00:47:25 +SRID=4326;POINT(-74.1866655 40.89980354)
 00:47:25 +SRID=4326;POINT(-74.20201825 40.94448845)
 00:47:25 +SRID=4326;POINT(-74.31866643 40.66804657)
 00:47:25 +SRID=4326;POINT(-74.83205905 40.84912911)
 00:47:25  SRID=4326;POINT(-74.64402101 39.96633708)
 00:47:25  SRID=4326;POINT(-74.22194028 40.09559148)
 00:47:25 -SRID=4326;POINT(-74.60375255 40.75504208)
 00:47:25 -SRID=4326;POINT(-74.09376018 40.86569336)
 00:47:25 -SRID=4326;POINT(-74.4430374 40.77797967)
 00:47:25 +SRID=4326;POINT(-74.60375193 40.75504234)
 00:47:25 +SRID=4326;POINT(-74.09375981 40.86569326)
 00:47:25 +SRID=4326;POINT(-74.44303683 40.77797995)
 00:47:25  SRID=4326;POINT(-74.76841703 40.22038455)
 00:47:25 -SRID=4326;POINT(-74.19078182 40.73914574)
 00:47:25 -SRID=4326;POINT(-74.19628444 40.79591416)
 00:47:25 -SRID=4326;POINT(-74.19130306 40.74330253)
 00:47:25 -SRID=4326;POINT(-74.17636308 40.73783123)
 00:47:25 +SRID=4326;POINT(-74.19078139 40.73914578)
 00:47:25 +SRID=4326;POINT(-74.19628396 40.79591425)
 00:47:25 +SRID=4326;POINT(-74.19130262 40.74330258)
 00:47:25 +SRID=4326;POINT(-74.17636268 40.73783123)
 00:47:25  SRID=4326;POINT(-74.53148731 39.49029456)
 00:47:25 -SRID=4326;POINT(-74.16618054 40.73634864)
 00:47:25 -SRID=4326;POINT(-74.35732607 40.80076793)
 00:47:25 -SRID=4326;POINT(-74.17573811 40.73901418)
 00:47:25 +SRID=4326;POINT(-74.16618015 40.7363486)
 00:47:25 +SRID=4326;POINT(-74.35732552 40.80076819)
 00:47:25 +SRID=4326;POINT(-74.1757377 40.73901418)
 00:47:25  SRID=4326;POINT(-74.66491581 40.34572735)
 00:47:25 -SRID=4326;POINT(-74.36625323 40.51061374)
 00:47:25 -SRID=4326;POINT(-74.17631876 40.74329159)
 00:47:25 -SRID=4326;POINT(-74.4544664 40.52427239)
 00:47:25 -SRID=4326;POINT(-74.02836656 40.89756584)
 00:47:25 +SRID=4326;POINT(-74.36625351 40.51061338)
 00:47:25 +SRID=4326;POINT(-74.17631833 40.74329159)
 00:47:25 +SRID=4326;POINT(-74.45446627 40.524272)
 00:47:25 +SRID=4326;POINT(-74.02836625 40.89756567)
 00:47:25  SRID=4326;POINT(-75.00833975 39.82895026)
 00:47:25  SRID=4326;POINT(-74.13132221 40.33161528)
 00:47:25  SRID=4326;POINT(-74.67999522 39.46203859)
 00:47:25 -SRID=4326;POINT(-74.08904806 40.9515804)
 00:47:25 +SRID=4326;POINT(-74.08904769 40.95158042)
 00:47:25  SRID=4326;POINT(-75.12091068 39.94826917)
 00:47:25 -SRID=4326;POINT(-74.08628025 40.70929009)
 00:47:25 +SRID=4326;POINT(-74.08628002 40.70928983)
 00:47:25  SRID=4326;POINT(-74.73270242 40.27825159)
 00:47:25  SRID=4326;POINT(-74.16625303 40.01000431)
 00:47:25 -SRID=4326;POINT(-75.01837982 40.74472398)
 00:47:25 +SRID=4326;POINT(-75.01837916 40.74472384)
 00:47:25  SRID=4326;POINT(-74.65920653 40.34951097)
 00:47:25 -SRID=4326;POINT(-74.24751143 40.74434122)
 00:47:25 +SRID=4326;POINT(-74.24751093 40.74434144)
 00:47:25  SRID=4326;POINT(-74.65122484 40.25151634)
 00:47:25  SRID=4326;POINT(-74.43880205 40.4659008)
 00:47:25 -SRID=4326;POINT(-74.2355417 40.68231466)
 00:47:25 -SRID=4326;POINT(-74.49892935 40.80763833)
 00:47:25 -SRID=4326;POINT(-74.0625762 40.73086062)
 00:47:25 +SRID=4326;POINT(-74.23554154 40.68231473)
 00:47:25 +SRID=4326;POINT(-74.49892881 40.80763861)
 00:47:25 +SRID=4326;POINT(-74.06257592 40.73086029)
 00:47:25  SRID=4326;POINT(-75.03600164 39.78659251)
 00:47:25  SRID=4326;POINT(-75.05591643 39.44084942)
 00:47:25 -SRID=4326;POINT(-74.39804333 40.50086907)
 00:47:25 -SRID=4326;POINT(-74.07131567 40.72720191)
 00:47:25 -SRID=4326;POINT(-74.19117919 40.74196293)
 00:47:25 -SRID=4326;POINT(-74.02494262 40.74676479)
 00:47:25 -SRID=4326;POINT(-74.68894668 40.6094749)
 00:47:25 -SRID=4326;POINT(-74.44600226 40.49825884)
 00:47:25 -SRID=4326;POINT(-74.19898991 40.85779571)
 00:47:25 +SRID=4326;POINT(-74.3980435 40.50086867)
 00:47:25 +SRID=4326;POINT(-74.07131539 40.7272016)
 00:47:25 +SRID=4326;POINT(-74.19117875 40.74196297)
 00:47:25 +SRID=4326;POINT(-74.02494233 40.74676432)
 00:47:25 +SRID=4326;POINT(-74.68894621 40.60947485)
 00:47:25 +SRID=4326;POINT(-74.44600222 40.49825839)
 00:47:25 +SRID=4326;POINT(-74.19898942 40.85779584)
 00:47:25  SRID=4326;POINT(-74.7828046 40.27094999)
 00:47:25  SRID=4326;POINT(-74.25017536 40.217432)
 00:47:25 -SRID=4326;POINT(-74.16960551 40.91844326)
 00:47:25 -SRID=4326;POINT(-74.75788852 41.06754763)
 00:47:25 -SRID=4326;POINT(-74.03363729 40.72689071)
 00:47:25 -SRID=4326;POINT(-74.5760699 40.53743164)
 00:47:25 -SRID=4326;POINT(-74.43925667 40.77359187)
 00:47:25 +SRID=4326;POINT(-74.16960505 40.91844337)
 00:47:25 +SRID=4326;POINT(-74.75788819 41.06754779)
 00:47:25 +SRID=4326;POINT(-74.03363704 40.7268903)
 00:47:25 +SRID=4326;POINT(-74.57606955 40.53743133)
 00:47:25 +SRID=4326;POINT(-74.43925609 40.77359215)
 00:47:25
 -----------------------------------------------------------------------------
 00:47:25  ../loader/ReprojectPtsD ..... failed (wkb testdiff expected
 obtained:
 /home/jenkins/tmp/pgis_reg_ce7c214c9f8cafa55857173c0af789e440e7d651/test_21_diff)
 00:47:25
 -----------------------------------------------------------------------------
 00:47:25 --- ../loader/ReprojectPtsD.select.expected    2019-09-03
 00:42:19.558718000 +0000
 00:47:25 +++
 /home/jenkins/tmp/pgis_reg_ce7c214c9f8cafa55857173c0af789e440e7d651/test_21_out
 2019-09-03 00:46:29.763057000 +0000
 00:47:25 @@ -1,66 +1,66 @@
 00:47:25 -SRID=4326;POINT(-74.17782492 41.08263361)
 00:47:25 -SRID=4326;POINT(-74.44881286 40.50133744)
 00:47:25 +SRID=4326;POINT(-74.17782443 41.08263361)
 00:47:25 +SRID=4326;POINT(-74.4488128 40.50133699)
 00:47:25  SRID=4326;POINT(-74.00376358 40.28149688)
 00:47:25  SRID=4326;POINT(-75.12863742 39.7797389)
 00:47:25 -SRID=4326;POINT(-74.57629014 40.85597595)
 00:47:25 -SRID=4326;POINT(-74.47160401 40.52369066)
 00:47:25 +SRID=4326;POINT(-74.57628962 40.85597621)
 00:47:25 +SRID=4326;POINT(-74.47160381 40.52369026)
 00:47:25  SRID=4326;POINT(-75.46891683 39.69688334)
 00:47:25  SRID=4326;POINT(-75.11458618 39.70739231)
 00:47:25  SRID=4326;POINT(-74.22643701 40.09726563)
 00:47:25 -SRID=4326;POINT(-74.26766926 40.83522615)
 00:47:25 -SRID=4326;POINT(-74.42152037 40.76232181)
 00:47:25 -SRID=4326;POINT(-74.18666598 40.89980341)
 00:47:25 -SRID=4326;POINT(-74.20201874 40.94448827)
 00:47:25 -SRID=4326;POINT(-74.31866663 40.6680465)
 00:47:25 -SRID=4326;POINT(-74.83205963 40.84912898)
 00:47:25 +SRID=4326;POINT(-74.26766872 40.8352264)
 00:47:25 +SRID=4326;POINT(-74.42151978 40.76232209)
 00:47:25 +SRID=4326;POINT(-74.1866655 40.89980354)
 00:47:25 +SRID=4326;POINT(-74.20201825 40.94448845)
 00:47:25 +SRID=4326;POINT(-74.31866643 40.66804657)
 00:47:25 +SRID=4326;POINT(-74.83205905 40.84912911)
 00:47:25  SRID=4326;POINT(-74.64402101 39.96633708)
 00:47:25  SRID=4326;POINT(-74.22194028 40.09559148)
 00:47:25 -SRID=4326;POINT(-74.60375255 40.75504208)
 00:47:25 -SRID=4326;POINT(-74.09376018 40.86569336)
 00:47:25 -SRID=4326;POINT(-74.4430374 40.77797967)
 00:47:25 +SRID=4326;POINT(-74.60375193 40.75504234)
 00:47:25 +SRID=4326;POINT(-74.09375981 40.86569326)
 00:47:25 +SRID=4326;POINT(-74.44303683 40.77797995)
 00:47:25  SRID=4326;POINT(-74.76841703 40.22038455)
 00:47:25 -SRID=4326;POINT(-74.19078182 40.73914574)
 00:47:25 -SRID=4326;POINT(-74.19628444 40.79591416)
 00:47:25 -SRID=4326;POINT(-74.19130306 40.74330253)
 00:47:25 -SRID=4326;POINT(-74.17636308 40.73783123)
 00:47:25 +SRID=4326;POINT(-74.19078139 40.73914578)
 00:47:25 +SRID=4326;POINT(-74.19628396 40.79591425)
 00:47:25 +SRID=4326;POINT(-74.19130262 40.74330258)
 00:47:25 +SRID=4326;POINT(-74.17636268 40.73783123)
 00:47:25  SRID=4326;POINT(-74.53148731 39.49029456)
 00:47:25 -SRID=4326;POINT(-74.16618054 40.73634864)
 00:47:25 -SRID=4326;POINT(-74.35732607 40.80076793)
 00:47:25 -SRID=4326;POINT(-74.17573811 40.73901418)
 00:47:25 +SRID=4326;POINT(-74.16618015 40.7363486)
 00:47:25 +SRID=4326;POINT(-74.35732552 40.80076819)
 00:47:25 +SRID=4326;POINT(-74.1757377 40.73901418)
 00:47:25  SRID=4326;POINT(-74.66491581 40.34572735)
 00:47:25 -SRID=4326;POINT(-74.36625323 40.51061374)
 00:47:25 -SRID=4326;POINT(-74.17631876 40.74329159)
 00:47:25 -SRID=4326;POINT(-74.4544664 40.52427239)
 00:47:25 -SRID=4326;POINT(-74.02836656 40.89756584)
 00:47:25 +SRID=4326;POINT(-74.36625351 40.51061338)
 00:47:25 +SRID=4326;POINT(-74.17631833 40.74329159)
 00:47:25 +SRID=4326;POINT(-74.45446627 40.524272)
 00:47:25 +SRID=4326;POINT(-74.02836625 40.89756567)
 00:47:25  SRID=4326;POINT(-75.00833975 39.82895026)
 00:47:25  SRID=4326;POINT(-74.13132221 40.33161528)
 00:47:25  SRID=4326;POINT(-74.67999522 39.46203859)
 00:47:25 -SRID=4326;POINT(-74.08904806 40.9515804)
 00:47:25 +SRID=4326;POINT(-74.08904769 40.95158042)
 00:47:25  SRID=4326;POINT(-75.12091068 39.94826917)
 00:47:25 -SRID=4326;POINT(-74.08628025 40.70929009)
 00:47:25 +SRID=4326;POINT(-74.08628002 40.70928983)
 00:47:25  SRID=4326;POINT(-74.73270242 40.27825159)
 00:47:25  SRID=4326;POINT(-74.16625303 40.01000431)
 00:47:25 -SRID=4326;POINT(-75.01837982 40.74472398)
 00:47:25 +SRID=4326;POINT(-75.01837916 40.74472384)
 00:47:25  SRID=4326;POINT(-74.65920653 40.34951097)
 00:47:25 -SRID=4326;POINT(-74.24751143 40.74434122)
 00:47:25 +SRID=4326;POINT(-74.24751093 40.74434144)
 00:47:25  SRID=4326;POINT(-74.65122484 40.25151634)
 00:47:25  SRID=4326;POINT(-74.43880205 40.4659008)
 00:47:25 -SRID=4326;POINT(-74.2355417 40.68231466)
 00:47:25 -SRID=4326;POINT(-74.49892935 40.80763833)
 00:47:25 -SRID=4326;POINT(-74.0625762 40.73086062)
 00:47:25 +SRID=4326;POINT(-74.23554154 40.68231473)
 00:47:25 +SRID=4326;POINT(-74.49892881 40.80763861)
 00:47:25 +SRID=4326;POINT(-74.06257592 40.73086029)
 00:47:25  SRID=4326;POINT(-75.03600164 39.78659251)
 00:47:25  SRID=4326;POINT(-75.05591643 39.44084942)
 00:47:25 -SRID=4326;POINT(-74.39804333 40.50086907)
 00:47:25 -SRID=4326;POINT(-74.07131567 40.72720191)
 00:47:25 -SRID=4326;POINT(-74.19117919 40.74196293)
 00:47:25 -SRID=4326;POINT(-74.02494262 40.74676479)
 00:47:25 -SRID=4326;POINT(-74.68894668 40.6094749)
 00:47:25 -SRID=4326;POINT(-74.44600226 40.49825884)
 00:47:25 -SRID=4326;POINT(-74.19898991 40.85779571)
 00:47:25 +SRID=4326;POINT(-74.3980435 40.50086867)
 00:47:25 +SRID=4326;POINT(-74.07131539 40.7272016)
 00:47:25 +SRID=4326;POINT(-74.19117875 40.74196297)
 00:47:25 +SRID=4326;POINT(-74.02494233 40.74676432)
 00:47:25 +SRID=4326;POINT(-74.68894621 40.60947485)
 00:47:25 +SRID=4326;POINT(-74.44600222 40.49825839)
 00:47:25 +SRID=4326;POINT(-74.19898942 40.85779584)
 00:47:25  SRID=4326;POINT(-74.7828046 40.27094999)
 00:47:25  SRID=4326;POINT(-74.25017536 40.217432)
 00:47:25 -SRID=4326;POINT(-74.16960551 40.91844326)
 00:47:25 -SRID=4326;POINT(-74.75788852 41.06754763)
 00:47:25 -SRID=4326;POINT(-74.03363729 40.72689071)
 00:47:25 -SRID=4326;POINT(-74.5760699 40.53743164)
 00:47:25 -SRID=4326;POINT(-74.43925667 40.77359187)
 00:47:25 +SRID=4326;POINT(-74.16960505 40.91844337)
 00:47:25 +SRID=4326;POINT(-74.75788819 41.06754779)
 00:47:25 +SRID=4326;POINT(-74.03363704 40.7268903)
 00:47:25 +SRID=4326;POINT(-74.57606955 40.53743133)
 00:47:25 +SRID=4326;POINT(-74.43925609 40.77359215)
 00:47:25
 -----------------------------------------------------------------------------
 00:47:25  ../loader/ReprojectPtsGeog .... failed ( wkt test: running
 shp2pgsql output:
 /home/jenkins/tmp/pgis_reg_ce7c214c9f8cafa55857173c0af789e440e7d651/loader.err)
 00:47:26
 -----------------------------------------------------------------------------
 00:47:26 SET
 00:47:26 SET
 00:47:26 BEGIN
 00:47:26
 psql:/home/jenkins/tmp/pgis_reg_ce7c214c9f8cafa55857173c0af789e440e7d651/loader.out:5:
 ERROR:  relation "loadedshp" already exists
 00:47:26
 -----------------------------------------------------------------------------
 00:47:26  ../loader/ReprojectPtsGeogD .... failed ( wkt test: running
 shp2pgsql output:
 /home/jenkins/tmp/pgis_reg_ce7c214c9f8cafa55857173c0af789e440e7d651/loader.err)
 00:47:26
 -----------------------------------------------------------------------------
 00:47:26 SET
 00:47:26 SET
 00:47:26 BEGIN
 00:47:26
 psql:/home/jenkins/tmp/pgis_reg_ce7c214c9f8cafa55857173c0af789e440e7d651/loader.out:5:
 ERROR:  relation "loadedshp" already exists
 00:47:26
 -----------------------------------------------------------------------------
 }}}

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


More information about the postgis-tickets mailing list