Subject: Re: PSA: we lack TAP test coverage on NetBSD and OpenBSD
From: =?UTF-8?Q?Mikael_Kjellstr=c3=b6m?= <mikael.kjellstrom@mksoft.nu>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@lists.postgresql.org
References: <9427.1547701450@sss.pgh.pa.us>
 <e22667cb-ceb1-a6d5-13a4-ced300868631@mksoft.nu>
 <22802.1547759781@sss.pgh.pa.us>
 <ad198f3d-957d-9d11-a386-0fae204c3518@mksoft.nu>
 <0a6ece1f-8175-e873-c459-c3a8fd18ad71@mksoft.nu>
 <26513.1547761358@sss.pgh.pa.us>
 <1d5a693b-1491-0527-44e8-ac21301f37a8@mksoft.nu>
 <cd736500-332f-994b-f506-126a350f24ee@mksoft.nu>
 <17004.1547763782@sss.pgh.pa.us>
 <b7ef913a-78e4-a953-f5c4-f2cec937eabd@mksoft.nu>
Message-ID: <c9b2e6d3-7ed8-ca52-d697-a9c2af9ff50c@mksoft.nu>
Date: Thu, 17 Jan 2019 23:54:46 +0100
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:60.0) Gecko/20100101
 Thunderbird/60.4.0
MIME-Version: 1.0
In-Reply-To: <b7ef913a-78e4-a953-f5c4-f2cec937eabd@mksoft.nu>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: sv-SE
Content-Transfer-Encoding: 8bit
Precedence: bulk


On 2019-01-17 23:37, Mikael Kjellström wrote:
> 
> On 2019-01-17 23:23, Tom Lane wrote:
> 
>> Yeah, you might've been able to get by with OpenBSD/NetBSD's default
>> semaphore settings before, but they really only let one postmaster
>> run at a time; and the TAP tests want to start more than one.
>> For me it seems to work to append this to /etc/sysctl.conf:
>>
>> kern.seminfo.semmni=100
>> kern.seminfo.semmns=2000
>>
>> and either reboot, or install those settings manually with sysctl.
> 
> Looks that way.
> 
> I've increased the values and rebooted the machines.
> 
> Let's hope 5th time is the charm :-)

Nope!

But it looks like in NetBSD the options are called:

netbsd7-pgbf# sysctl -a | grep semmn
kern.ipc.semmni = 10
kern.ipc.semmns = 60
kern.ipc.semmnu = 30

so I will try and set that in /etc/sysctl.conf and reboot and see what 
happens.

/Mikael