PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15691
PG Version10.3
OSCentos linux 7.4.1708
Opened2019-03-13 07:23:03+00
Reported byzhongkuan fu
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15691
Logged by:          zhongkuan fu
Email address:      (redacted)
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

Messages

DateAuthorSubject
2019-03-13 07:23:03+00PG Bug reporting formBUG #15691: ERROR: XX000: cannot update SecondarySnapshot during a parallel operation
2019-03-13 13:54:55+00Alvaro HerreraRe: BUG #15691: ERROR: XX000: cannot update SecondarySnapshot during a parallel operation