ERROR: XX000: cannot update SecondarySnapshot during a parallel operation

From: fuzk <fuzk80_76(at)163(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: ERROR: XX000: cannot update SecondarySnapshot during a parallel operation
Date: 2019-03-13 02:54:56
Message-ID: 58a76837.43af.16974f968f0.Coremail.fuzk80_76@163.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Munro 2019-03-13 03:20:52 Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2
Previous Message Amit Langote 2019-03-13 00:19:17 Re: Update does not move row across foreign partitions in v11