ERROR: could not map dynamic shared memory segment

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

Responses

Browse pgsql-hackers by date

  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