Re: ERROR: XX000: cannot update SecondarySnapshot during a paralleloperation - Mailing list pgsql-general

From Adrian Klaver
Subject Re: ERROR: XX000: cannot update SecondarySnapshot during a paralleloperation
Date
Msg-id c6c07fec-bbc9-f382-d4f5-451fec103c12@aklaver.com
Whole thread Raw
In response to ERROR: XX000: cannot update SecondarySnapshot during a paralleloperation  (fuzk <fuzk80_76@163.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Noah Misch
Date:
Subject: Re: LDAP authenticated session terminated by signal 11: Segmentationfault, PostgresSQL server terminates other active server processes
Next
From: M Tarkeshwar Rao
Date:
Subject: Facing issue in using special characters