[Bug 1434758] Re: mysqld: errno: 24 - Too many open files
@cooolman do you have this file on your system `/lib/systemd/system/mysqld.service` ? I'm not sure why but if you boot with systemd you are supposed to set the limits in service file first: LimitNOFILE=infinity LimitMEMLOCK=infinity After that mysqld service will be allowed to open more connection ( as per your setting in my.cnf ) On my system `/lib/systemd/system/mysqld.service` is missing. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to the bug report. https://bugs.launchpad.net/bugs/1434758 Title: mysqld: errno: 24 - Too many open files To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1434758/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1434758] Re: mysqld: errno: 24 - Too many open files
I re-added systemd because It affect the systemd boot option so I think it is good to have it listed with other problems with systemd and vivid. ( maybe it is bad idea in that case remove it ) ** Also affects: systemd (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to the bug report. https://bugs.launchpad.net/bugs/1434758 Title: mysqld: errno: 24 - Too many open files To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1434758/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1434758] Re: mysqld: errno: 24 - Too many open files
I'm a developer and I have 3/5 db on my machine, each one with many table ( 100+ ) however the main point is that using upstart I don't have issues, ideally the systemd behavior should be the same ... On my machine, I'm on 15.04, /lib/systemd/system/mysqld.service is missing, which package provide it ? - I have searched the file with apt-file and dpkg -l (mysql-server-5.6 and mysql-sever-core-5.6) but there is no track of it. I have manually created that file with the following content, but I still have the issue: [Service] LimitNOFILE=infinity LimitMEMLOCK=infinity It will be great if you can share the content of your `mysqld.service` so I can add it manually. Does I need to link this file some where ? -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.6 in Ubuntu. https://bugs.launchpad.net/bugs/1434758 Title: mysqld: errno: 24 - Too many open files To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1434758/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1434758] Re: mysqld: errno: 24 - Too many open files
** Package changed: mysql-5.5 (Ubuntu) = mysql-5.6 (Ubuntu) -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.6 in Ubuntu. https://bugs.launchpad.net/bugs/1434758 Title: mysqld: errno: 24 - Too many open files To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1434758/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1434758] [NEW] mysqld: errno: 24 - Too many open files
Public bug reported: After upgrading to 15.04 mysql cannot set the file limit and so it doesn't work well. /var/log/mysql/error.log shows the following: [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) [Warning] Buffered warning: Changed limits: table_cache: 431 (requested 2000) [ERROR] /usr/sbin/mysqld: Can't open file: ... (errno: 24 - Too many open files) The issue looks to be related to the recent switch to systemd indeed if I start using upstart everything work fine. I found out similar issues reported on Debian and the general suggestion is to add following line to the `mysqld.service` anyway this file is not present on my installation : LimitNOFILE=infinity LimitMEMLOCK=infinity Other distro stores this file in `/usr/lib/systemd/system/mysqld.service` I'm not sure how Ubuntu is managing this, maybe with file in dir /etc/default/ ? I have also tried adding following lines in /etc/security/limits.conf, but the problem persist: mysql soft nofile 65535 mysql hard nofile 65535 ProblemType: Bug DistroRelease: Ubuntu 15.04 Package: mysql-server (not installed) Uname: Linux 3.19.2-031902-generic x86_64 ApportVersion: 2.16.2-0ubuntu4 Architecture: amd64 CurrentDesktop: Unity Date: Sat Mar 21 10:17:00 2015 InstallationDate: Installed on 2014-03-10 (375 days ago) InstallationMedia: Ubuntu 14.04 LTS Trusty Tahr - Alpha amd64 (20140309) SourcePackage: mysql-5.5 UpgradeStatus: Upgraded to vivid on 2015-03-20 (0 days ago) ** Affects: mysql-5.5 (Ubuntu) Importance: Undecided Status: New ** Affects: systemd (Ubuntu) Importance: Undecided Status: New ** Tags: amd64 apport-bug mysqld systemd-boot vivid ** Also affects: systemd (Ubuntu) Importance: Undecided Status: New ** Summary changed: - mysqld systemd - errno: 24 - Too many open files + mysql: errno: 24 - Too many open files ** Summary changed: - mysql: errno: 24 - Too many open files + mysqld: errno: 24 - Too many open files ** Tags added: systemd-boot ** Description changed: After upgrading to 15.04 mysql cannot set the file limit and so it doesn't work well. /var/log/mysql/error.log shows the following: [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) [Warning] Buffered warning: Changed limits: table_cache: 431 (requested 2000) [ERROR] /usr/sbin/mysqld: Can't open file: ... (errno: 24 - Too many open files) The issue looks to be related to the recent switch to systemd indeed if I start using upstart everything work fine. I found out similar issues reported on Debian and the general suggestion is to add following line to the `mysqld.service` anyway this file is not present on my installation : LimitNOFILE=infinity LimitMEMLOCK=infinity + Other distro stores this file in `/usr/lib/systemd/system/mysqld.service` + I'm not sure how Ubuntu is managing this, maybe with file in dir /etc/default/ ? + + I have also tried adding following lines in /etc/security/limits.conf, + but the problem persist: + + mysql soft nofile 65535 + mysql hard nofile 65535 + ProblemType: Bug DistroRelease: Ubuntu 15.04 Package: mysql-server (not installed) Uname: Linux 3.19.2-031902-generic x86_64 ApportVersion: 2.16.2-0ubuntu4 Architecture: amd64 CurrentDesktop: Unity Date: Sat Mar 21 10:17:00 2015 InstallationDate: Installed on 2014-03-10 (375 days ago) InstallationMedia: Ubuntu 14.04 LTS Trusty Tahr - Alpha amd64 (20140309) SourcePackage: mysql-5.5 UpgradeStatus: Upgraded to vivid on 2015-03-20 (0 days ago) -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.5 in Ubuntu. https://bugs.launchpad.net/bugs/1434758 Title: mysqld: errno: 24 - Too many open files To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.5/+bug/1434758/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
