[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