| 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: | Whole Thread | Raw Message | 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 |