Re: Upgrade from 9.4 -> 9.5, FreeBSD 10.2-STABLE, fails on initdb

On 02/04/2016 10:02 AM, Karl Denninger wrote:
> $ initdb -D data-default
> The files belonging to this database system will be owned by user "pgsql".
> This user must also own the server process.
>
> The database cluster will be initialized with locale "C".
> The default database encoding has accordingly been set to "SQL_ASCII".
> The default text search configuration will be set to "english".
>
> Data page checksums are disabled.
>
> fixing permissions on existing directory data-default ... ok
> creating subdirectories ... ok
> selecting default max_connections ... 10
> selecting default shared_buffers ... 400kB
> selecting dynamic shared memory implementation ... posix
> creating configuration files ... ok
> creating template1 database in data-default/base/1 ... FATAL: could not
> create semaphores: Invalid argument
> DETAIL: Failed system call was semget(2, 17, 03600).
> child process exited with exit code 1
> initdb: removing contents of data directory "data-default"
> $
> $ sysctl -a|grep semm
> kern.ipc.semmsl: 512
> kern.ipc.semmnu: 256
> kern.ipc.semmns: 512
> kern.ipc.semmni: 256
>
> The system is running 9.4 just fine and the kernel configuration
> requirements shouldn't have changed for semaphores.... should they?

If it helps, the hint from the source code:

http://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/port/sysv_sema.c;h=f6f15169200a03e9da46ae348994f04297d22017;hb=HEAD

"This error does *not* mean that you have run out of disk space. It
occurs when either the system limit for the maximum number of semaphore
sets (SEMMNI), or the system wide maximum number of semaphores (SEMMNS),
would be exceeded. You need to raise the respective kernel parameter.
Alternatively, reduce PostgreSQL's consumption of semaphores by reducing
its max_connections parameter.
The PostgreSQL documentation contains more information about configuring
your system for PostgreSQL."

>
> --
> Karl Denninger
> karl(at)denninger(dot)net <mailto:karl(at)denninger(dot)net>
> /The Market Ticker/
> /[S/MIME encrypted email preferred]/

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com