BUG #15691: ERROR: XX000: cannot update SecondarySnapshot during a parallel operation

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #15691: ERROR: XX000: cannot update SecondarySnapshot during a parallel operation
Дата
Msg-id 15691-62c4e860b7120958@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #15691: ERROR: XX000: cannot update SecondarySnapshotduring a parallel operation
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15691
Logged by:          zhongkuan fu
Email address:      fuzk80_76@163.com
PostgreSQL version: 10.3
Operating system:   Centos linux 7.4.1708
Description:

I cannot execute the following select sentence and got an error.

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-bugs по дате отправления:

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: BUG #15668: Server crash in transformPartitionRangeBounds
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: pg_rewind : feature to rewind promoted standby is broken!