[postgis-tickets] [PostGIS] #3644: interrupt_relate test hangs

[PostGIS]

#3644: interrupt_relate test hangs
---------------------+---------------------------
 Reporter:  strk     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  blocker  |  Milestone:  PostGIS 2.3.1
Component:  postgis  |    Version:  trunk
 Keywords:           |
---------------------+---------------------------
 Running "make check" hangs at the second "interrupt_relate .." line,
 indefinitely. The first one gets through.

 This is on a just-upgraded "Ubuntu 16.04".

 ps(1) shows the postgres backend sleeping:
 {{{
 31269 ?        Ss     0:00 postgres: strk postgis_reg [local] SELECT
 }}}

 pg_stat_activity view on the matter:
 {{{
 datid            | 56073418
 datname          | postgis_reg
 pid              | 31269
 usesysid         | 10
 usename          | strk
 application_name | psql
 client_addr      |
 client_hostname  |
 client_port      | -1
 backend_start    | 2016-09-27 09:12:52.207264+02
 xact_start       | 2016-09-27 09:12:52.248314+02
 query_start      | 2016-09-27 09:12:52.248314+02
 state_change     | 2016-09-27 09:12:52.248315+02
 waiting          | f
 state            | active
 query            | select ST_Contains(g,g) from _inputs WHERE id = 1;
 }}}

 now() is:
 {{{
 now | 2016-09-27 09:18:03.375686+02
 }}}

 So after 5 minutes the process is still there sleeping

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