Opened 6 years ago

Closed 6 years ago

#4137 closed defect (wontfix)

PostGIS 2.5.0beta1 fails tests on MIPS

Reported by: komzpa Owned by: pramsey
Priority: medium Milestone: PostGIS 2.5.1
Component: postgis Version: master
Keywords: Cc:

Description

Debian build farm broke the test:

​https://buildd.debian.org/status/fetch.php?pkg=postgis&arch=mips&ver=2.5.0~beta1%2Bdfsg-1~exp2&stamp=1531788162&raw=0 

	    </gml:Polygon>'));
Dropping cluster 10/regress ...
 ### /tmp/pgis_reg/test_117_diff ###
--- minimum_clearance_expected	2018-07-03 20:26:25.000000000 +0000
+++ /tmp/pgis_reg/test_117_out	2018-07-17 00:33:14.403382003 +0000
@@ -5,5 +5,5 @@
 t5|t
 t6|t
 t7|t
-t8|t
+t8|f
 t9|t
 ### /tmp/pgis_reg/test_134_diff ###
--- sfcgal/tickets_expected	2018-07-03 20:26:25.000000000 +0000
+++ /tmp/pgis_reg/test_134_out	2018-07-17 00:37:03.373003132 +0000
@@ -138,8 +138,8 @@
 #712|t
 #756.1|t|t
 #1023|t
-#1023.a|f
-#1023.b|t
+#1023.a|t
+#1023.b|f
 #1060|FFFFFFFF2
 #1273|t
 #1273.1|t
@@ -242,6 +242,6 @@
 #2108|SRID=3395;POINTM EMPTY
 #2117|SRID=3395;POINTM EMPTY
 #2110.1|f
-#2110.2|t
+#2110.2|f
 #2110.3|t
 #2145|6792004
 ### /tmp/pgis_reg/test_55_diff ###
--- operators_expected	2018-07-03 20:26:25.000000000 +0000
+++ /tmp/pgis_reg/test_55_out	2018-07-16 22:03:37.751593535 +0000
@@ -43,7 +43,7 @@
 ab3|t
 eq1|t
 eq2|f
-eq3|f
+eq3|t
 cd1|4
 bd1|0
 bd2|1
 ### /tmp/pgis_reg/test_94_diff ###
--- tickets_expected	2018-07-03 20:26:25.000000000 +0000
+++ /tmp/pgis_reg/test_94_out	2018-07-16 22:13:37.051799048 +0000
@@ -139,8 +139,8 @@
 #712|t
 #756.1|t|t
 #1023|t
-#1023.a|f
-#1023.b|t
+#1023.a|t
+#1023.b|f
 #1060|FFFFFFFF2
 #1273|t
 #1273.1|t
@@ -178,7 +178,7 @@
 #1453.2|f
 #1454|t
 #1414|CURVEPOLYGON Z EMPTY
-#1478|010100002001000000000000000000f87f000000000000f87f
+#1478|010100002001000000fffffffffffff77ffffffffffffff77f
 #745|GEOMETRYCOLLECTION(POLYGON((-72 42 1,-70 43 1,-71 41 1,-72 42 1)))
 #1450|POINT|POLYGON
 #1482|4326
@@ -234,7 +234,7 @@
 #2108|SRID=3395;POINTM EMPTY
 #2117|SRID=3395;POINTM EMPTY
 #2110.1|f
-#2110.2|t
+#2110.2|f
 #2110.3|t
 #2145|6792004
 #2232|M 0 0 l 0 0 1 0 0 0 1 0 0 0
@@ -304,10 +304,9 @@
 #3627a|o}~~|AdshNoSsBgd@eGoBlm@wKhj@~@?
 #3627b|t
 #3704|t
-#3709|t
+#3709|f
 #3774|t
 #1014a|POINT(0 0)
-#1014a|POINT(0 0)
 #1014b|POINT(0 1)
 #1014c|1|POINT(0 1)
 #1014c|2|POINT(1 2)
 ### /tmp/pgis_reg/test_97_diff ###
--- wkb_expected	2018-07-03 20:26:25.000000000 +0000
+++ /tmp/pgis_reg/test_97_out	2018-07-16 22:14:09.084024845 +0000
@@ -1,7 +1,7 @@
-POINT EMPTY|0101000000000000000000f87f000000000000f87f|t|00000000017ff80000000000007ff8000000000000
-POINT Z EMPTY|01e9030000000000000000f87f000000000000f87f000000000000f87f|t|00000003e97ff80000000000007ff80000000000007ff8000000000000
-POINT M EMPTY|01d1070000000000000000f87f000000000000f87f000000000000f87f|t|00000007d17ff80000000000007ff80000000000007ff8000000000000
-POINT ZM EMPTY|01b90b0000000000000000f87f000000000000f87f000000000000f87f000000000000f87f|t|0000000bb97ff80000000000007ff80000000000007ff80000000000007ff8000000000000
+POINT EMPTY|0101000000fffffffffffff77ffffffffffffff77f|t|00000000017ff7ffffffffffff7ff7ffffffffffff
+POINT Z EMPTY|01e9030000fffffffffffff77ffffffffffffff77ffffffffffffff77f|t|00000003e97ff7ffffffffffff7ff7ffffffffffff7ff7ffffffffffff
+POINT M EMPTY|01d1070000fffffffffffff77ffffffffffffff77ffffffffffffff77f|t|00000007d17ff7ffffffffffff7ff7ffffffffffff7ff7ffffffffffff
+POINT ZM EMPTY|01b90b0000fffffffffffff77ffffffffffffff77ffffffffffffff77ffffffffffffff77f|t|0000000bb97ff7ffffffffffff7ff7ffffffffffff7ff7ffffffffffff7ff7ffffffffffff
 POINT(0 0)|010100000000000000000000000000000000000000|t|000000000100000000000000000000000000000000
 POINT Z (1 2 3)|01e9030000000000000000f03f00000000000000400000000000000840|t|00000003e93ff000000000000040000000000000004008000000000000
 POINT M (1 2 3)|01d1070000000000000000f03f00000000000000400000000000000840|t|00000007d13ff000000000000040000000000000004008000000000000
@@ -55,8 +55,8 @@
 GEOMETRYCOLLECTION ZM (POINT ZM (0 0 0 0),LINESTRING ZM (0 0 0 0,1 1 1 1))|01bf0b00000200000001b90b0000000000000000000000000000000000000000000000000000000000000000000001ba0b0000020000000000000000000000000000000000000000000000000000000000000000000000000000000000f03f000000000000f03f000000000000f03f000000000000f03f|t|0000000bbf000000020000000bb900000000000000000000000000000000000000000000000000000000000000000000000bba0000000200000000000000000000000000000000000000000000000000000000000000003ff00000000000003ff00000000000003ff00000000000003ff0000000000000
 GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1))|01d70700000200000001d107000000000000000000000000000000000000000000000000000001d207000002000000000000000000000000000000000000000000000000000000000000000000f03f000000000000f03f000000000000f03f|t|00000007d70000000200000007d100000000000000000000000000000000000000000000000000000007d2000000020000000000000000000000000000000000000000000000003ff00000000000003ff00000000000003ff0000000000000
 GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1),GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1)))|01d70700000300000001d107000000000000000000000000000000000000000000000000000001d207000002000000000000000000000000000000000000000000000000000000000000000000f03f000000000000f03f000000000000f03f01d70700000200000001d107000000000000000000000000000000000000000000000000000001d207000002000000000000000000000000000000000000000000000000000000000000000000f03f000000000000f03f000000000000f03f|t|00000007d70000000300000007d100000000000000000000000000000000000000000000000000000007d2000000020000000000000000000000000000000000000000000000003ff00000000000003ff00000000000003ff000000000000000000007d70000000200000007d100000000000000000000000000000000000000000000000000000007d2000000020000000000000000000000000000000000000000000000003ff00000000000003ff00000000000003ff0000000000000
-GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1),POINT M EMPTY,GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1)))|01d70700000400000001d107000000000000000000000000000000000000000000000000000001d207000002000000000000000000000000000000000000000000000000000000000000000000f03f000000000000f03f000000000000f03f01d1070000000000000000f87f000000000000f87f000000000000f87f01d70700000200000001d107000000000000000000000000000000000000000000000000000001d207000002000000000000000000000000000000000000000000000000000000000000000000f03f000000000000f03f000000000000f03f|t|00000007d70000000400000007d100000000000000000000000000000000000000000000000000000007d2000000020000000000000000000000000000000000000000000000003ff00000000000003ff00000000000003ff000000000000000000007d17ff80000000000007ff80000000000007ff800000000000000000007d70000000200000007d100000000000000000000000000000000000000000000000000000007d2000000020000000000000000000000000000000000000000000000003ff00000000000003ff00000000000003ff0000000000000
-GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1),GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1),POINT M EMPTY,GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1))),POINT M EMPTY,GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1)))|01d70700000500000001d107000000000000000000000000000000000000000000000000000001d207000002000000000000000000000000000000000000000000000000000000000000000000f03f000000000000f03f000000000000f03f01d70700000400000001d107000000000000000000000000000000000000000000000000000001d207000002000000000000000000000000000000000000000000000000000000000000000000f03f000000000000f03f000000000000f03f01d1070000000000000000f87f000000000000f87f000000000000f87f01d70700000200000001d107000000000000000000000000000000000000000000000000000001d207000002000000000000000000000000000000000000000000000000000000000000000000f03f000000000000f03f000000000000f03f01d1070000000000000000f87f000000000000f87f000000000000f87f01d70700000200000001d107000000000000000000000000000000000000000000000000000001d207000002000000000000000000000000000000000000000000000000000000000000000000f03f000000000000f03f000000000000f03f|t|00000007d70000000500000007d100000000000000000000000000000000000000000000000000000007d2000000020000000000000000000000000000000000000000000000003ff00000000000003ff00000000000003ff000000000000000000007d70000000400000007d100000000000000000000000000000000000000000000000000000007d2000000020000000000000000000000000000000000000000000000003ff00000000000003ff00000000000003ff000000000000000000007d17ff80000000000007ff80000000000007ff800000000000000000007d70000000200000007d100000000000000000000000000000000000000000000000000000007d2000000020000000000000000000000000000000000000000000000003ff00000000000003ff00000000000003ff000000000000000000007d17ff80000000000007ff80000000000007ff800000000000000000007d70000000200000007d100000000000000000000000000000000000000000000000000000007d2000000020000000000000000000000000000000000000000000000003ff00000000000003ff00000000000003ff0000000000000
+GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1),POINT M EMPTY,GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1)))|01d70700000400000001d107000000000000000000000000000000000000000000000000000001d207000002000000000000000000000000000000000000000000000000000000000000000000f03f000000000000f03f000000000000f03f01d1070000fffffffffffff77ffffffffffffff77ffffffffffffff77f01d70700000200000001d107000000000000000000000000000000000000000000000000000001d207000002000000000000000000000000000000000000000000000000000000000000000000f03f000000000000f03f000000000000f03f|t|00000007d70000000400000007d100000000000000000000000000000000000000000000000000000007d2000000020000000000000000000000000000000000000000000000003ff00000000000003ff00000000000003ff000000000000000000007d17ff7ffffffffffff7ff7ffffffffffff7ff7ffffffffffff00000007d70000000200000007d100000000000000000000000000000000000000000000000000000007d2000000020000000000000000000000000000000000000000000000003ff00000000000003ff00000000000003ff0000000000000
+GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1),GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1),POINT M EMPTY,GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1))),POINT M EMPTY,GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1)))|01d70700000500000001d107000000000000000000000000000000000000000000000000000001d207000002000000000000000000000000000000000000000000000000000000000000000000f03f000000000000f03f000000000000f03f01d70700000400000001d107000000000000000000000000000000000000000000000000000001d207000002000000000000000000000000000000000000000000000000000000000000000000f03f000000000000f03f000000000000f03f01d1070000fffffffffffff77ffffffffffffff77ffffffffffffff77f01d70700000200000001d107000000000000000000000000000000000000000000000000000001d207000002000000000000000000000000000000000000000000000000000000000000000000f03f000000000000f03f000000000000f03f01d1070000fffffffffffff77ffffffffffffff77ffffffffffffff77f01d70700000200000001d107000000000000000000000000000000000000000000000000000001d207000002000000000000000000000000000000000000000000000000000000000000000000f03f000000000000f03f000000000000f03f|t|00000007d70000000500000007d100000000000000000000000000000000000000000000000000000007d2000000020000000000000000000000000000000000000000000000003ff00000000000003ff00000000000003ff000000000000000000007d70000000400000007d100000000000000000000000000000000000000000000000000000007d2000000020000000000000000000000000000000000000000000000003ff00000000000003ff00000000000003ff000000000000000000007d17ff7ffffffffffff7ff7ffffffffffff7ff7ffffffffffff00000007d70000000200000007d100000000000000000000000000000000000000000000000000000007d2000000020000000000000000000000000000000000000000000000003ff00000000000003ff00000000000003ff000000000000000000007d17ff7ffffffffffff7ff7ffffffffffff7ff7ffffffffffff00000007d70000000200000007d100000000000000000000000000000000000000000000000000000007d2000000020000000000000000000000000000000000000000000000003ff00000000000003ff00000000000003ff0000000000000
 CIRCULARSTRING EMPTY|010800000000000000|t|000000000800000000
 CIRCULARSTRING Z EMPTY|01f003000000000000|t|00000003f000000000
 CIRCULARSTRING M EMPTY|01d807000000000000|t|00000007d800000000
 ### end of log dumps ###
(set -e; \

Change History (6)

comment:1 by pramsey, 6 years ago

Resolution: → fixed
Status: new → closed

Seems better at RC1?

​https://buildd.debian.org/status/package.php?p=postgis&suite=experimental

comment:2 by komzpa, 6 years ago

Resolution: fixed
Status: closed → reopened

Please click the green "Installed" link. There you can see a test failure: 

 tickets .. failed (diff expected obtained: /tmp/pgis_reg/test_95_diff)
-----------------------------------------------------------------------------
--- tickets_expected	2018-08-19 21:46:50.000000000 +0000
+++ /tmp/pgis_reg/test_95_out	2018-08-20 08:19:44.274423637 +0000
@@ -178,7 +178,7 @@
 #1453.2|f
 #1454|t
 #1414|CURVEPOLYGON Z EMPTY
-#1478|010100002001000000000000000000f87f000000000000f87f
+#1478|010100002001000000fffffffffffff77ffffffffffffff77f
 #745|GEOMETRYCOLLECTION(POLYGON((-72 42 1,-70 43 1,-71 41 1,-72 42 1)))
 #1450|POINT|POLYGON
 #1482|4326
@@ -269,69 +269,7 @@
 #2788|f|Self-intersection|POINT(1 1)
 #2870|Point[GS]
 #2956|t
-#2985|LINESTRING(20.9511664253809 52.3984560730436)
-#2996|247.44|247.44
-#3119a|121
-#3119b|291
-#3119c|615
-#3119d|291
-#3172|LINESTRING M (0 0 1,0 0 2)
-#3300|POLYGON((-71.7821 42.2622,-71.7821 42.9067,-71.029 42.9067,-71.029 42.2622,-71.7821 42.2622))
-#3355|t
-#3356|LineString[] with 2 points|LineString[GS] with 2 points|LineString[GS] with 2 points
-#3356|LineString[B] with 3 points|LineString[BGS] with 3 points|LineString[BGS] with 3 points
-#3367|POLYGON EMPTY
-#3368|\x660001011fb98788d35ed6fbcdc831c580012b959f01469d8d0e9305ff8618ed08b1b607e302a614fe70bc4682b303b4379ab503a228eeb603e2138eb802900cc0b802ba04dab802b801a8840cb0229cca06f401c216f403a016ea05d0c301a8b301cc189226ac15ee27f811a029b40eac2ae00a902b8407c82b9e03d0e305801dfad3239504ce7e8d01e2f701f6019b04d1e2279bf901ff01
-#3375|GEOMETRYCOLLECTION(POINT(0 -7))
-#3399|1|1
-#3399|10|10
-#3399|100|100
-#3399|1000|1000
-ERROR:  invalid KML representation
-#3437a|5
-#3437b|5
-#3437c|5
-#3437d|5
-#3437e|5
-#3470|t
-#3470b|50
-#3569|BOX(1 2,3 4)
-#3578a|0
-#3578b|0
-#3579|f|t
-#3620a|POINT(3 7)
-#3620b|POINT(2 8)
-#3627a|o}~~|AdshNoSsBgd@eGoBlm@wKhj@~@?
-#3627b|t
-#3704|t
-#3709|t
-#3774|t
-#1014a|POINT(0 0)
-#1014a|POINT(0 0)
-#1014b|POINT(0 1)
-#1014c|1|POINT(0 1)
-#1014c|2|POINT(1 2)
-#1014c|3|POINT(2 3)
-#1014d|SRID=1;POINT(0 1)
-#1014d|SRID=2;POINT(0 1)
-#3930|62065
-NOTICE:  Too few points in geometry component at or near point 0 0
-#4011|ST_LineString|LINESTRING(0 0,1 1)|f|t
-#4011|ST_LineString|MULTILINESTRING((0 0,1 1),(1 1,2 2))|f|t
-#4011|ST_LineString|MULTILINESTRING((0 0,1 1),EMPTY)|f|t
-#4011|ST_MultiLineString|MULTILINESTRING(EMPTY,EMPTY)|t|t
-#4011||||
-#4011|ST_GeometryCollection|POLYGON((0 0,1 0,1 1,0 0))|f|t
-#4011|ST_LineString|GEOMETRYCOLLECTION(LINESTRING(0 0,1 1))|f|t
-#4011|ST_MultiLineString|MULTILINESTRING EMPTY|t|t
-#4011|ST_GeometryCollection|MULTILINESTRING((0 0,0 0))|f|f
-#4025|
-ERROR:  lwgeom_intersection: GEOS Error: TopologyException: Input geom 0 is invalid: Self-intersection
-ERROR:  lwgeom_difference: GEOS Error: TopologyException: Input geom 0 is invalid: Self-intersection
-ERROR:  lwgeom_symdifference: GEOS Error: TopologyException: Input geom 0 is invalid: Self-intersection
-ERROR:  lwgeom_union: GEOS Error: TopologyException: Input geom 0 is invalid: Self-intersection
-#4055a|4326
-#4055b|4326
-#4089|LINESTRING Z (1 1 1,3 3 1)
-ERROR:  lwgeom_pointonsurface: GEOS Error: TopologyException: Input geom 1 is invalid: Self-intersection
-#4081|f|t
+server closed the connection unexpectedly
+	This probably means the server terminated abnormally
+	before or while processing the request.
+connection to server was lost
-----------------------------------------------------------------------------
 twkb .. failed (diff expected obtained: /tmp/pgis_reg/test_96_diff)
-----------------------------------------------------------------------------
--- twkb_expected	2018-08-19 21:46:50.000000000 +0000
+++ /tmp/pgis_reg/test_96_out	2018-08-20 08:19:44.370425099 +0000
@@ -1,17 +1 @@
-POINT(1 1)|01000202
-POINT(1 1)|01000202
-POINT(78 -78)|01009c019b01
-POINT(123.456789 987.654321)|4100f4c0019a870c
-LINESTRING(120 10, -50 20, 300 -2)|020003f00114d30214bc052b
-LINESTRING(120 10, -50 20, 300 -2)|420003c0bb01d00fcf8902d00ff0a204af22
-LINESTRING(120.54 10.78, -50.2 20.878, 300.789 -21)|020003f20116d50214be0553
-POLYGON((1 1, 1 2, 2 2, 2 1, 1 1))|0300010502020002020000010100
-POLYGON((1 1, 1 20, 20 20, 20 1, 1 1),(3 3,3 4, 4 4,4 3,3 3))|03000205020200262600002525000504040002020000010100
-MULTIPOINT((1 1),(2 2))|04000202020202
-MULTILINESTRING((1 1,1 2,2 2),(3 3,3 4,4 4))|0500020302020002020003020200020200
-MULTIPOLYGON(((1 1, 1 2, 2 2, 2 1, 1 1)),((3 3,3 4,4 4,4 3,3 3)))|060002010502020002020000010100010504040002020000010100
-MULTIPOLYGON(((1 1, 1 20, 20 20, 20 1, 1 1),(3 3,3 4, 4 4,4 3,3 3)),((-1 1, -1 20, -20 20, -20 1, -1 1),(-3 3,-3 4, -4 4,-4 3,-3 3)))|06000202050202002626000025250005040400020200000101000205070300262500002526000503040002010000010200
-GEOMETRYCOLLECTION(POINT(1 1),LINESTRING(2 2,3 3))|0700020100020202000204040202
-GEOMETRYCOLLECTION(MULTIPOINT(1 1,2 2),POINT(78 -78),POLYGON((1 1,1 2,2 2,2 1,1 1)))|0700030400020202020201009c019b010300010502020002020000010100
-0701000802040201010800020008020201000202040202020104
-large geometry|060001019201aac755e8fea406061b52091c08260f1c08141c0524034c0d12153a211c0f06000e202c011a302e200e0e0702131923102d3e05460d341924071a100e0e121e093804261a02081b002f081f1227141d2015220f5a1d2c09240d0a05010b1b0515060908331645121f1017081f1a1f36150a1f1f00150411120d14150c31161f0417010f170f1d0429220f1a152c100808101820021207141f0e11020903031105270f2f2d370f071113001f1e0b16032211542326021a0c1c0b182f0a290c07220106100a080e0b4e3a0410051a042016161607041107190f230b210735091f091105051d02631c1900170e0b150d3d110927081d0a0f0b1819080f0205030f190f17044d241d12211c19220b14092c134019303304210545012f060504061827380524100e36232205
+psql: FATAL:  the database system is in recovery mode

comment:3 by robe, 6 years ago

Resolution: → fixed
Status: reopened → closed

comment:4 by robe, 6 years ago

Milestone: PostGIS 2.5.0 → PostGIS 2.5.1
Resolution: fixed
Status: closed → reopened

comment:5 by pramsey, 6 years ago

Well, I spent a great deal of time getting an emulated MIPS environment set up but I cannot replicate the crasher at tickets.sql #2985. Also, annoyingly, using nan("0") to get a formatted nan value, the MIPS version returns 000000f47f while the intel one returns 000000f87f. The both pass "isnan" tests fine, but that doesn't fix the hex-level checks for equivalence. It might be better just to drop the POINT EMPTY tests or replace them with something like 

select st_isempty('010100002001000000000000000000f87f000000000000f87f');
select st_isempty('010100002001000000000000000000f47f000000000000f47f');

which just checks that a couple different NAN representations still get read as nan and interpretted as POINT EMPTY

Version 0, edited 6 years ago by pramsey (next)

comment:6 by robe, 6 years ago

Resolution: → wontfix
Status: reopened → closed

I think we said mips is not common enough of a platform for us to care and the fact you can't replicate and its' hard to setup an env for it pushes it further down teh "DON'T CARE" heap.

Note: See TracTickets for help on using tickets.