ERROR: XX000: cannot update SecondarySnapshot during a paralleloperation

Поиск
Список
Период
Сортировка
От fuzk
Тема ERROR: XX000: cannot update SecondarySnapshot during a paralleloperation
Дата
Msg-id 58a76837.43af.16974f968f0.Coremail.fuzk80_76@163.com
обсуждение исходный текст
Ответы Re: ERROR: XX000: cannot update SecondarySnapshot during a paralleloperation  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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 по дате отправления:

Предыдущее
От: 王pg
Дата:
Сообщение: Re: POSTGRES/MYSQL
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2