Wrong postgres error code

[furstenheim]

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)

[furstenheim]

I forgot to say, TileBBox depends on ST_MakeEnvelope and ST_Transform

[pramsey]

In 16561:

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

[pramsey]

In 16562:

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

[strk]

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