Opened 6 years ago

Closed 6 years ago

Last modified 12 months ago

#4070 closed defect (fixed)

Wrong postgres error code

Reported by: furstenheim Owned by: pramsey
Priority: medium Milestone: PostGIS 2.4.5
Component: postgis Version: 2.4.x
Keywords: Cc:

Description

I have a query that is using the following postgis functions:

ST_AsMVT

ST_AsMVTGeom

TileBBox

(sorry I cannot show the whole query) To avoid wasting resources I often cancel the query if it is not needed (for example a user changing the zoom). I do that with pg_cancel_backend(pid)

Most of the time it works out fine and I get the proper exit code 57014. However, sometimes I get the following error:

GEOSisValid(): InterruptedException: Interrupted!

with an exit code of XX000 (internal error)

Change History (4)

comment:1 by furstenheim, 6 years ago

I forgot to say, TileBBox depends on ST_MakeEnvelope and ST_Transform

comment:2 by pramsey, 6 years ago

In 16561:

Emit a cancellation error code on GEOS interruptedExceptions, for consistency
with internal interruptions.
References #4070

comment:3 by pramsey, 6 years ago

Resolution: fixed
Status: newclosed

In 16562:

Emit a cancellation error code on GEOS interruptedExceptions, for consistency
with internal interruptions.
Closes #4070

comment:4 by strk, 12 months ago

For the record: the change introduced to fix this ticket changed the intended handling of the code, leaving the comment above the code snippet describe the old behavior and breaking some existing testcases, see #5365

Note: See TracTickets for help on using tickets.