[postgis-tickets] [PostGIS] #4776: st_geometrytype causes 100% CPU loop in postgres13 on specific linestring

[PostGIS]

#4776: st_geometrytype causes 100% CPU loop in postgres13 on specific linestring
-------------------------+---------------------------
  Reporter:  tvijlbrief  |      Owner:  pramsey
      Type:  defect      |     Status:  new
  Priority:  blocker     |  Milestone:  PostGIS 3.0.3
 Component:  postgis     |    Version:  3.0.x
Resolution:              |   Keywords:
-------------------------+---------------------------

Comment (by tvijlbrief):

 Top 10 stack entries when hanging:

 {{{
 #0  pglz_decompress (source=source at entry=0x55584d6c39b0 "",
 slen=<optimized out>,
     dest=dest at entry=0x55584d6c3a3c "", rawsize=rawsize at entry=52,
     check_complete=check_complete at entry=false) at
 ./build/../src/common/pg_lzcompress.c:767
 #1  0x000055584c5906cb in toast_decompress_datum_slice (slicelength=52,
 attr=0x55584d6c39a8)
     at ./build/../src/backend/access/common/detoast.c:483
 #2  detoast_attr_slice (attr=<optimized out>,
 sliceoffset=sliceoffset at entry=0, slicelength=52)
     at ./build/../src/backend/access/common/detoast.c:274
 #3  0x000055584c9e6f2a in pg_detoast_datum_slice (datum=<optimized out>,
 first=first at entry=0,
     count=<optimized out>) at
 ./build/../src/backend/utils/fmgr/fmgr.c:1754
 #4  0x00007f0bc257a7c1 in geometry_geometrytype (fcinfo=0x55584d6bea60) at
 lwgeom_ogc.c:199
 #5  0x000055584c740c9e in ExecInterpExpr (state=0x55584d6be578,
 econtext=0x55584d6be260,
     isnull=<optimized out>) at
 ./build/../src/backend/executor/execExprInterp.c:699
 #6  0x000055584c74ec62 in ExecEvalExprSwitchContext
 (isNull=0x7ffec8369497, econtext=0x55584d6be260,
     state=0x55584d6be578) at
 ./build/../src/include/executor/executor.h:313
 #7  ExecProject (projInfo=0x55584d6be570) at
 ./build/../src/include/executor/executor.h:347
 #8  ExecScan (node=<optimized out>, accessMtd=0x55584c773130 <SeqNext>,
     recheckMtd=0x55584c7731c0 <SeqRecheck>) at
 ./build/../src/backend/executor/execScan.c:238
 #9  0x000055584c744bcd in ExecProcNode (node=0x55584d6be150)
     at ./build/../src/include/executor/executor.h:245
 #10 ExecutePlan (execute_once=<optimized out>, dest=0x55584d6b8640,
 direction=<optimized out>,
     numberTuples=0, sendTuples=<optimized out>, operation=CMD_SELECT,
     use_parallel_mode=<optimized out>, planstate=0x55584d6be150,
 estate=0x55584d6bded8)
     at ./build/../src/backend/executor/execMain.c:1646
 }}}

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