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

From fuzk
Subject ERROR: XX000: cannot update SecondarySnapshot during a paralleloperation
Date
Msg-id 58a76837.43af.16974f968f0.Coremail.fuzk80_76@163.com
Whole thread Raw
Responses Re: ERROR: XX000: cannot update SecondarySnapshot during a paralleloperation  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Dear Sir/Madam

I got an error when I execute the following select sentence.
Would you please solve the problem for me?
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


 

pgsql-general by date:

Previous
From: 王pg
Date:
Subject: Re: POSTGRES/MYSQL
Next
From: Thomas Munro
Date:
Subject: Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2