Re:Re: ERROR: XX000: cannot update SecondarySnapshot during a parallel operation

Dear Adrian,

My setting is as following.

max_parallel_workers_per_gather=32

I am looking forward to hearing from you.

Many thanks
Alan.

At 2019-03-13 22:31:11, "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>On 3/12/19 7:54 PM, fuzk wrote:
>> Dear Sir/Madam
>>
>> I got an error when I execute the following select sentence.
>> Would you please solve the problem for me?
>
>What version of Postgres?
>
>> Thank you .
>>
>> Alan Fu.
>>
>> postgres=# \set VERBOSITY verbose
>> postgres=# SELECT
>> round(cast(coalesce(sum(ST_length(geography(geometry)))/1000,0) as
>> NUMERIC),4)||'KM' field_value from had_link;
>>
>> ERROR: XX000: cannot update SecondarySnapshot during a parallel operation
>> CONTEXT: SQL statement "SELECT proj4text FROM public.spatial_ref_sys
>> WHERE srid = 4326 LIMIT 1"
>> parallel worker
>> LOCATION: GetLatestSnapshot, snapmgr.c:387
>
>I'm guessing ST_length is not parallel safe.
>
>What is your setting for?:
>
>max_parallel_workers_per_gather
>
>>
>>
>
>
>--
>Adrian Klaver
>adrian(dot)klaver(at)aklaver(dot)com