Re: BUG #16067: Failed system call was semget

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: chelsealyu(at)gmail(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16067: Failed system call was semget
Date: 2019-10-20 03:42:49
Message-ID: 15052.1571542969@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> Operating system: MacOS

> running bootstrap script ... 2019-10-19 23:25:15.095 JST [51410] FATAL:
> could not create semaphores: No space left on device
> 2019-10-19 23:25:15.095 JST [51410] DETAIL: Failed system call was
> semget(5432226, 17, 03600).

That's a bit odd. macOS is known to have low default limits for
SysV shared memory, but not for semaphores. Which macOS version
are you running, exactly? What do you get from
sysctl -a | grep sysv.sem
? I get

kern.sysv.semmni: 87381
kern.sysv.semmns: 87381
kern.sysv.semmnu: 87381
kern.sysv.semmsl: 87381
kern.sysv.semume: 10

(and not only in Catalina, but very ancient mac versions)

Is it possible that something else is chewing up semaphores?
Looking at "sudo ipcs -s" output would reveal that.

> I also tried the code in the guide book of solving this question.
> RAYEdeMacBook-Pro:~ raye$ sysctl -w kern.sysv.shmmax
> kern.sysv.shmmax: 4194304

That is not about this problem.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Eric Toombs 2019-10-20 03:51:44 Re: BUG #16065: The operation nodes in query plans outputted by EXPLAIN have no authoritative definitions.
Previous Message Jeff Janes 2019-10-19 21:07:02 Re: BUG #16065: The operation nodes in query plans outputted by EXPLAIN have no authoritative definitions.