[PostGIS] #5841: Pg18 changes pqsignal() return

PostGIS trac at osgeo.org
Sun Jan 26 18:10:00 PST 2025


#5841: Pg18 changes pqsignal() return
----------------------+---------------------------
  Reporter:  pramsey  |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 3.6.0
 Component:  postgis  |    Version:  master
Resolution:           |   Keywords:
----------------------+---------------------------
Comment (by robe):

 Looks like the commit broke interruptability on  winnie, tried triggering
 a number of times and fails in same spot.
 The 3.5 branch of hers was green before this. 5 minutes is hard to ignore,
 but since the other interrupts are passing perhaps its only the GEOS one
 at issue.

 On winnie I see this, but interrupt and interrupt_relate are okay
 {{{
  ./regress/core/interrupt_buffer .. failed (diff expected obtained:
 /projects/postgis/tmp/3.5.1dev_pg16_geos3.13_gdal3.9.2w64/test_126_diff)
 -----------------------------------------------------------------------------
 --- ./regress/core/interrupt_buffer_expected    2024-10-29
 18:48:10.401068900 -0400
 +++ /projects/postgis/tmp/3.5.1dev_pg16_geos3.13_gdal3.9.2w64/test_126_out
 2025-01-25 12:40:10.602262300 -0500
 @@ -1,3 +1,3 @@
  ERROR:  canceling statement due to statement timeout
 -buffer interrupted on time
 +buffer interrupted late: 00:04:53.254363 (00:00:06.07376 tolerated)
  1|5
 -----------------------------------------------------------------------------
 }}}

 Dronie did fail once, but I think this is a random interrupt failure

 On dronie:


 {{{
  regress/core/interrupt .. failed (diff expected obtained:
 /tmp/pgis_reg/test_124_diff)

 -----------------------------------------------------------------------------

 --- /drone/src/regress/core/interrupt_expected  2025-01-24
 23:12:20.455468619 +0000

 +++ /tmp/pgis_reg/test_124_out  2025-01-25 00:19:54.053246531 +0000

 @@ -1,3 +1,3 @@

  ERROR:  canceling statement due to statement timeout

 -segmentize interrupted on time

 +ERROR:  canceling statement due to statement timeout

  1|LINESTRING(0 0,2 0,4 0)

 -----------------------------------------------------------------------------

  regress/core/interrupt_relate .. ok in 1428 ms

  regress/core/interrupt_buffer .. ok in 618 ms
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5841#comment:7>
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