Bug #42783 Can't increase the max open file number for MySQL Proxy
Submitted: 12 Feb 2009 8:20 Modified: 17 Aug 2009 15:09
Reporter: Joshua Zhu (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Proxy Severity:S2 (Serious)
Version:bzr rev570 OS:Linux
Assigned to: MC Brown CPU Architecture:Any
Tags: Contribution

[12 Feb 2009 8:20] Joshua Zhu 
Description:
MySQL Proxy can't increase its max open file number, when the value of `ulimit -n` is less than 8192. The debug information is not correct on 32 bit systems either.

How to repeat:
mysql-proxy --log-level=debug

Suggested fix:
I'll commit a fix to the Bazaar repository soon.
[12 Feb 2009 8:37] Joshua Zhu 
The fix is now here: https://code.launchpad.net/~zhuzhaoyuan/mysql-proxy/zhuzhaoyuan (revision 570)
[13 Feb 2009 21:45] Sveta Smirnova 
Thank you for the report.

Verified as described.
[11 Jun 2009 16:09] Diego Medina 
Verified fixed on 0.7.1

You now see:

sbin/mysql-proxy --log-level=debug
(message) mysql-proxy 0.8.0 started
(debug) chassis.c:987: current RLIMIT_NOFILE = 256 (hard: 9223372036854775807)
(debug) chassis.c:991: trying to set new RLIMIT_NOFILE = 8192 (hard: 9223372036854775807)
(debug) chassis.c:999: set new RLIMIT_NOFILE = 8192 (hard: 9223372036854775807)
[17 Aug 2009 15:09] MC Brown 
A note has been added to the 0.7.1 changelog: 

MySQL Proxy would be unable to increase it's own maximum number of open files accorindg to the applied limit, if the limit was less than 8192. When set to debug level, MySQL Proxy will now report the open files limits and when the limits have been updated.