From: | tushar <tushar(dot)ahuja(at)enterprisedb(dot)com> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | ERROR: could not map dynamic shared memory segment |
Date: | 2018-02-07 10:42:11 |
Message-ID: | 35813af9-62bb-d14b-9c13-0cd7105aab3c@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi ,
I am getting ERROR: could not map dynamic shared memory segment in the
log file
- Please refer this scenario-
in V11/V10 latest sources
set parallel_setup_cost=0;
set parallel_tuple_cost=0;
set max_parallel_workers_per_gather=4;
create table r(n int);
insert into r values (generate_series(1,1000000));
insert into r values (generate_series(1000000,2000000));
analyze r;
postgres=# select * from r where n < (select n from r where n<=10000
limit 6644);
ERROR: more than one row returned by a subquery used as an expression
in the log file -
2018-02-07 10:28:27.615 GMT [20569] ERROR: more than one row returned
by a subquery used as an expression
2018-02-07 10:28:27.615 GMT [20569] STATEMENT: select * from r where n
< (select n from r where n<=10000 limit 6644);
2018-02-07 10:28:27.616 GMT [20586] ERROR: could not map dynamic shared
memory segment
2018-02-07 10:28:27.616 GMT [20587] ERROR: could not map dynamic shared
memory segment
2018-02-07 10:28:27.617 GMT [20559] LOG: background worker "parallel
worker" (PID 20586) exited with exit code 1
2018-02-07 10:28:27.617 GMT [20559] LOG: background worker "parallel
worker" (PID 20587) exited with exit code 1
Is this something already reported ?
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Munro | 2018-02-07 10:57:14 | Re: ERROR: could not map dynamic shared memory segment |
Previous Message | Etsuro Fujita | 2018-02-07 10:38:02 | Re: Incorrect grammar |