[postgis-tickets] [PostGIS] #5309: ST_ClusterKMeans not working on PostGIS 3.23

[PostGIS]

#5309: ST_ClusterKMeans not working on PostGIS 3.23
---------------------+---------------------
 Reporter:  jbtw     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:
Component:  postgis  |    Version:  3.2.x
 Keywords:           |
---------------------+---------------------
 Hello,

 It seems to me that ST_ClusterKMeans is not working on PostGIS 3.23. I
 noticed that some queries including a clustering step were failing and
 locally even the example from the ST_ClusterKMeans documentation page
 fails with an abrupt termination.

 {{{
 CREATE TABLE parcels AS
 SELECT lpad((row_number() over())::text,3,'0') As parcel_id, geom,
 ('{residential, commercial}'::text[])[1 + mod(row_number()OVER(),2)] As
 type
 FROM
     ST_Subdivide(ST_Buffer('SRID=3857;LINESTRING(40 100, 98 100, 100 150,
 60 90)'::geometry,
     40, 'endcap=square'),12) As geom;

 SELECT ST_ClusterKMeans(geom, 3) OVER() AS cid, parcel_id, geom
     FROM parcels;
 }}}

 Termination Message:
 {{{
 psql:test.sql:10: server closed the connection unexpectedly
         This probably means the server terminated abnormally
         before or while processing the request.
 psql:test.sql:10: fatal: connection to server was lost
 }}}


 PostGIS Full version output:

 {{{
 POSTGIS="3.2.3 v2.4.3-242-g8556d9e" [EXTENSION] PGSQL="140"
 GEOS="3.10.3-CAPI-1.16.1" PROJ="8.1.1" LIBXML="2.9.14" LIBJSON="0.15"
 LIBPROTOBUF="1.4.1" WAGYU="0.5.0 (Internal)" (core procs from "3.1.4
 v2.4.3-44-g7ef659a"
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5309>
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.