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 Desktop Bugs, which is subscribed to systemd 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 -- desktop-bugs mailing list desktop-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/desktop-bugs