[postgis-tickets] [PostGIS] #4857: Large ST_Union makes PostgreSQL temporarily unrestartable

[PostGIS]

#4857: Large ST_Union makes PostgreSQL temporarily unrestartable
-----------------------+---------------------------
  Reporter:  grassick  |      Owner:  pramsey
      Type:  defect    |     Status:  new
  Priority:  high      |  Milestone:  PostGIS 3.1.2
 Component:  postgis   |    Version:  3.1.x
Resolution:            |   Keywords:
-----------------------+---------------------------

Comment (by grassick):

 Before you "won't fix" it, I can now reproduce every time having the query
 almost instantly killable by pgAdmin:

 {{{
 ERROR:  lwgeom_unaryunion_prec: GEOS Error: InterruptedException:
 Interrupted!
 SQL state: XX000
 }}}

 But very slow to kill the same query at the same point by restarting the
 server!

 There must be some difference in the behaviour between the two. It creates
 a real problem in that restarting the server can bring the entire
 production database down for up to two minutes.

 I understand this is a frustrating bug, but if there's a way to cause it
 to abort in the same way during a database shutdown, it would prevent some
 major outages.

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