;>>> Thank you .
>>>>
>>>> Alan Fu.
>>>>
>>>> postgres=# \set VERBOSITY verbose
>>>> postgres=# SELECT
>>>> round(cast(coalesce(sum(ST_length(geography(geometry)))/1000,0) as
>>>> NUMERIC),4)||'KM
On 3/14/19 7:12 PM, fuzk wrote:
When I set max_parallel_workers_per_gather=0, the select statement can
execute successfully. The problem has been solved. Thank you all very
much. Alan
Well the problem has been hidden, not solved. It did establish that
invoking parallel query has something
Thomas Munro writes:
> A fast way to find out would be to get one of these people who can
> reproduce the problem to recompile PostgreSQL with that error changed
> to a PANIC, and examine the resulting smoldering core. (Someone had a
> proposal to make PostgreSQL errors optionally dump the functi
On Fri, Mar 15, 2019 at 6:09 AM Julien Rouhaud wrote:
> > > > https://trac.osgeo.org/postgis/ticket/4129
> I also tried to reproduce on latest postgis 2.4 / pg11 with anything
> even slightly related to what could call GetLatestSnapshot() with
> force_parallel_mode enabled and parallel_leader_pa
:
> > > >>> On 3/12/19 7:54 PM, fuzk wrote:
> > > >>>> postgres=# \set VERBOSITY verbose
> > > >>>> postgres=# SELECT
> > > >>>> round(cast(coalesce(sum(ST_length(geography(geometry)))/1000,0) as
> > > >>>> NU
s are you using ?
> > >
> > >> At 2019-03-13 22:31:11, "Adrian Klaver"
> > >> wrote:
> > >>> On 3/12/19 7:54 PM, fuzk wrote:
> > >>>> postgres=# \set VERBOSITY verbose
> > >>>> postgres=# S
PM, fuzk wrote:
> >>>> 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;
> >>>>
you please solve the problem for me?
What version of Postgres?
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 Second
22:31:11, "Adrian Klaver" wrote:
On 3/12/19 7:54 PM, fuzk wrote:
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 SecondarySnapsh
:11, "Adrian Klaver" wrote:
> >On 3/12/19 7:54 PM, fuzk wrote:
> >> postgres=# \set VERBOSITY verbose
> >> postgres=# SELECT
> >> round(cast(coalesce(sum(ST_length(geography(geometry)))/1000,0) as
> >> NUMERIC),4)||'KM' field_value
ce(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
&
(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
ield_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
13 matches
Mail list logo
