Bug #42783 Can't increase the max open file number for MySQL Proxy
Submitted: 12 Feb 2009 9:20 Modified: 17 Aug 2009 17:09
Reporter: Joshua Zhu (SCA)
Status: Closed
Category:Proxy Severity:S2 (Serious)
Version:bzr rev570 OS:Linux
Assigned to: MC Brown Target Version:
Tags: Contribution
Triage: Needs Triage: D3 (Medium)

[12 Feb 2009 9: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 9:37] Joshua Zhu 
The fix is now here: https://code.launchpad.net/~zhuzhaoyuan/mysql-proxy/zhuzhaoyuan
(revision 570)
[13 Feb 2009 22:45] Sveta Smirnova 
Thank you for the report.

Verified as described.
[11 Jun 2009 18: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 17: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.