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@xxxxxxxxxxx
