Re: pkg/48258: mysql-server startup files may try to set to high fd-limit in pkgsrc-startup-file

[Wolfgang Stukenbrock <wolfgang.stukenbrock%nagler-company.com@localhost>]

The following reply was made to PR pkg/48258; it has been noted by GNATS.

From: Wolfgang Stukenbrock <wolfgang.stukenbrock%nagler-company.com@localhost>
To: gnats-bugs%NetBSD.org@localhost
Cc: pkg-manager%NetBSD.org@localhost, gnats-admin%NetBSD.org@localhost, 
pkgsrc-bugs%NetBSD.org@localhost
Subject: Re: pkg/48258: mysql-server startup files may try to set to high 
fd-limit in pkgsrc-startup-file
Date: Wed, 02 Oct 2013 14:32:37 +0200

 Hi - OK, I haven't tested that again on NetBSD.
 
 On Solaris ulimit with a to large value will give an error. (tested 
 again in /bin/sh and with setrlimit() for some minutes.)
 
 On NetBSD there seems to be (now) the feature that ulimit in /bin/sh and 
 setrlimit() will clamp the parameter passed to the maximum - the hard-limit.
 
 So for NetBSD this is working, but for any other system that does not 
 silently clamp the value it doesn't.
 I'm not shure about the set of OS's that is affected. At least Solaris 8 is.
 
 pkgsrc is for more than "only" NetBSD, so I think it would be better not 
 to "hope" that the system will truncate to the max.
 Sorry for not explicitly testing on NetBSD prior sending the report.
 
 By The way, I have had this problem with the FD-limit with mysqld in the 
 past, so that I have added some commandline options in my automated 
 DB-setup scripts that are executed during system installation, but I'm 
 not shure about the NetBSD version where I've added this (3.x or 4.x). 
 It is still in there, even it is (perhaps) now no longer needed.
 And I remember that my main DB-server has crashed when I try to set a 
 larger value as the kernel supports in the DB-server-config file - e.g. 
 when I boot a GENERIC for some reasons - I've increased the hard-limit 
 in the "normal" kernel for this system. That system currently runs 
 NetBSD 4.x.
 
 just for information (till now):
 I'm debugging an other problem with the delivered rc-files for 
 mysql-server 5.5, because the DB-server crashes during startup when 
 started during system startup on NetBSD 6.1. Calling "/etc/rc.d/mysqld 
 start" by hand later will bring the deamon up.
 (It seems to be either mysql 5.5 related or is a problem with NetBSD 
 6.1, because mysql 5.1 on NetBSD 5.1.2 does not show this problem on 
 several installations.)
 Still not found what it is. Without additional debugging inserted the 
 DB-server runs into SEGV after setting up the socket and prior the 
 message that it is now listening in the error log. But when started 
 under ktrace it still does not start, but it now looks like "something" 
 is shutting down the server during startup (no SEGV anymore), but the 
 normal shutdown messages are in the error-log file of the DB-server. 
 Very strange till now ...
 
 best regards
 
 W. Stukenbrock
 
 OBATA Akio wrote:
 
 > The following reply was made to PR pkg/48258; it has been noted by GNATS.
 > 
 > From: "OBATA Akio" <obache%netbsd.org@localhost>
 > To: gnats-bugs%netbsd.org@localhost
 > Cc: 
 > Subject: Re: pkg/48258: mysql-server startup files may try to set to high
 >  fd-limit in pkgsrc-startup-file
 > Date: Wed, 02 Oct 2013 20:19:35 +0900
 > 
 >  On Wed, 02 Oct 2013 20:00:00 +0900, 
 > <Wolfgang.Stukenbrock%nagler-company.com@localhost> wrote:
 >  
 >  >> How-To-Repeat:
 >  >   setup a fresh system (e.g. amd64), log in and run "ulimit -Hn". It will 
 > report 3404.
 >  >   And so setting 4096 in the rc-file will (silently) fail and the server 
 > will stay at 128 fd's.
 >  
 >  I cannot reproduce it on NetBSD-5.1.2-i386, soft limit will be up to the 
 > hard limit:
 >  
 >  # ulimit -Hn
 >  3404
 >  # ulimit -Sn
 >  128
 >  # ulimit -n 4096
 >  # ulimit -Hn
 >  3404
 >  # ulimit -Sn
 >  3404
 >  
 >  -- 
 >  OBATA Akio / obache%NetBSD.org@localhost
 >  
 > 
 > 
 > Received: from DB3PR07MB171.eurprd07.prod.outlook.com (10.242.132.149) by
 >  DB3PR07MB169.eurprd07.prod.outlook.com (10.242.132.141) with Microsoft SMTP
 >  Server (TLS) id 15.0.775.9 via Mailbox Transport; Wed, 2 Oct 2013 11:25:09
 >  +0000
 > Received: from DB3PR07CA009.eurprd07.prod.outlook.com (10.242.134.49) by
 >  DB3PR07MB171.eurprd07.prod.outlook.com (10.242.132.149) with Microsoft SMTP
 >  Server (TLS) id 15.0.775.9; Wed, 2 Oct 2013 11:25:07 +0000
 > Received: from AM1FFO11FD017.protection.gbl (2a01:111:f400:7e00::124) by
 >  DB3PR07CA009.outlook.office365.com (2a01:111:e400:9814::49) with Microsoft
 >  SMTP Server (TLS) id 15.0.775.9 via Frontend Transport; Wed, 2 Oct 2013
 >  11:25:07 +0000
 > Received: from e002.nagler-company.com (212.185.86.227) by
 >  AM1FFO11FD017.mail.protection.outlook.com (10.174.64.206) with Microsoft 
 > SMTP
 >  Server (TLS) id 15.0.785.10 via Frontend Transport; Wed, 2 Oct 2013 11:25:06
 >  +0000
 > Received: from mollari.NetBSD.org (blog.netbsd.org [149.20.53.80])   by
 >  e002.nagler-company.com (8.14.5/8.14.5) with ESMTP id r92BP2js014397        
 > for
 >  <Wolfgang.Stukenbrock%nagler-company.com@localhost>; Wed, 2 Oct 2013 
 > 13:25:06 +0200
 >  (CEST)
 > Received: by mollari.NetBSD.org (Postfix, from userid 31008) id 612697100A;
 >  Wed,  2 Oct 2013 11:25:01 +0000 (UTC)
 > From: OBATA Akio <obache%NetBSD.org@localhost>
 > To: <pkg-manager%NetBSD.org@localhost>, <gnats-admin%NetBSD.org@localhost>,
 >      <pkgsrc-bugs%NetBSD.org@localhost>, 
 > <Wolfgang.Stukenbrock%nagler-company.com@localhost>
 > Reply-To: <gnats-bugs%NetBSD.org@localhost>
 > Subject: Re: pkg/48258: mysql-server startup files may try to set to high
 >  fd-limit in pkgsrc-startup-file
 > References: <pr-pkg-48258%gnats.netbsd.org@localhost>
 >   <20131002105744.E5864123B93%test-s0.nagler-company.com@localhost>
 > X-Gnats-Was-Stupid: no
 > CC:
 > Message-ID: <20131002112501.612697100A%mollari.NetBSD.org@localhost>
 > Date: Wed, 2 Oct 2013 11:25:01 +0000
 > Return-Path: gnats%NetBSD.org@localhost
 > X-MS-Exchange-Organization-MessageDirectionality: Incoming
 > X-Forefront-Antispam-Report: 
 > CIP:212.185.86.227;CTRY:DE;IPV:NLI;EFV:NLI;SFV:NSPM;SFS:(24454002)(189002)(199002)(43066001)(81342001)(47776003)(20776003)(63696002)(47446002)(74662001)(74502001)(16796002)(50466002)(81542001)(6806004)(77982001)(83072001)(46386002)(45336002)(44976005)(52956002)(42186004)(33656001)(51856001)(83322001)(19580405001)(19580395003)(80976001)(74876001)(70486001)(54356001)(47976001)(76482001)(54316002)(50986001)(49866001)(56776001)(4396001)(47736001)(81686001)(79102001)(81816001)(48376002)(74706001)(59766001)(56816003)(76786001)(77096001)(46102001)(76796001)(69226001)(80022001)(65816001)(74366001)(42262001);DIR:INB;SFP:;SCL:1;SRVR:DB3PR07MB171;H:e002.nagler-company.com;CLIP:212.185.86.227;FPR:;RD:e002.nagler-company.com;MX:1;A:1;LANG:en;
 > Content-Type: text/plain
 > X-MS-Exchange-Organization-Network-Message-Id: 
 > 83c85e0a-9996-4672-2882-08d08d792ecc
 > X-MS-Exchange-Organization-AVStamp-Service: 1.0
 > Received-SPF: None (: NetBSD.org does not designate permitted sender hosts)
 > X-MS-Exchange-Organization-SCL: 1
 > X-MS-Exchange-Organization-AuthSource: AM1FFO11FD017.protection.gbl
 > X-MS-Exchange-Organization-AuthAs: Anonymous
 > MIME-Version: 1.0
 > 
 > The following reply was made to PR pkg/48258; it has been noted by GNATS.
 > 
 > From: "OBATA Akio" <obache%netbsd.org@localhost>
 > To: gnats-bugs%netbsd.org@localhost
 > Cc: 
 > Subject: Re: pkg/48258: mysql-server startup files may try to set to high
 >  fd-limit in pkgsrc-startup-file
 > Date: Wed, 02 Oct 2013 20:19:35 +0900
 > 
 >  On Wed, 02 Oct 2013 20:00:00 +0900, 
 > <Wolfgang.Stukenbrock%nagler-company.com@localhost> wrote:
 >  
 >  >> How-To-Repeat:
 >  >   setup a fresh system (e.g. amd64), log in and run "ulimit -Hn". It will 
 > report 3404.
 >  >   And so setting 4096 in the rc-file will (silently) fail and the server 
 > will stay at 128 fd's.
 >  
 >  I cannot reproduce it on NetBSD-5.1.2-i386, soft limit will be up to the 
 > hard limit:
 >  
 >  # ulimit -Hn
 >  3404
 >  # ulimit -Sn
 >  128
 >  # ulimit -n 4096
 >  # ulimit -Hn
 >  3404
 >  # ulimit -Sn
 >  3404
 >  
 >  -- 
 >  OBATA Akio / obache%NetBSD.org@localhost
 >  
 > 
 
 
 -- 
 
 
 Dr. Nagler & Company GmbH
 Hauptstraße 9
 92253 Schnaittenbach
 
 Tel. +49 9622/71 97-42
 Fax +49 9622/71 97-50
 
 Wolfgang.Stukenbrock%nagler-company.com@localhost
 http://www.nagler-company.com
 
 
 Hauptsitz: Schnaittenbach
 Handelregister: Amberg HRB
 Gerichtsstand: Amberg
 Steuernummer: 201/118/51825
 USt.-ID-Nummer: DE 273143997
 Geschäftsführer: Dr. Martin Nagler