[PostGIS] #5687: PostgreSQL 17 regression failures with spgist indexes

[PostGIS]

#5687: PostgreSQL 17 regression failures with spgist indexes
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  blocker  |  Milestone:  PostGIS 3.5.0
Component:  postgis  |    Version:  3.4.x
 Keywords:           |
---------------------+---------------------------
 We've got some PG17 regression failures coming, mostly around our index
 check tests


 {{{
 15:37:02  regress/core/regress_spgist_index_2d .. failed (diff expected
 obtained:
 /var/lib/jenkins/workspace/postgis/tmp/3_5_pg17w64/test_126_diff)
 15:37:03
 -----------------------------------------------------------------------------
 15:37:03 --- ./regress/core/regress_spgist_index_2d_expected    2023-09-12
 16:48:00.450733931 +0000
 15:37:03 +++
 /var/lib/jenkins/workspace/postgis/tmp/3_5_pg17w64/test_126_out
 2024-03-05 20:37:03.604434128 +0000
 15:37:03 @@ -1,12 +1,13 @@
 15:37:03 -<< |3880|Seq Scan|3880|Index Scan
 15:37:03 -&< |21321|Seq Scan|21321|Index Scan
 15:37:03 -&& |31766|Seq Scan|31766|Index Scan
 15:37:03 -&> |21321|Seq Scan|21321|Index Scan
 15:37:03 ->> |3880|Seq Scan|3880|Index Scan
 15:37:03 -~= |206|Seq Scan|206|Index Scan
 15:37:03 -~  |7568|Seq Scan|7568|Index Scan
 15:37:03 -@  |7568|Seq Scan|7568|Index Scan
 15:37:03 -&<||21321|Seq Scan|21321|Index Scan
 15:37:03 -<<||3661|Seq Scan|3661|Index Scan
 15:37:03 -|>>|3661|Seq Scan|3661|Index Scan
 15:37:03 -|&>|21321|Seq Scan|21321|Index Scan
 15:37:03 +ERROR:  Unable to determine 'postgis' install schema
 15:37:03 +<< |3880|Seq Scan|3880|Seq Scan
 15:37:03 +&< |21321|Seq Scan|21321|Seq Scan
 15:37:03 +&& |31766|Seq Scan|31766|Seq Scan
 15:37:03 +&> |21321|Seq Scan|21321|Seq Scan
 15:37:03 +>> |3880|Seq Scan|3880|Seq Scan
 15:37:03 +~= |206|Seq Scan|206|Seq Scan
 15:37:03 +~  |7568|Seq Scan|7568|Seq Scan
 15:37:03 +@  |7568|Seq Scan|7568|Seq Scan
 15:37:03 +&<||21321|Seq Scan|21321|Seq Scan
 15:37:03 +<<||3661|Seq Scan|3661|Seq Scan
 15:37:03 +|>>|3661|Seq Scan|3661|Seq Scan
 15:37:03 +|&>|21321|Seq Scan|21321|Seq Scan
 15:37:03
 -----------------------------------------------------------------------------
 15:37:03  regress/core/regress_spgist_index_3d .. failed (diff expected
 obtained:
 /var/lib/jenkins/workspace/postgis/tmp/3_5_pg17w64/test_127_diff)
 15:37:05
 -----------------------------------------------------------------------------
 15:37:05 --- ./regress/core/regress_spgist_index_3d_expected    2023-09-12
 16:48:00.454733920 +0000
 15:37:05 +++
 /var/lib/jenkins/workspace/postgis/tmp/3_5_pg17w64/test_127_out
 2024-03-05 20:37:05.296429133 +0000
 15:37:05 @@ -1,4 +1,5 @@
 15:37:05 -&/&|26619|Seq Scan|26619|Index Scan
 15:37:05 -@>>|4677|Seq Scan|4677|Index Scan
 15:37:05 -<<@|4677|Seq Scan|4677|Index Scan
 15:37:05 -~==|199|Seq Scan|199|Index Scan
 15:37:05 +ERROR:  Unable to determine 'postgis' install schema
 15:37:05 +&/&|26619|Seq Scan|26619|Seq Scan
 15:37:05 +@>>|4677|Seq Scan|4677|Seq Scan
 15:37:05 +<<@|4677|Seq Scan|4677|Seq Scan
 15:37:05 +~==|199|Seq Scan|199|Seq Scan
 15:37:05
 -----------------------------------------------------------------------------
 15:37:05  regress/core/regress_spgist_index_nd .. failed (diff expected
 obtained:
 /var/lib/jenkins/workspace/postgis/tmp/3_5_pg17w64/test_128_diff)
 15:37:06
 -----------------------------------------------------------------------------
 15:37:06 --- ./regress/core/regress_spgist_index_nd_expected    2023-09-12
 16:48:00.454733920 +0000
 15:37:06 +++
 /var/lib/jenkins/workspace/postgis/tmp/3_5_pg17w64/test_128_out
 2024-03-05 20:37:06.320426110 +0000
 15:37:06 @@ -1,4 +1,5 @@
 15:37:06 -&&&|180502|Seq Scan|180502|Index Scan
 15:37:06 -~~ |39682|Seq Scan|39682|Index Scan
 15:37:06 -@@ |39682|Seq Scan|39682|Index Scan
 15:37:06 -~~=|480|Seq Scan|480|Index Scan
 15:37:06 +ERROR:  Unable to determine 'postgis' install schema
 15:37:06 +&&&|180502|Seq Scan|180502|Seq Scan
 15:37:06 +~~ |39682|Seq Scan|39682|Seq Scan
 15:37:06 +@@ |39682|Seq Scan|39682|Seq Scan
 15:37:06 +~~=|480|Seq Scan|480|Seq Scan
 15:37:06
 -----------------------------------------------------------------------------
 }}}

 This has been happening possibly since 2024-03-01, but hard to say cause
 master branch has been failing since around then too because of topology
 issues.  The first real specific PG17 regress failure I see like this is
 2024-03-05. and prior to 2024-03-01 we have greens everywhere.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5687>
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.