[postgis-tickets] [PostGIS] #5335: Specific query hangs and can't be terminated when using ST_MVT/ST_AsMVTGeom

PostGIS trac at osgeo.org
Wed Feb 8 14:09:59 PST 2023


#5335: Specific query hangs and can't be terminated when using ST_MVT/ST_AsMVTGeom
----------------------+--------------------------------
  Reporter:  seabre   |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS PostgreSQL
 Component:  postgis  |    Version:  2.5.x
Resolution:           |   Keywords:
----------------------+--------------------------------
Comment (by seabre):

 The plan is for us to upgrade fairly soon, but running into the issues now
 and didn't see anything similar reported in the changelogs. I'm able to
 reproduce consistently on the affected machine but if I load a dump into a
 machine with the following versions:
 {{{
 POSTGIS="2.5.5" [EXTENSION] PGSQL="110" GEOS="3.7.3-CAPI-1.11.3 b50468f"
 PROJ="Rel. 5.2.0, September 15th, 2018" GDAL="GDAL 2.4.4, released
 2020/01/08" LIBXML="2.9.11" LIBJSON="0.13.1" LIBPROTOBUF="1.3.3" RASTER
 }}}

 {{{
 PostgreSQL 11.15 on x86_64-apple-darwin16.7.0, compiled by Apple LLVM
 version 8.1.0 (clang-802.0.42), 64-bit
 }}}

 The query runs fine, so it could be that any of the above mentioned
 solutions solve the problem. I'll dig more and see if I can provide more
 than what is in the original ticket.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5335#comment:2>
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