On 3/14/19 7:12 PM, fuzk wrote:
> When I set max_parallel_workers_per_gather=0, the select statement can
> execute successfully. The problem has been solved. Thank you all very
> much. Alan
>
Well the problem has been hidden, not solved. It did establish that
invoking parallel query has something to do with it. There also the fact
that by max_parallel_workers_per_gather is set to 0 by default. So the
setting you had previously(32) would imply that someone wanted to use
parallel query. If it is re-enabled then you are back to the error. To
help solve the problem for yourself and others could you supply relevant
information to the this problem report:
https://trac.osgeo.org/postgis/ticket/4129
--
Adrian Klaver
adrian.klaver@aklaver.com